/
Validation rule: US_Postal_Code_in_Mailing_Address

Attention: Confluence is not suitable for the storage of highly confidential data. Please ensure that any data classified as Highly Protected is stored using a more secure platform.
If you have any questions, please refer to the University's data classification guide or contact ict.askcyber@sydney.edu.au

Validation rule: US_Postal_Code_in_Mailing_Address

Owned by praveen.sampath
Aug 16, 2024
1 min read

Validation rule Details

Name

US_Postal_Code_in_Mailing_Address

Label

US_Postal_Code_in_Mailing_Address

Object

Contact

Active

No

Formula

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

Error message

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

Error location

Contact.OtherPostalCode

Related content

Validation rule: US_Postal_Codes_in_Shipping_Address
Validation rule: US_Postal_Codes_in_Shipping_Address
TAP - Advancement Portfolio Product
More like this
Validation rule: US_Postal_Codes_In_Address
Validation rule: US_Postal_Codes_In_Address
TAP - Advancement Portfolio Product
More like this
Validation rule: US_Postal_Codes_in_Billing_Address
Validation rule: US_Postal_Codes_in_Billing_Address
TAP - Advancement Portfolio Product
More like this
Validation rule: US_Postal_Codes_in_Permanent_Address
Validation rule: US_Postal_Codes_in_Permanent_Address
TAP - Advancement Portfolio Product
More like this
Validation rule: Canadian_Postal_Code_in_Mailing_Address
Validation rule: Canadian_Postal_Code_in_Mailing_Address
TAP - Advancement Portfolio Product
More like this
Validation rule: Candian_Postal_Codes_in_Address
Validation rule: Candian_Postal_Codes_in_Address
TAP - Advancement Portfolio Product
More like this