Support SFDC Country and State Picklists
Several delivered SFDC objects, like Contact, use country and state picklists to normalize data entry to ISO standards. Behind the scenes a 2-digit ISO code is stored, but the state or country name is displayed to the user. Also, the states available are dependent on the country that was selected.
The country/state dependency issue aside, I tried to do something similar on the Formyoula form since we need to update existing Contact info.
I set up select fields for country and state, and used two separate lists of options for each, as is allowed: one for display and the optional one for values. For example the Display name would be United States or New Jersey, and the actual values would be US and NJ.
The problem is when the data is located and retrieved from SFDC, what appears in these fields is not the display name, but the actual underlying value. So when US comes over, it displays in the select list as US - though that is not a valid value to display. This confuses logic I may have in place that hides/shows certain fields based on the value of the country.
Going the other way (from Formyoula to SFDC) this seems to work correctly: i.e. if I select United States, then US is sent over to SFDC.
Is there something I am doing wrong? Please advise. Thanks.