Validation rule: US_Postal_Codes_in_Permanent_Address

Name

US_Postal_Codes_in_Permanent_Address

Label

US_Postal_Codes_in_Permanent_Address

Object

Account

Active

No

Formula

AND(
OR( AQB__AccountDefaultCountry__c = "USA", AQB__AccountDefaultCountry__c = "United States", AQB__AccountDefaultCountry__c = "US",ISBLANK(AQB__AccountDefaultCountry__c)),
LEN( AQB__AccountDefaultCity__c ) > 0,
NOT(REGEX( AQB__AccountDefaultZipCode__c , "\\d{5}(-\\d{4})?"))
)

Error message

Zip code must be in 99999 or 99999-9999 format.

Error location

Permanent Add Zip/Postal Code