Search Filter List not Alphabetically Ordered

[LLD]

Hello!

My app has a field called "Expense Category". While adding a row the drop down shows values alphabetically...

but while using the search filters, the same values are not in alphabetic order.

The list of values in the reference table/ spreadsheet is alphabetically sorted. 

how do I make the values of the search bar appear in alphabetical order?

[Suvrutt_Gurjar · Accepted solution]

I think currently what you are looking for through those built in search filter is not possible. The search filter fields seem to be ordered by the order in which the table records are stored for those fields. Also search filter will show only those options, for which there are records existing in the backend table.

If you check in the backend, in all probability the expense categories are stored in the table records should be in the order "New Infra" , "Purchase" , "Repairs and Maintenance" , "Telephony and Internet" .........etc.   So even though the input field is ordered alphabetically, the search filter shows the order of the way those options have been selected and stored in the records.

One workaround option could be to group a view by those expense categories, so that the user can select the desired category and see the relevant records.

[LLD · Accepted solution]

Hi Suvrutt.. sorry for replying late.. I already have other custom views; I won't be creating more for now. Hope this feature i.e. Search filter shows (only) entries made into the table, but, alphabetically.. soon!

[Suvrutt_Gurjar · Accepted solution]

I think currently what you are looking for through those built in search filter is not possible. The search filter fields seem to be ordered by the order in which the table records are stored for those fields. Also search filter will show only those options, for which there are records existing in the backend table.

If you check in the backend, in all probability the expense categories are stored in the table records should be in the order "New Infra" , "Purchase" , "Repairs and Maintenance" , "Telephony and Internet" .........etc.   So even though the input field is ordered alphabetically, the search filter shows the order of the way those options have been selected and stored in the records.

One workaround option could be to group a view by those expense categories, so that the user can select the desired category and see the relevant records.

[LLD · Accepted solution]

Hi Suvrutt.. sorry for replying late.. I already have other custom views; I won't be creating more for now. Hope this feature i.e. Search filter shows (only) entries made into the table, but, alphabetically.. soon!

[Suvrutt_Gurjar · Accepted solution]

Yes, let us hope that AppSheet adds this feature. You may want to search if already there is feature idea request for this feature and if not, create a feature idea so that it at least remains in the list.

One way to look at it is as a medium or low severity bug because it impacts user experience.  Option to select alphabetic sorting of  any textual list in options is typically a default behavior.

[RowanAngstadt]

I am having the same issue; however, I checked and the table is in alphabetical order, but the values are still in a seemingly random order in the search filter.