Documentation Index
Fetch the complete documentation index at: https://help.teable.ai/llms.txt
Use this file to discover all available pages before exploring further.
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 |
