Setting up an interactive dashboard

AppSheet AppSheet Q&A
,
1

Forum Friends, your help please - I’ve reached the absolute limit of my knowledge, experience and ability to research solutions myself.

I have a table slice - myGroup (view shown below)

Untitled design (2).png
Untitled design (2).png847×417 55.4 KB

I want to allow users to select a ‘Related SECTIONs’ row (see the left side of the image) and have the ‘Related WAITING_LISTs by _suggestedGroup’ (see the right side) update to focus on just the selected Related SECTION. It can be in a different view format - this image is just to help explain.

I believe a two view Dashboard with interactive mode ON should achieve this - however, I’ve not been able to get anything like that to work.

My experience suggests it’s probably easier than I imagine - but I can’t figure it out. All help, suggestions and pointers gratefully received.

G

1 Like
2

If I am not mistaken, you will need to do the following:

  1. Create a new table to use for your filtering. If can just be one column and one row
  2. Create an action to update the value in the new table to the SECTION (or reference column) that you are using to filter
  3. Update the slice for the Related WAITING_LISTs by _suggestedGroup view to filter based on the value in the new table
  4. Update the behavior of your inline view to run the action when the row is selected

I think this should work. Although I am not sure if the inline view being part of the parent detail view will have an impact. Let me know if you try it!

1 Like
3

This sounds like an enhanced dashboard setup might work well in this situation.

https://youtu.be/HWhtlzxtPss

This is the kind of thing @lynchk21 is talking about.

Good luck and happy apping!

1 Like
4

THanks for the input.
In the end my solution was to:

  1. add a helper column to the existing User Profile table to hold the selected SECTION.
  2. have a Slice using the stored SECTION in the User Profile to display the required rows.
  3. do away with the dashboard and show the detail of the relevant parent row - with the inline table being based on the slice created at 2.

Works well enough for me now.

1 Like