Quick Start

How to use this manual

• New to formulas: start with "Basics".
• Looking up a specific function: go to "Function index"; every function has its own reference page.
• Solving a concrete use case: go to "Formula snippets", find a similar example, then change the property names.
• Working with complex formulas, errors, or long-term maintenance: go to "Writing and troubleshooting".

Common entry points

• Function reference table
• Logic and condition functions
• Text functions
• Number and math functions
• Date and time functions
• List functions
• Common formula snippets
• Common errors and troubleshooting

Shortest learning path for beginners

Learn in this order instead of memorizing every function at once:

1. Reference properties: prop("Property Name")
2. Do basic math: +, -, *, /
3. Handle conditions: if(), ifs(), empty()
4. Work with text: format(), +, contains(), replaceAll(), trim()
5. Work with dates: today(), now(), dateAdd(), dateBetween(), formatDate()
6. Work with lists: map(), filter(), length(), join(), first()
7. Write variables: let(), lets()
8. Break down complex formulas into helper properties first, then merge them into one formula
9. Debug type errors, empty values, depth limits, and list-versus-single-value mistakes