Is there a way to automatically sort the Enum values in a dropdown when that list is populated by looking up another table?
I have a column called Vendor in a table, which Refs a different table called Vendors. The Vendor column looks up the Vendors table and displays the Vendor names as an Enum dropdown. (A very cool feature).
The Vendors table is writable by the user, since they need to be able to add a new vendor in the field as needed. Using the lookup feature means that the next time they encounter that vendor he/she will be on the dropdown list and they won’t have to enter it by hand.
I’d like the dropdown list to be sorted alphabetically. I can sort the Vendors table in the spreadsheet, in which case the names will appear in the right order in the dropdown, but when the user adds a new name that name is appended at the end of the table (and in the dropdown). Not surprising, but I was just wondering if there was a way to sort the list on the fly instead of me sorting the table in the spreadsheet every time a new name is added.
The Vendors lookup table is keyed by the Vendor name.