-
How to get the city or state information based on zip code?
How to get the city information based on zip code?
Note: Taking care of the possibilty that two cities may share same zip code.
-
2 Replies
-
Hi Utsav,
There are a few third party apps on the app exchange that will help you do this.
http://appexchange.salesforce.com/listingDetail?listingId=a0N30000002zt9uEAA.
If you don't want to use third party App then you have to do some tedious work :
Create a custom object for zip codes where the name field is the Zip Code. Add a text fields to this object for City . Upload all of your zip codes/city to this new object using the data loader or manually create each one, but that sounds painful.
Add a look-up relationship field to the object that you want that is related to this new Zip Code object.
The end user can point this new field to the appropriate Zip Code object by searching the zip code numbers. A formula(s) or work rule can then be used to pull the city into a field(s) on the main object.
-
To get the city or state information based on Zip code, what you can do is create a map with zip code as a key and query to obtain the required values.
Log In to reply.
Popular Salesforce Blogs
What Must ISVs Know Before Integrating With Salesforce?
A lot of enterprises depend on Salesforce for many of their business processes ranging from marketing automation to sales process management. They don’t’ all use…
What are Salesforce Flows? | The Ultimate Guide
Salesforce Flows is a powerful tool that allows users to automate business processes and simplify tasks within the Salesforce platform. Flows are a visual, declarative…
5 Salesforce Lightning Features You're Missing Out On
Personalities praised for being bold, unique and intuitive deserve a working environment that reflects the same. Salesforce has transitioned from data entry focused on workflow…
Popular Salesforce Videos
How to Use Salesforce for Project Management
When you think of CRM software, "Salesforce" is probably one of the first words that comes to mind. But Salesforce can do so much more…
Salesforce FY19 Year in Review
FY19 was our best year yet. With new partnerships and friends, we blazed new trails and continued creating a better future, together. Thank you to…
How to Create Your First Salesforce Lightning Component?
OpFocus walks through the steps you need to know to create your first Salesforce Lightning Component.
