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โ.
Thank you very much! I fixed the key and now it works fine to go from state to state/grade. From there, I added an action so that if you select a state/grade row, you go to a dashboard view which has inline views of the stuff associated to the state and grade. But the dashboard is not filtered to the state/grade selected in the previous row. I re-read the references article but am not seeing where I am going wrong. StateGrade table has a list of ref_rows to other table (Match) which has a ref back to the key, StGr. I am sorry to bother but am not sure where I am going wrong.
Thank you and sorry for not being clear. I start here and choose โAlaskaโ.
It takes me to this inline view and I choose Alaska Grade 3 - AK3 (State Grade table)
Then I have an action set up to take me to a dashboard which contains 3 inline views based on the State Grade table, plus a state/grade detail view). But these views are not filtered to AK3 - they show all states and grades.
This is the expression in the action that is set to go when you select a state/grade (AK3, for instance).
Not sure if what Iโm trying to do is not possible or Iโm doing it wrong. Maybe I need a slice of the filtered inline views in the dashboard somehow.
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โ.
