Hello, I have a table of Groups where a group record can have a parent group. I created a Dashboard that I would like to use to select the children records of any Group selected in the first group view.
I have created a slice of the Group table called Top_Group so that the first view only have the top level groups. Right now when I click on one of the Top_Group records, it highlights it in the second (all groups) view.
I was expecting that the second view would be a filtered view of Group records whose parent record is the one selected in the first view.
Does anyone have any pointers on how to do this if it is achievable?
Auto interactive filtering between two views of the same table does not seem to work.
You either need to split your records into a parent - child pair of tables or create you own filtering like here
https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Interactive-Dashboard/m-p/479178
User | Count |
---|---|
35 | |
30 | |
30 | |
20 | |
18 |