Logic

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