Convert to Boolean | ConvertToBoolean({Input})
| Returns a Boolean representation of the input value. | Input: ConvertToBoolean(“true”) Result: true |
Equals | {FieldA}={FieldB}
| Returns true if {FieldA} equals {FieldB}, false if not. | Input: 12 = 12 Result: true |
Greater Than | {FieldA}>{FieldB}
| Returns true if {FieldA} is greater than to {FieldB}, false if not. | Input: 7 > 3 Result: true |
Greater Than or Equal To | {FieldA}>={FieldB}
| Returns true if {FieldA} is greater than or equal to {FieldB}, false if not. | Input: 7 >= 7 Result: true |
Is Boolean | IsBoolean({Input})
| Returns true if {Input} is a Boolean value, false if not. | Input: IsBoolean(false) Result: true |
Is Date | IsDate({Input})
| Returns true if {Input} is a date value, false is not. | Input: IsDate(1636140582813) Result: true |
Is Empty | IsEmpty({Input})
| Returns true if {Input} is empty, false is a value is present. | Input: IsEmpty("") Result: true |
Is In List | IsInList({Value},[{Item In List}])
| Returns true if {Value} is found in {Item In List}. Include additional items in the {Item In List} array to search those for the provided {Value}. | Input: IsInList({LastNameField}),["Marsten, Matthews, Morgan"] Result: If LastNameField includes "Morgan" = true Result: If LastNameField includes "Van der Linde" = false |
Is Number | IsNumber({Input})
| Returns true is {Input} is a number, false if not. | Input: IsNumber(7) Result: true |
Less Than | {FieldA}<{FieldB}
| Returns true if {FieldA} is less than {FieldB}, false if not. | Input: 7 < 3 Result: false |
Less Than or Equal To | {FieldA}<={FieldB}
| Returns true if {FieldA} is less than or equal to {FieldB}, false if not. | Input: 3 <= 7 Result: true |
Logical AND | {FieldA}AND{FieldB}
| Result of the logical AND between two Boolean inputs. Returns true if both operands are true, false if not. | Input: true AND true Result: true |
Logical OR | {FieldA}OR{FieldB}
| Result of the logical OR between two Boolean inputs. Returns true if one or both of the operands is true, false if not. | Input: true OR false Result: true |
Not | Not({Field})
| Returns the opposite value of the provided value. | Input: Not(true) Result: false |
Not Equal To | {FieldA}!={FieldB}
| Returns true if {FieldA} does not equal {FieldB}, false if {FieldA} and {FieldB} are equal to each other. | Input: 3 != 13 Result: true |
OCR Output Contains Words | OcrOutputContainsWords({OcrOutput},{WordsToFindArray},{IgnoreCase},{Separator})
| Checks whether an OCR output contains the specified {WordsToFindArray}. This formula's accuracy is dependent on the correctness of the OCR output. | Input: OcrOutputContainsWords("extractedText":"This is a test", "this test", "true", " ") Result: true |
Starts With | StartsWith({InputString}, {InputSubstring})
| Checks whether the {InputString} string begins with the characters specified in {InputSubstring} and returns true or false. The comparison is case-sensitive. | Input: StartsWith(“Hello”, “he”) Result: false |