Using 2 tables in a slice.

[nemus]

Hi I have 2 tables and 2 views. On the first view I click one of the rows which belong to one table. It brings me to the second view which uses the other tables. Thing is I would like to do a slice on the second view.
Something like.
select * from second_table where second_table_col = "value" 
However "value" is obtained from the first table.
I feel like this is doable but just not sure how to accomplish in appsheets. Apologies if I did not explain it clearly.

[Suvrutt_Gurjar · Accepted solution]

Please take a look at the deep links article

App column type (deep link) - AppSheet Help

Within deep links, please take a look at the LINKTOFILTEREDVIEW() examples something like below from the article that could help you to navigate to certain rows in the next view of the second table.

[nemus]

You're a life saver with that link... thank you