Formula grammar consists of basic values, field references, operators, functions, and parentheses. After you understand these elements, you can write formulas for calculations, conditions, and text processing.
Basic Elements
| Element | Syntax | Description |
|---|
| String | 'Hello' or "World" | Text wrapped in single or double quotes |
| Integer | 123, -456 | A number without a decimal point |
| Decimal | 12.34, -45.67 | A number with a decimal point |
| Boolean | TRUE, FALSE | A true or false value |
| Field reference | {age} | A field name wrapped in {}. The name must match the actual field name |
Operators
Operators in formulas are used to connect or compare values:
| Type | Operators | | |
|---|
| Math | +, -, *, /, % | | |
| Comparison | >, <, >=, <=, =, != | | |
| Logic | &&, ` | | ` |
Function Calls
You can call functions within formulas. A function call consists of a function name, a pair of parentheses, and parameters inside the parentheses. Parameters are separated by commas.
For example, sum(1, 2, 3) calls the sum function with three parameters: 1, 2, and 3.
Other Structures
| Structure | Description |
|---|
| Parentheses | Change operation precedence, such as (1 + 2) * 3 |
| Comments | Add context. Block comments use /* */, and line comments use // |
| Whitespace and line breaks | Usually ignored, but they can make formulas easier to read |
Last modified on May 26, 2026
