For the unit named above, part of the formula requires you create a not equals rule but one of them I cannot find in the dropdown. The hands on section tells you to use MailingPostalCode but i'm getting the error that it doesn't exist. I've spent an hour on this...
AND( Not(ISBLANK(Id)), ( ShippingPostalCode ) <> ( MailingPostalCode ) )
1 件の回答
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:
Please refer-
https://trailhead.salesforce.com/de/trailblazer-community/feed/0D54S00000E9l5cSAB
