Show children records in a Dashboard

[jrullan]

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?

[TeeSee1]

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