How can I pass a value to views in dashboard

AppSheet AppSheet Q&A
1

Hi.

I’m making an app for managing lawsuit information.

When I want to pass a value to a single view, I can use LINKTOFILTEREDVIEW function. But when the Target is a dashboard view, it doesn’t seem to work.

I can open a dashboard when I press a button from Case detail view. I added three views and each view is connected to three sheets, and these sheets all have a Column named Case ID, whch is referencing the Case Table.

Currently, it shows all data in each table.

But I want to see only related data to this Case.

So, I want to filter data with the Case ID value to each view entry I made in the dashboard view.

I’ve also tried to make a data slice but it’s not working as intended.

Can I get any help with this?

Thank you.

2

Check out an “interactive dashboard”, with proper references setup from each of the 3 mentioned tables, to a single case table.

2 Likes
3

Hi - I have the same issue but I’m not sure what you mean by ‘proper references setup’ - can you elaborate please?

Steve

4

References between tables - AppSheet Help

5

Thanks for that but I have already done this but I still can’t get the dashboard to show correctly when it first pops up having clicked an action button on another view . I’m using LINKTOFILTEREDVIEW(“Prospect Overview”, ([Row ID] = [_THISROW].[Row ID])) - prospect Overview is a dashboard. I thought this would make sure that the 3 views in the dashboard would relate to the clicked row but that doesn’t happen.

Any help appreciated.

Steve

6

It just doesn’t work like that.

7

So I cant have a table, then select one of the records and have a dashboard appear using an action based on that record. e.g. drilling down into a country from a list of countries and then display 3 charts related to just that country on a dashboard?