Function
|
Name
|
Description
|
= |
Equal To |
|
< |
Less Than |
|
> |
Greater Than |
|
OR |
Or |
|
AND |
And |
|
NOT(val) |
Not |
|
TRUE() |
True |
|
FALSE() |
False |
|
IF(condition, 'true val', 'false val') |
Conditional (if/else) |
Lets you return one of two values based on whether the given condition is true or false. Useful for toggling a field’s dynamic value based on previous answers. eg IF({{score}} = 50, ‘YOU PASS’, ‘YOU FAIL’) |
ISBLANK(val) |
Is Blank or Empty |
Returns true/false based on whether the given value is blank/empty. An easy way to check if a field has no answer. |
NOTBLANK(val) |
NOT Blank or Empty |
Returns true/false based on whether the given value is not blank/empty. An easy way to check if a field has any answer. |
COALESCE(val1, val2) |
First Non-Empty Value (coalesce) |
Use this function when you want to guarantee a non-blank value is returned. This is useful when doing scoring calculations – wrap each answer in a COALESCE({{answer}}, 0) to ensure you get a zero if the user has not provided an answer. |
REGEX(input, pattern) |
Regular Expression Match |
Returns true/false based on whether the regular expression finds a match in the input string. Regular expressions are a very powerful, advanced feature. ‘http://msdn.microsoft.com/en-us/library/hs600312(v=vs.110).aspx’ Learn about regular expressions ‘http://msdn.microsoft.com/en-us/library/sdx2bds0(v=vs.110).aspx’ Learn more about the match function |