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
theisglogantheisglogan 

How to list county from zip code

Hello, I am looking for a way to find out bu Zipcode which County it belongs to. I do have a excel file of the county by zip but need a way to autopopulate this field on the account level. Thank you in advance for any suggestions.

Example,
User enters Zipcode 76180 and saves,
Once record is saved it'll populate the County field on the account.
AnkaiahAnkaiah (Salesforce Developers) 
Hi Logan,

Refer the below appexchange product will fulfill your need.
https://appexchange.salesforce.com/listingDetail?listingId=a0N3000000B3izXEAR&_ga=2.110172101.1171726458.1651418499-1133398107.1628593736

If you dont want to use it, then go for custom solution.

1. Create an object that contains the data that the zip codes.
 
2. Create a trigger for Account created or edited.
 
3. Use the zip code to look up the city and county in the custom object, and fill in the field on the account.

If this helps, please mark it as best answer.

Thanks!!
theisglogantheisglogan
Would this been done in APEX or another way?
Theodore HardinTheodore Hardin
Thanks for sharing, I found a lot of interesting information here. A really good post, very thankful and helpful that you will write many more posts like this one.

https://www.greenskyonline.me/