Variables
Last updated
Last updated
You can create variables within a form and with the help of functions feature set up complex calculations, conditions, conditional styling and etc.
Below is example of setting up variable and using it for conditional hiding a section.
Form in the example below is tied up to Account object
Open "Tools" menu(1) and click "Variables" option (2):
On "Variables" popup click "Add Variables" button (3):
Provide variable "Name" (4), set variable "Type" (5) and click pencil icon (6) to open value builder:
Choose context object (7) and object field (8). Click "+" button to insert merged field (9):
For more information about working with context objects please refer following documentation chapter:
Select Function (10) to use and click "+" button (10) to insert function:
Now using merged field and functions build an expression (12) and click "Save" (13).
To use the functions or calculations inside of variable you have to build a formula like: FORMULA[SQRT(4) + (2*3)]
Above expression first casts number typed value to text and then checks if final string ends with '9'. It will return 'true' if string does end with '9' and 'false' if it doesn't.
Save variable (14) and save the form (15):
Button "Dependencies" (16) helps to find where this variable is used.
Select Section title and create new Conditional style using configured variable:
Above conditional style will hide section if 'Account Number' value ends with symbol other than '9' and will show it for cases when it ends with '9'.