Validation rule: US_Postal_Codes_in_Shipping_Address

Name

US_Postal_Codes_in_Shipping_Address

Label

US_Postal_Codes_in_Shipping_Address

Object

Account

Active

No

Formula

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

Error message

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

Error location

Account.ShippingPostalCode