Open grantfitzsimmons opened 6 months ago
PickList has a sortType
field which itself is a pick list of one of 3 options:
0 - sort in order in which items were entered
1 - sort by title field
2 - sort by the value of the "ordinal" field, thus allowing any custom sort you want
(no explicit way to say Descending sort though)
Specify does it's best to respect this field for pick lists in the form, workbench and other places, though it's possible that some places were missed
The real issue here is that the field is hidden and not present on default PickList forms
From Paul Blom @ College of Idaho:
A request for future improvement would be to let the user alphabetize the picklist items. Or have easy methods for exporting, deleting, and uploading items.
Or have easy methods for exporting, deleting, and uploading items.
That would probably be the responsibility of the batch editor. Pretty simple for picklist items without any usage. Quite tricky for pick list items with usages as picklist item references are not based on the PickListItem.id field but on the PickListItem.value (thus SQL natively doesn't know in what places is a given PickListItem used, thus can't enforce referential integrity)
Requested by: Museu de Ciències Naturals de Barcelona on Trello