Skip to main content

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).

ParameterRequiredDescription
text1Yesthe first text or choice value
text2Yesthe second text or choice value

ReturnsLogical

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 PromoCode field 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.