Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Brock NortonBrock Norton 

Error: Field ShippingPostalCode does not exist. Check spelling.

How is this possible when I'm selecting SF's own insert field values and it is populating them?
AshishyadavAshishyadav
are you doing like this Account.ShippingPostalCode , if you are mentioning ShippingPostalCode only it will give you an error
Could you be more descriptive where you are using and how?
Brock NortonBrock Norton
Yes. I need to create a validation rule to check that a contact is in the zip code of its account. Here are the directions: 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) Here is my Error Condition Formula: ISBLANK(MailingPostalCode | P: 877.210.0126 | F: 801.853.4089 LinkedIn | Customer Testimonials | Sales Rep Best Practices [http://insidesales.com/images/email-sig-banner.png]? ****** Stop copying here ******?
arvind bhandari 8arvind bhandari 8
Select fields as shown in below manner 
Account.ShippingPostalCode

User-added image



User-added image

This is the  formula
AND((MailingPostalCode <> Account.ShippingPostalCode), NOT(ISBLANK( Account.Name )))
Meric AsanerMeric Asaner
Date: November 15th 2021
Trail: Formulas and Validations --> Create Validation Rules
Error: Field MailingPostalCode does not exist. Check spelling.

Solution: Instead of writing MailingPostalCode try writing BillingPostalCode 
Ashwin Kumar 86Ashwin Kumar 86
This is my full code - 
AND(
NOT(ISBLANK( Id )),
BillingPostalCode <> ShippingPostalCode
)
Not seeing any issue with the Syntax either. But, get this error every time I ty completing the topic "We can't find a reference to the account 'ShippingPostalCode' field in the validation rule"
Ashwin Kumar 86Ashwin Kumar 86
Get this error if I append "ShippingPostalCode" with "Account." -  " Field Account does not exist. Check spelling."
Hardik Rola 6Hardik Rola 6

To Complete the Challenge, 
Instead of creating Validation Rule in Account. Create a Validation Rule in Setup->Object_Manager-> Contact.


AND
(
NOT (ISBLANK(AccountId)),
MailingPostalCode <> Account.ShippingPostalCode
)
Teresa van OerleTeresa van Oerle
Thank you Hardik! I faced the same problem and your tip worked!!