12-17-2010 10:56 AM
I've been asked to "clean up" the dropdown that displays US States in the Address control. Previously, other related custom SmartParts (Accounts, for example) that used the dropdown were mis-configured, allowing users to freely type in values. This resulted in inconsistencies and misspellings for State abbreviations.
I can't tell where the original dataset is coming from. Where would I go to tweak this? Also, how can I sort alphabetically? The list is not quite alphabetical.
Solved! Go to Solution.
12-17-2010 11:58 AM
OK, I found the table (Picklist), but it looks like the entries are being ordered by ID. I'd like them ordered as Text. How can I order them this way?
12-17-2010 01:37 PM
Just go to the Picklist "manager:
In Admin: Manage Picklist
Just locate the State Picklist and make sure Sorted Alpha... is checked. OOTB It's supposed to be that way.
12-20-2010 06:10 AM
04-01-2011 07:32 AM
The solution is to export the picklist and then import it back in to generate new item ids. You then need to restart IIS or re-deploy to use the new list on the web.