+ Start a Discussion
tushar mahaduletushar mahadule 

valiodation

Hii guys please help me to solve this task :
To complete this challenge, add a validation rule which will block the insertion of a 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 inserted.
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 ISBLANK function for this check)
 
Veenesh VikramVeenesh Vikram
Hi Tushar,

Below Condition will work:
NOT(ISBLANK( AccountId )) && MailingPostalCode <> Account.ShippingPostalCode

Kindly mark this as Answer if this helps you

Veenesh
Amit Chaudhary 8Amit Chaudhary 8
Please check below post for same issue
1) https://developer.salesforce.com/forums/?id=906F0000000BOHUIA4
2) https://developer.salesforce.com/forums/?id=906F0000000BIQlIAO
 
AND( 
NOT(ISBLANK(AccountId)), 
MailingPostalCode != Account.ShippingPostalCode 
)
User-added image

Let us know if this will help you

Thanks
Amit CHaudhary