Formula Operators & Functions

For the latest information on Formula Operators and Functions, check out our built-in reference inside the Formula Builder dialog on our web platform. 

Whenever you see a "hammer" icon appear next to a field, you can click this icon to launch the Formula Builder.

For example in the Form designer, if you click on a form field, then hover over the Visibility property on the right hand side, you'll see the "hammer" icon appear.

Open

Once in the Formula Builder, the list of available formula functions will appear on the right hand side of the dialog as a drop down field.

When you click the drop down, the list of functions displays, and if you mouse over these you should see detailed hints appear next to most of these functions.

These hints explain how to use each function.

When you click a function in the list, you'll see it added to the formula text area with placeholders for the required inputs.

Open

More broadly, we make use of hints heavily through Aeros COLLECT to explain how functionality works.

Whenever you see text with a dashed underline, there's a hint available.

We often put quite detailed text into these hints, so they are always worth checking out.

Commonly Used Examples

Contextual Functions

Math Functions

NOTE: You must put a space between your math operators in formulae - e.g. {{price1}}-{{price3}} is not valid, but {{price1}} - {{price3}} is.

Text/String Functions

Repeatable Group Functions

Logic Functions

Data Conversion Functions

Choices Functions