Passing a value from a view to a data table

AppSheet AppSheet Q&A
, , , ,
1

Hello everyone,

As you can see from the title, I want to pass a value from a view to a data table. This means that I have a view with some years like 2023, 2024 etc… and when I click on one of them, the year switches to another table which manages a chart. The year value is used in a virtual column.

At the moment I store the year in a third table with a single row. Every time I click on a year, that specific row changes to the year to display. For the moment it works but it’s really really too slow and I would like to change it.

I tried passing the value via URL but it didn’t work :disappointed_face:

Hoping someone can help me!

2

You can use LINKTOFILTEREDVIEW() as your click event action in your first view.

3

The problem here is that the data for the graph isn’t store in the same table than the one who displays it because I have to do some SUM() on the value. So I can’t do a LINKTOFILTEREDVIEW() as you tell me.

4

Then you would first populate a column with the filtering values, and afterwards you filter.