show list of values for the app search

[aminsaleh]

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

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

[1minManager]

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

[aminsaleh]

It is of text type

and valid if value

SELECT(myItemspes[Color],TRUE)

is there any other way to show on search list

[aminsaleh · Accepted solution]

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.