My drop down list for “Occupation” is very long and the items in it are not in alphabetical order, so it is difficult to quickly find and select the required item. I know that if I go to Admin -> Lists I can sort the items manually but that would take a very long time, and it would need to be done again with each new addition to the list. Is there no way that the list can be sorted in alphabetical order at the click of a button? Or alternatively, if the drop down list would allow me to write the first letters of the required item and then offer me a filtered down list to select from? Thanks.
Generally lists should already sort by title within sequence number. So if the sequence numbers are all the same they should sort alphabetically. Try it with a few of the items and see if that doesn’t work.
Hi,
Regarding translations and sorting, Rod created a nice solution for this awhile back. As I recall, it was either the listing of the languages on the login screen or the listing of the lists in Administration->Lists. It basically uses the mysql collation to sort the translated values, as I recall. That mechanism could be leveraged.
-brady OpenEMR
Textbox is the default Data Type, see attachment. The editor is located in Administration/Layouts/Demographics. Someone must have changed it to Listbox if Occuption has a drop-down menu.
The nice thing about Autocomplete is that once “trained”, if you type “ca”, it should bring up “carpenter”. Less clicking & no need to scroll down a long list, if you’re looking for “wainwright” (wagon-builder). No need to bother about alphabetizing either.