Check box for filter

AppSheet AppSheet Q&A
1

I dont know if this is possible but what I would like to do is show a filter list that the user can check to see whatever values they would like. So when you click on the search bar and the filter icon shows up, you can click on whatever field is searchable.

Tragertt_1-1655737831033.png

When you click on the field you want to sort by I get a blank search box.

Tragertt_2-1655738016951.png
Tragertt_2-1655738016951.png282Ă—117 924 Bytes

What I would like is a check box of the values that are in the field, it would look like this

Tragertt_3-1655738277953.png

So you can check whatever criteria you want to be shown. Do you I have to change the field type or is there some code that will achieve this? Thank you in advance!

2

Hi @Tragertt

Did you set your columns as being searchable ?

Aurelien_0-1655738756826.png
Aurelien_0-1655738756826.png256Ă—676 9.61 KB

3

Yes they are set as searchable, what I am looking for when I do a search I would like a checkbox for each value in the column rather than a blank search box.

4

ok. What about Enum ?

5

Right now the column type is set to Text and might be problematic if I change it since it is referenced in so many places. I will try it and let you know

6

The change to Enum shouldn’t be any problem. You can define that it’s Enum basetype Text.

I do it all the time to have better filters

7

Thank you so much, that worked exactly how I wanted.