function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
mweldonmweldon 

Billing Zip Code Is in Billing State - Validation Rule

I want to create the Account Address validation rule for Billing Zip Code is in Billing State https://na4.salesforce.com/help/doc/en/salesforce_useful_validation_formulas.pdf

 

My question is on creating the Zip Code custom object.  I can create a new custom object, but I'm not sure how to create the records for every valid zip code and State in that custom object.

jaredemillerjaredemiller

You can import the records into the custom object using the Import Wizard or the Data Loader.  I just did a quick Google search and there are some places where you can get a completed list of Zip Codes. I think the U.S. Post Office will sell the list in csv format too.