How to sort a pick list alphabetically in Specify

Dear Specify community,

Do you know if there’s a way to sort a pick list alphabetically?

There is a tool for this in the configuration scheme, but it doesn’t save the setting.

As soon as I log out and log back in, the pick list reverts to the order in which it was originally created.

I’m using Firefox – could this be related to the browser? Or is there an XML command I could add to the form to change how the pick list behaves?

Thank you in advance for your help.

Hi @Marion,

Thanks for your question!

To start, the ‘pick list item’ sorting you configure in the Form Meta Menu only applies to the order in this dialog (as it does for other subviews in the app) rather than actually changing the sort order you see in the app for the list of items.

The order of pick list items is controlled entirely by the order each item was created in. If you add all the pick list items in alphabetical order, it will respect that when shown on your forms.

If you want to change the order of pick list items, the simplest thing to do is to remove all the items and re-add them in the desired order. If you do, you’ll want to change the ‘Order By’ to ordinal again in the meta menu to avoid confusion.

If you do choose to remove and re-add those items, make sure to keep the value exactly as it was, otherwise it will break the link between the pick list title and value in your database.

If you need all of your pick lists reordered alphabetically, I can do so on the back-end automatically for you since you are hosted on Specify Cloud. Just give me the word and I’ll take care of it!

To add to this, I’ve opened a new issue seeking to improve this in the future:

1 Like