LinkedIn
Twitter
I am new to AppSheet and struggling with something that must be very basic. I’ve been reading documentation and this forum and I am stuck. Hoping someone can point me in the right direction.
- I have a table called States that is just a list of states (columns: StateAbbrev like AZ, StateName like Arizona)
- I have a table called StateGrade which lists the grade levels associated with the state (columns: StateAbbrev, StateGr like AZ3)
- Then I have several tables that are associated to StateGrade
What I want is for users to click a state and then be taken to the list of grades for that state and from there to a dashboard with inline views of the stuff relevant to the state and grade OR to click a state and be taken to an interactive dashboard where they can choose the grade and then get the inline views of the stuff relevant to the state and grade. I have the dashboard set up and it works fine.
I have a REF_Rows setup between State and StateGrade tables. But when you click a row (a state from the State table in a state view), it doesn’t filter in the StateGrade inline view to the grades associated to that state. You just get every state and its grades. Screenshots below. I’ve tried adding actions that say go to a FilterView of the StateGrade_View based on the state and some other things but obviously I am missing something. Any advice appreciated.
Solved
1 ACCEPTED SOLUTION
LINKTOFILTEREDVIEW isn’t going to work for when you click on a StateGrade to move to a filtered dashboard view. You may try LINKTOROW() instead, but I can’t guarantee that will work either.
Navigating to a pre-selected interactive dashboard view is a feature that has been requested by many before (actually, two different times, by me, lol. links below). I’m not sure the exact status of that, it might be currently working in some way, but not 100% officially supported. I haven’t tried it in a while.
Links to related feature requests.
Enable LINKTOFILTEREDVIEW() for Dashboard
Deep link to bring up interactive dashboard view with pre-selected records?
Pre-selected interactive dashboard view via expression
What I can suggest that absolutely will work, is to simply navigate to a detail view of the selected StateGrade, and you can view all of the related records in inline views.
Which brings me to my next point:
I want to correct your usage of the term “inline views”. The things you are calling inline views, are not inline views. Or at least not in Appsheet terminology. An inline view is a view of related child records, as seen from the detail view of the parent, where it is literally inline with the rest of the columns of the parent record. This is a typical inline view:
Further, a dashboard view is made up of a set of other views. I don’t believe this community has a common term for the views that make up a dashboard view, but I like to call them “sub-views”.
