Skip to main content

Boolean

Operation

Format

Description

Example

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 {Item In List} is found in {Value}. Include additional items in the {Item In List} array to search for those in 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