EXACT
Compares two text values and returns TRUE if they are exactly the same, FALSE otherwise. EXACT is case-sensitive.
Use
EXACT( text1, text2 )
Checks to see if two text or choice values are identical (case-sensitive).
| Parameter | Required | Description |
|---|---|---|
| text1 | Yes | the first text or choice value |
| text2 | Yes | the second text or choice value |
| Returns | Logical |
Examples
Validation Logic (Ensuring Two Fields Match)
In an Output Validation Formula, you can use EXACT to ensure that a user has entered identical information in two different fields, which is often used for security or data integrity checks.
- Scenario: You want to verify that a "Confirmation Code" entered in the current field exactly matches a "Reference Code" provided during the trigger step.
- Formula:
EXACT(this, @Trigger.out.ReferenceCode) - Logic:
this: Refers to the current output being validated.@Trigger.out.ReferenceCode: Refers to the output data from the trigger step.- Outcome: If the trigger code was "AZ-99" and the user enters "az-99", the formula will return FALSE because the function is case-sensitive. It will only return TRUE if the user enters "AZ-99".
Conditional Logic (Matching a Specific Literal)
You can use EXACT in Conditional Logic formulas to show or hide form elements based on whether a user's input matches a specific literal text string.
- Scenario: You have a form where a "Special Discount" field should only be visible (the Show when property) if the user types a specific promotional code, such as "SUMMER24".
- Formula:
EXACT(@Trigger.out.PromoCode, "SUMMER24") - Logic:
- The Form Builder evaluates the formula. If the text in the
PromoCodefield is an exact, case-sensitive match for "SUMMER24", the formula returns TRUE and the element is shown. - If the user types "Summer24" or "summer24", the formula returns FALSE and the element remains hidden.
- The Form Builder evaluates the formula. If the text in the