filtered dashboard

AppSheet AppSheet Q&A
1

hello everybody!

I try to explain what i need to realize

I have three levels of data:

  1. grandparent
  2. parent (whit reference to the upper level [ID1])
  3. child (whit references to both uppers levels by [ID1] and [ID2]).

When I open the grandparent detailed view I see also the reference table of the parent

So, starting to this view, when i active the “Event Action = Row Selected” I open a dashboard
(view of detail of the parent and view of child).

How can I make the filter on the dashbaord to only allow the view of the data related to the row selected (parent)?

Where I have to work: slice, filteredview, ecc.?

On what I need to work: ID field for example?

thanks a lot for help

2

Start with these search results.

2 Likes
3

Nailed it! :rofl: Reminds me of the need for that post that @LeventK put together way back, when we were in Discourse, for new posters - with all that advice about how to get started, searching, etc. etc.

1 Like
4

Hello community and thanks @Steve for the reply.

Unfortunately I haven’t found a solution that fits well,

I saw the a problem which is very similar to mine, Dashboard view with filtered records;
there ia a way to use a row (that belong to reference table in a detailed view) as a control to open the dashboard that use the ID_ROW as a filter?

I try more and more this weekend, but every time I obtain ever a dashboard in which the views returned all row (thanks to the interactive mode only using the slideshow I’m able to have a filtered view :roll_eyes: ).

Thanks for any suggestions

1 Like
5

the solution I adopted is based on the use of an auxiliary table in which the parent ID is saved:

the table has three columns ([ID], [TARGET], [DESCRIPTION])

I also created a Y/N auxiliary column in the parent table and a sequence of actions that governed the same table:
1st: Change the value from N to Y
2nd: Inserts the [ID] value into a specific row of the auxiliary table
3rd: Change the value from Y to N
4th: Link to the dashboard

the action is performed after the parent row is selected

the dashboard displays the father (detail view), child and grandchild (both table view) are filtered whit the correct father [ID] value by a LOOKUP to the auxiliary table.

1 Like