Create Validation Rules: Formulas and Validations

Question

Hi guys! Im having this error. Ive used Valid Billing Country to validate. Please some guidance with why I get this error. Thanks!

Archana Panda · Accepted Answer

Hi,

Add a validation rule which will block the saving of a new or updated contact if the contact is related to an account and has a mailing postal code (which has the API Name MailingPostalCode) different from the account’s shipping postal code (which has the API Name ShippingPostalCode).
Name the validation rule Contact must be in Account ZIP Code
A contact with a MailingPostalCode that has an account and does not match the associated Account ShippingPostalCode should return with a validation error and not be saved
The validation rule should ONLY apply to contact records with an associated account. Contact records with no associated parent account can be added with any MailingPostalCode value. (Hint: you can use the ISBLANKfunction for this check)

AND (

NOT(ISBLANK( AccountId )),

MailingPostalCode <> Account.ShippingPostalCode

)

Please check similar discussions:

Trailhead