show list of values for the app search

AppSheet AppSheet Q&A
, , , ,
1

Hi, how can I show list of values for the app search

for example in color, user can find all colors to filter

555.jpg
555.jpg300×515 10.8 KB

2

Easiest, change the column type to ENUM and add in the options manually

1 Like
3

It is of text type

and valid if value

SELECT(myItemspes[Color],TRUE)

is there any other way to show on search list

4

I think it’s solved now

I used the enum

Did not add values, just clicked on allow other values.

In valid if, I added the select expression read the data from the sheet directly.