How to create an interactive dashboard that only shows related entries when key is selected?

AppSheet AppSheet Q&A
,
1

I’m trying to create a dashboard where I can see all relevant information pertaining to a district and site at once. I don’t like that when no district is selected, all the sites and service tickets are visible.

When a district is selected it only shows the relevant info.

3X_8_c_8c50e85d0a364f9c0cfe0a7202b5c8be92b1080a.jpeg
3X_8_c_8c50e85d0a364f9c0cfe0a7202b5c8be92b1080a.jpeg1880×903 198 KB

When no district is selected, I see all sites and service tickets. I would like for service tickets and sites view to be blank.

3X_6_a_6a6ce8dc97f5391a455da2e99f1ee4ec70fc3502.jpeg
3X_6_a_6a6ce8dc97f5391a455da2e99f1ee4ec70fc3502.jpeg1876×906 237 KB

Does anyone know how to fix this to only show relevant information to the district?

2

You can enter in a “blank” record (but make sure the key value isn’t blank), for the child Tables, and make sure it is the first record that Appsheet loads. For GSheets, this would mean that it would be on the 2nd row, for a SQL database it would mean the key value comes first alphabetically. This is the record that the dashboard displays when nothing is selected.

2 Likes