Formula column type
Error types in the formula column type
#error - syntax error
#type - operation error (operation could not be executed using different column types)
Formulas as an aggregation function
You can use formula as an aggregation operation in other columns.
It provides you the flexibility to operate grid data in different ways.
This feature is available for all column types, supported by the Table Grid Next Generation.
Following operations are available:
mathematical operations with numbers: addition, subtraction, multiplication, division;
date subtraction - it's possible to use Moments.js library;
- userlist operation
To run the formula when columns have empty values check the checkbox in the column configuration as below.
If you want to make the column values searchable - enable the Index data checkbox.
The column ID is a variable, use it in the following format: $(yourColumnId).
Use return as a keyword to get the formula result.
Userlist in formula
Use the following example to display Userlist column type in the formula
Below you can find formula examples with most common expressions.
Condition with numbers
This example shows how to provide exam results, based on the conditions specified in the formula. You can use conditions in the formula with all available column types.
This example shows how to subtract Date. You can use Date, Time, DateTime column types.
This example shows how to use checkbox column type in condition formula.
This example shows how to concatenate a string column type.