End User Filter

[voltenbas]

Sorry if this is a simple question but for the life of me I can't find the settings to control how the filters work for the end user.

In one of my AppSheets the filter works as I want it to for the end user - they click filter and they have the option to free text or Filter by Items that already exist in the data field. In the other Appsheet I have, it is purely free text. I've side-by-side gone through each setting and can't figure it out.

Also wondering how to set what Filter options are available for the end user as a lot of the fields would never need to be filtered and I'd like to hide them. Thanks!

[AleksiAlkio]

It sounds like you are talking about the search filter functionality. Each column has an option "searchable". You can find them from the column's definition if you scroll to the bottom of that view (other properties).

[voltenbas]

Thanks for the reply! Hmm...more along these lines, like when the filter is clicked, "Type" has the option to filter by what exists in the rows, but "Main" doesn't.

Also not sure why I can't get the existing options to be sorted alphabetically but that's another thread haha.

[romulo_torres · Accepted solution]

Hello!

On the definition of the column you have to set the type of....

If the type is "text" then the search filter is free search text.

Try change the type of your Main column to Enumlist or Enum

[voltenbas]

Ahhh that was it thank you!! Now to figure out how to alphabetize it haha...

[romulo_torres]

When i have a big list like yours i do the following.

i use a Google Sheets  as the source for the "List"

The i populate using the option "Sugested Values" in the column definition and i sort or in the google sheets itself or using the appsheet function SORT().

it all depends of your scenario. good luck.

[voltenbas]

Thank you! I filtered in the google sheet and that did it. I just hope I don't have to sort another column lol.

Would you happen to know how to hide certain columns from displaying in that filter view? Every column currently shows up but only one of the columns has data that is useful to filter.

[romulo_torres]

Hello.

You can unmark "searchable" the columns you don't want to appear in the filter in the table definition.

If you use that same table for more than one view, you can create an "slice" for that view. In the slice definitions you can choose wich columns to hide/show and the order they appear an UP in position the fields more searchable. (another alternative)

Good luck!