It could also be nice for the user to know what the filter value means. I have made a filtering based on how many people a meeting room could hold - but the value could also have meant how many meters to the nearest coffee machine.
Sorting makes sense. Does anybody else have the same problem?
As to your second problem: the easiest way to fix this is to make a computed column based on the number you’re now filtering by. For example, it could be an If-Then-Else something like this:
If Max People
>= 100 then 100+ people
Else if Max People
>= 50 then 50-99 people
Else if Max People
>= 20 then 20-49 people
…
Else 1-5 people
Yes, we have lists in our app that ref lists that are almost 700 records, so being able to say sort A-Z after applying a filter would be awesome!
@gannonatwork Sorting works whether a filter is active or not. @Krivo was asking for the list of filter categories to be sorted. Do you have 700 filter categories?
Oops, sorry, read through the thread too quickly. In our Parks section, we could benefit from allowing users to filter parks by available park features (playground, restrooms, softball field, etc.) and, since there are 72 available features, it would be nice for users to see this filter list sorted A-Z. Thx
You can do that with the in-app filter.
Sorry, I went off my memory of the in-app filter functionality. OK, now I really need to slow down.
I like the feature a lot. Would it be possible to also filter for empty value? Currently we have ‘All’ and each specified value to be selected but we are not able to filter for component where the column value is not set.
Thanks.
@Julien What’s your use case for this?
I’m using a ‘switch’ field that set a true value, and currently I’m not able to filter based on this column as only filter values are ‘All’ and ‘true’. I’d like to filter on data where the Switch has not been selected yet. I guess it will be the same with ‘checkboxes’ fields. I know setting another column with arrayformula could bypass the curent limitation.
I see. Right now you’d have to add an If-Then-Else column to produce the values to use the Filter on.
Great feature!
Would be nice if I could set this filter to be exclusive in some cases, i.e. only 1 of the options will be shown. Selecting one choice, deselects all other. So it is either A or B, but never A and B.
Use case: I’m currently playing around with a scenario where a user can select a language (one of 3 options), only the info for the selected language should be shown.
A second use case is to show or hide explainer videos supporting the subsequent text.
@wernerkuper Interesting use case! Would you mind suggesting the feature in our Feature Requests app?
Currently there is only one item per filter, is there any suggestions on creating a more dynamic filtering experience like show me calf high boots, that are red, leather and $50-$100
That’s on the roadmap.
Any idea when dynamic filtering will be available? Thanks
We can’t give you a timeline, sorry.
Is there a reason a Calendar layout can’t use the in-app filter abilities? The option disappears when I use the Calendar layout.
That’s a bug. We’ll fix it. Thank you for reporting.
You can build your own limited version of filtering. Check out Dynamic List Filter in https://concepts.glideapp.io/.