State and country pick list - Answers - Salesforce Trailblazer Community
Trailblazer Community
Ask Search:
Catherine TimoteoCatherine Timoteo 

State and country pick list

Before I enable this for my organization, I'd like to know if all states are on pick list or if only states that pertain to country selected.  For example, if the Country Canada is selected, will I only have Canadian states/provinces to chose from or will I need to go through a list of hundreds of states?  Thanks
Best Answer chosen by Catherine Timoteo
Jeff MayJeff May
When the user selects a Country, the available State picklist choices are only those you have enabled for that Country.

All Answers

Jeff MayJeff May
When the user selects a Country, the available State picklist choices are only those you have enabled for that Country.
This was selected as the best answer
Catherine TimoteoCatherine Timoteo
Awesome, thanks!  
Catherine TimoteoCatherine Timoteo
Hi Jeff!  Now that I have the state & country code enabled, is it possible to have the 2 letter Country/Territory Code populated on leads/contacts?  I'm not showing it as an option on the page layout or reports.  Thanks!
Jeff MayJeff May
The State Name is in the dropdown by default (and the 2 letter code is in the StateCode field -- not on the layout). You can customize the list of available States for a Country and add the 2 letter codes (and optionally disable the full Names)
Catherine TimoteoCatherine Timoteo
Hey Jeff!  Sorry to bother you again but you seem to be a guru at SFDC :).  Is there a way to edit the text only State & Country to match the country/state codes.  It doesn't appear that all data converted.  Thanks!
User-added image
Catherine TimoteoCatherine Timoteo
As in data was not converted in the 2 letter codes
 
Jeff MayJeff May
You can add more 'valid' entries to the list, but then you need to update your conversion mapping before you enable the S/C picklists.  
Catherine TimoteoCatherine Timoteo
I'm not a super admin and have no clue on how to update the conversion mapping, can you please help me with this?  Thanks, I appreciate your assistance!  
Jeff MayJeff May
When you go under Setup > Data Management > State and Country Picklists, you will see a link for 'configure states and countries'.  Use that link to define which Countries you want to allow, and which States you want for each country.
Catherine TimoteoCatherine Timoteo
Ahhh, I did that and updated the integration value for the Country and state.  See below on change I've made as an example.  Not all states and countries are converting to the 2 letter country & 2/3 letter state codes.  Am I doing something wrong or should I scan again?
 User-added image
Jeff MayJeff May
Just updating the mapping only defined what you are allowing as 'valid' - it does not automatically review and update your existing data. With the new mapping values in place, try doing another mapping exercise to let SF map your data.
Catherine TimoteoCatherine Timoteo
Forgive me if I completely misunderstood you and I'm waaaaay off.  I tried to enter US as a new value but I got the following error.  Sorry to be such a pain on this
User-added image