Hi, I am currently cleaning up/adding mailing addresses to some orgs. We want to make sure there are Provinces in our data. I have 2 issues that I am seeing:
- For some provinces they show up in lowercase in a report, but when I look in the org, they are capitalized as it should be. Example: in the report Ontario is on but in the org Ontario shows up as ON.
- I have added the addresses to the org, but nothing shows up in the mailing State/Province on the report.
Any clues as to why this is happening and if it's fixable. Thanks in advance
@* Sales Cloud - Best Practices * @* Sales Cloud - Getting Started *
Are you using state and country pick lists? If you are there are two fields: State and StateCode (or Country and CountryCode) the code is the ISO-3166 2 letter code (though it's configurable in your settings.) The other is the full name.
If it's incomplete, it may not have been mapped properly...and you might run configuration again to map data.
If you're not using the picking options....it sounds like your data is a mess ¯\_(ツ)_/¯