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.