Vote 240  points

Matthew Lamb

State & Country Picklists - Detect State written into Country during mapping

Salesforce Platform, Administration & Sharing, Customization, User Experience

Let's say you have a value written into the Country field in your existing org that, when enabling the State and Country as Picklists feature, is actually a State. A good example is some of the US protectorates, like Guam or Puerto Rico. If you're converting really old data, you will definitely find a lot of these values in Country fields.

I'd love for the system to detect that a value found in the Country Conversion process is actually a State value. it should the give me the ability to map that existing Country value into one of the standardized State value, and in the same action, select the appropriate Country to which the standardized State value is mapped/

Otherwise, I'm left to move away from the tool, manually search for all the data that has States written into Country fields, and correct those manually / through Data Loader / etc. That's very labourious, and slows down the process of enabling this feature.

1 year ago · 3 Comments ·Merge Idea · Report Abuse

1 to 3 of 3

Ideas

Apps

Questions

Help us to keep IdeaExchange clean by pointing out overlapping ideas. We'll investigate your suggestion and merge the ideas if it makes sense.



 

 

Thanks for your merge suggestion. We will review it shortly and merge the ideas if applicable.

Salesforce.com takes abuse situations very seriously. Examples of abuse include but are not limited to posting of offensive language or fraudulent statements. To help us process your request as quickly as possible, please fill out the form below describing the situation. For privacy and security reasons, the final outcome of an abuse case may not be revealed to the person who reported it.


 

Thank you for your feedback. We take abuse seriously and will investigate this issue and take appropriate action.