Sorted value lists

[WhiteCollar Redneck]

Hi Gents/Ladies

Does anybody know how to dynamically sort the values in a value list?

[David Head]

You'll need to be more specific with what you mean by "dynamically sort". For example, do you want the user to be able to specify whether the list is sorted in ascending or descending alphabetical order?

[WhiteCollar Redneck]

Thanks for the quick feedback David, I am referring to a value list derived from an input field, i.e. "use values from field" in the value list setup menu.

Everytime new data is entered in that field, it goes into the value list, and looks like it is alphabetically sorted in ascending order. Is there a way to disable/modify the sorting and let the value list display the data in the current order of the records?

[David Head]

OK, simple answer is No.

 

Reason is that when the value list derived from an input field, i.e. "use values from field", it gets the values from the index of the field. The index is sorted by default and the sort order cannot be changed. If you turn off indexing for the field, the value list won't work at all.