| Purpose | Function |
| User's Email Address | USEREMAIL() |
| User's First Name | USERFIRSTNAME() |
| User's Last Name | USERLASTNAME() |
| User's External Id | USEREXTERNALID() |
| Value Matches Current User | USERINGROUP() |
| Organisation Name | ORGNAME() |
| Global Value | GLOBALVAL('keyname') |
| Organisation Meta Value | ORGMETA('key') |
| User Meta Value | USERMETA('key') |
| Device Name | DEVICENAME() |
| Operating System Name | DEVICEOS() |
| Operating System Version | DEVICEOSVERSION() |
| Current App Version | APPVERSION() |
| Current Screen Version | SCREENVERSION() |
| Screen Last Updated (UTC) | SCREENDATE() |
| Direct Value | VAL('dataname') |
| Screen Parameter | COUNTER() |
| Purpose | Function |
| Current Date | TODAY() |
| Current Date and Time | NOW() |
| Current UTC (GMT) Date | UTCTODAY() |
| Current UTC (GMT) Date & Time | UTCNOW() |
You must put a space between mathematical operators. e.g. {{price1}}-{{price3}} is not valid, but {{price1}} - {{price3}} is valid.
| Purpose | Function |
| Add | + |
| Subtract | - |
| Multiply | * |
| Divide | DIV |
| Greater than Greater than or equal | > >= |
| Less than Less than or equal | < <= |
| Rounding | ROUND(value, decimals) |
| Purpose | Function |
| Join bits of text together | CONCAT(value1, value2, ...) |
| Get part of a piece of text | |
| Length of a piece of text | STRING-LENGTH(value) |
| Join values with a separator | JOIN(separatorString, value1, value2, ...) |
| Purpose | Function |
| Add repeated values | SUM(repeatname) |
| Join repeat answers with a separator | JOIN(separatorString, repeatvalue) |
| Count no of repeats | COUNT(repeatname) |
| Maximum from a list of repeated values | MAX(repeatname) |
| Minimum from a list of repeated values | MIN(repeatname) |
| Purpose | Function |
| Not | NOT(expression) |
| And | AND |
| Or | OR |
| True | TRUE() |
| False | FALSE() |
| Regularly used expressions | REGEX(expression) |
| Equal to | = |
| Conditional (If) | IF(condition, a, b) |
| First non-empty value | COALESCE(a, b) |
At least X of At most X of | CHECKLIST(min, max, v1, v2, v3, ..., vn) |
| Purpose | Function |
| Convert to number | NUMBER(value) |
| Convert to string | STRING(value) |
| Convert to date | DATE(value) |
| Convert text to True/False | BOOLEAN-FROM-STRING(value) |
| Convert Date to text in a particular format | FORMAT-DATE(value, format) |
| Purpose | Function |
| Check if an answer is selected | SELECTED(dataname, value) |
| Count selected items | COUNT-SELECTED(dataname) |
