Navigating to a different view for each row of a displayed view

[nhcohen]

I have a table with columns that include a date, an ID, and other data. I have a view that displays data from all rows with dates up to today.

I would like to give the user the ability to somehow select a row in this view (perhaps by clicking on that row) and navigate to another view, which displays data from all rows that have the same ID as the selected row. 

Is such a thing possible in AppSheet? In particular, it would seem that I have to somehow communicate the ID of the selected row in the first view to the filter of the second view.

[WillowMobileSys]

In the table view, if you only need each row to go to a specific designated view based on the row state, then you can use the Row Selected behavior and attach an action that can choose which view to go to based on the row selected.

Otherwise, if you need the user to choose from several view options...

You can easily do this with a Deck view by presenting several actions for each row.

In table view, I would recommend inserting Inline actions.  They are much like the actions for a Deck view, except they are physically inserted into the row itself.  I normally include dedicated columns to show the actions.  You can then configure each action button to go to a desired view

Sample Table View with Inline Actions

[nhcohen]

This is helpful. I think I need an "App: go to another view within this app" action with a LINKTOFILTEREDVIEW target.

However, I don't know how to write the filter expression for the LINKTOFILTEREDVIEW. I want the target view to include every row whose [caseNumber] column has the same value as the [caseNumber] column of the clicked-on row. Clearly [caseNumber] = [caseNumber] will not give me the desired result.

Is there an expression that denotes the [caseNumber] column of the clicked-on row, and a different expression that denotes the [caseNumber] columns of the rows to which the filter is to be applied?

[Molly_M · Accepted solution]

LINKTOFILTEREDVIEW("Desired View",[_thisrow].[CaseNumber]=[CaseNumber])

This expression should work in an action of "App: go to another view within this app" action. If you want it to filter from main view after clicking on the row you can change the behavior for "On Click"