Salesforce Formulas Builder by Saransh Paliwal

Author:Saransh Paliwal
Language: eng
Format: epub
Publisher: CoalCloud

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

AND(

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

BillingCountry = "Canada"),

NOT(REGEX(BillingPostalCode,

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

)

Validates that the account Billing Zip/Postal Code is valid by looking up the first five characters of the value in a custom object called Zip_Code__c that contains a record for every valid zip code in the US. If the zip code is not found in the Zip_Code__c object, or the Billing State does not match the corresponding State_Code__c in the Zip_Code__c object, an error is displayed.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.