Display the Enum Search options filter in sorted way

AppSheet AppSheet Q&A
, , ,
1

I have a many rows each with repeating and non repeating values for the field LOCATION,

I offer it to search, but the search list itself needs to be sorted, My formula placed here didnt work. Any insights would be great.

AnonyDee_0-1654830846983.png
AnonyDee_0-1654830846983.png494Ă—655 33.2 KB

AnonyDee_1-1654830884236.png
AnonyDee_1-1654830884236.png1042Ă—811 63.5 KB

Also tried with

AnonyDee_0-1654841137653.png
AnonyDee_0-1654841137653.png1025Ă—801 60.2 KB

3 Likes
2

Try SORT([Location],FALSE) - https://support.google.com/appsheet/answer/10107698?hl=en

If that doesn’t work, try the same suggested values on a different column without a spreadsheet formula.

Simon@1minManager.com

1 Like
3

The spreadsheet formula is for Generated from the spreadsheet. Gets applied during sync. This has nothing to do with sort I believe.

Your formula gives error

AnonyDee_0-1654929219734.png
AnonyDee_0-1654929219734.png1230Ă—881 60.3 KB

4

Is the base type of this EnumList column a Ref to Project Details table?

–
Setting values through a form AND having a spreadsheet formula makes no sense.

1 Like
5

Thanks Joesph, Yes thats enum, here are the screenshots

AnonyDee_1-1655091803618.png
AnonyDee_1-1655091803618.png779Ă—831 36 KB

AnonyDee_0-1655091791293.png
AnonyDee_0-1655091791293.png1665Ă—838 66.6 KB

6

So [Location] is an ENUM. Whereas SORT() is expecting a LIST type column as the first option. To make it not error then this will work:

SORT(LIST([Location]),FALSE)

But it’s kinda dumb as your asking it to sort a single item list :rofl:

7

@Joseph_Seddik any luck?

8

Thanks for that, but the actual problem was to sort a filtered list rather getting the right syntax of SORT. It makes sense to sort the LIST instead of ENUM.

I did as you suggested, but still no luck

AnonyDee_0-1655176357906.png
AnonyDee_0-1655176357906.png1919Ă—915 134 KB

9

  1. Ideally you should have a separate Locations table with two columns: a locationID K**ey column and locationName Label column. You can have additional columns like locationAddress for example.

  2. Any Location column in any other table should be of type Ref to the Locations table.

  3. Your *Enum-*type column should have its base type set to Ref pointing to the Locations table, instead of Text. Its Valid if constraint should be:

Locations[locationID]

and its Suggested values should be:

ORDERBY(Locations[locationID], [locationName])

That should give you the desired behavior.

1 Like
10

Per the original inquiry, did anyone get this to work yet to sort the list items in the search bar “filter” section for a given field?

My Enum field is a Ref type field, and the OrderBy syntax works great for the dropdowns within the Form view. It’s when a user clicks the Search bar, then the filter icon, then this particular field that the list items remain unsorted. Maybe it’s a bug?

11

To my knowledge, unsorted remains the only option.

1 Like
12

yep, thanks

1 Like