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!

5
  • Do you mean the County names for England and the rest of the UK or the Countries for the UK?
    – Dave Humm
    Dec 23, 2016 at 11:22
  • i mean all the country-names in US-english spelling/name
    – hotzen
    Dec 23, 2016 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, 2016 at 11:42
  • no idea, is this an actual setting?
    – hotzen
    Dec 23, 2016 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, 2016 at 12:31

1 Answer 1

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
  • 2
    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, 2016 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.