Skip to main content
Topics#FormulasDomanda di khushbu dubey
khushbu dubey ha fatto una domanda in #Formulas
22 mar 2016, 07:04

WHAT IS VALIDATION RULE FOR POSTAL CODE??

6 risposte
  1. Head In Cloud (Head In Cloud)
    22 mar 2016, 08:27
    Hi ,

    Validates that the account Billing Zip/Postal Code is in the correct format ifBilling Country is Canada.

    AND(

    OR(BillingCountry = "CAN", BillingCountry = "CA", BillingCountry = "Canada"),

    NOT(REGEX(BillingPostalCode,

    "((?i)[ABCEGHJKLMNPRSTVXY]\\d[A-Z]?\\s?\\d[A-Z]\\d)?"))

    )

    For more detail please review the following link

    https://help.salesforce.com/HTViewHelpDoc?id=fields_useful_validation_formulas_account_address.htm&language=en_US

    Hope this helps you!

    Thanks