Follow

Formula Operators & Functions

IMPORTANT NOTE - FORMULA BUILDER HINTS

 

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.

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.

More broadly, we make use of hints heavily through the platform 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.

 

EXAMPLES OF COMMONLY USED FUNCTIONS - SEE FORMULA BUILDER FOR FULL, UP TO DATE LIST

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

 

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk