0

we plan to enable the new Salesforce Country/State-Picklists.

we love the idea to have ISO Country-Codes but for a different system we need all the country-names in US-english spelling/name.

our org-default is german though and the country-picklist is only displayed in german, even if having enabled the english locale.

where/how can we retrieve the english country names specifically? is there any apex-accessible table/object or something?

thanks!

  • Do you mean the County names for England and the rest of the UK or the Countries for the UK? – Dave Humm Dec 23 '16 at 11:22
  • i mean all the country-names in US-english spelling/name – hotzen Dec 23 '16 at 11:35
  • Ok, I'm clear now - you will need all country names using US-English. Do you have multilanguage support enabled? – Dave Humm Dec 23 '16 at 11:42
  • no idea, is this an actual setting? – hotzen Dec 23 '16 at 12:25
  • Go to Setup>Company Profile>Language Settings and you can set several language settings there - help.salesforce.com/… – Dave Humm Dec 23 '16 at 12:31
2

Assumptions made in this answer

  1. State and Country/Territory Picklists have been enabled in Setup>Administer>Data Management and all values are converted
  2. Translation Workbench has been setup for the languages with users selected for each supported language. Translation Workbench documentation

Setup of Translations

Setup of Translation Workbench - got to Setup>Administer>Translation Workbench and enable this feature then setup translators.

enter image description here

Then setup the translations - unfortunately this will be a manual process as far as I can see, but is a one off activity as countries do not change their names frequently.

enter image description here

Apex/SOQL settings

To get the value in SOQL documentation link

Use toLabel() on regular, multi-select, division, or currency code picklist fields (any field that has picklist values returned by the relevant describe call), data category group and data category unique name fields or RecordType names. Any organization can use toLabel(). It is particularly useful for organizations that have the Translation Workbench enabled.

  • 1
    fun fact: In 2013, the Cape Verdean government determined that the Portuguese designation "Cabo Verde" would henceforth be used for official purposes, such as at the United Nations, even in English contexts. - thereby blowing up country picklists everywhere – cropredy Dec 24 '16 at 1:11

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.