AnsweredAssumed Answered

Easiest Way to Normalize State & Country

Question asked by Denise Greenberg on Mar 29, 2019
Latest reply on Mar 29, 2019 by Sanford Whiteman

Hi All - I'm not working in an instance where SFDC rejects records if State or Country isn't spelled out rather than abbreviated. Most of our leads don't come from forms (so having standard picklists in the forms won't solve this) - plus I've inherited existing nonconforming leads. Is there an easier way to normalize these fields (and keep it normalized) than creating smart campaigns that say "if state/country is x, change it to y"? At least with states there are only 50 (and a much smaller number of provinces/states in places like Canada and the UK) but the country list is way too long to handle this way.


Sanford Whiteman - one thing I wondered - is there a webhook built for this that already has the standard values to populate (still could be issues if the countries didn't match the SFDC picklist values, I know. At least this company is only overtly marketing to the U.S. so there isn't a big effort to include other countries - though they are there).