Creating a filter pane in Dashboards
HTML-код
- Опубликовано: 23 июл 2024
- AppSheet has a built-in system for users to filter results in a table-based view. However, this system is hidden by default behind the inverted pyramid icon for each view.
In this video, I will show you how to create a filter pane that is immediately visible when a user arrives in a dashboard view. This has the added benefit that multiple views from different tables can be filtered from a single filter pane.
I will walk you through the steps involved in creating a filter pane, and I will also show you how to customize the filter pane to meet your specific needs.
0:00 Intro
3:20 Table for filter inputs
4:45 Filter input view
8:07 Slice for filtered results
13:50 Ignoring blank filter inputs
17:17 Final solution demo
18:47 Extra cleanup tasks Хобби
This is by far the best explanation and example I've found. Thank you very much!
Great content from South Africa 🇿🇦
It is a great tutorial, thank a lot.
Glad it was helpful!
I finally got my dashboard to work thanks to this video. Your explanation is easy to follow and logical. Is it possible to modify the filter expression to be able to select multiple criteria within the same column? Let's say I like to filter low and medium, and exclude high within the same column?
In order to have different filters for different users, I have added the UserEmail to filter table and using lookup in the filter form but this doesn't seem to be working, I think the updates are too slow. Has anyone any other ideas how this can be achieved. UPDATE : I have put the filter columns on the table that lists the users and lookup from there which works.
It is necessary only one row in the tab Filter of google spreadsheet?
Hi, i have a case where to include blank values in the filter condition. How to text you? Could you please help me with this?
Isnotblank can be used