Formula Builder

Formula Builder can be used to create calculated and concatenated values which can be displayed using a calculated value control which will display at run time. The Formula Builder is different from inline functions as the inline functions are resolved on form load at run time.

Formula behavior

Depending on the composition of the formula, the value that is displayed in the calculated value control will always calculate to reflect the current values entered in named controls that are included in the formula.

The formula builder supports Named Controls. A Named Control is when a control that has been added to the form is given a name. Most controls can be named by setting the Name property within the General section of the control.

Not all controls are supported in runtime functions. Supported control types in runtime formulas include:

• Yes/No
• Calculation
• Choice
• Date time
• Geolocation
• Single line of text
• Lookup
• Multiline text box
• People

Form variables can also be referenced in runtime expressions.

If the data type of all the values in the formula is a number, the formula will calculate the value.

String concatenations can be created by including the "+" symbol between named controls and string or number values.

Use the Runtime Functions

The runtime functions can be used to perform calculations for a set of values.

Examples of use:

• To add two named controls called "intValue1" and "intValue2": intValue1+intValue2
• To total all the values for a named control called "decAmount" that is within a repeating section: sum(decAmount)
• To create a concatenation of a named control called "txtValue1" that holds a string value and a number: 1+txtValue1 ; Note other string values can be added to create other expressions. e.g. 1+"-"+txtValue1

Related information

Calculated Value control

Insert reference fields

Configure controls

Runtime functions