Compare the value of fields

The "Field Compare" condition compares the value of one or more selected fields against a specified value or formula using a chosen comparison operator. This condition is useful for triggering actions when a field meets criteria such as being equal to, less than, greater than, or containing specific text.

Properties and Explanation

To use this condition, configure the following settings:

• Field Name: Select one or more fields whose values will be compared.

• Condition: Choose the comparison operator, such as less than, less than or equal to, equal to, greater than or equal to, greater than, contains text, or contains text (case insensitive).

• Value: The value or formula to compare against the selected field(s). This can be a static value or a formula that is evaluated at runtime.

Example Usage

Suppose you want to check if the Field Name "Age" is greater than 18:

• Set Field Name to "Age".

• Set Condition to "greater than".

• Set Value to "18".

If the condition is true, the associated actions (such as showing a message or enabling a button) will be triggered.