I have a lookup field for states. It is set to store just the abbreviation (e.g., "FL"). Using the advanced display options, it displays both the abbreviation and the full name (e.g., "FL - Florida"). I access the data through a json feed and would like a list of just the state abbreviations.
Two impediments:
1. The default view of the "states" field does not display what is stored ("FL") and instead shows the advanced display ("FL - Florida") which I only wanted to show in the form itself.
2. As a workaround, I should be to use the "related field" of state abbreviation. However, the json feed does not send related fields correctly. For the real field, it correctly puts quotes around each element of the list, but for the related fields it puts quotes around the entire field (so it is not interpreted as a list).
"state_abbr":"[CO, FL, MO]" -- WRONG "state_abbr":["CO","FL","MO"] -- RIGHT
Is there a fix for either of these problems, or another option to get what I want?