A single action that links to a specific view based on the row you clicked?

[chadstonks]

Maybe this is a stupid question, but I haven't figured out. I made a separate view for each "player" in the app:

Player 1 View

Player 2 View

Player 3 View

etc. Is there a way to only create one action that goes to the correct player's view, if you click on a row belonging to that player? So like, you click on a row belonging to Player 1, and it takes you to Player 1 View?

The way I've been doing this is create a different action for each player and affixing a button to each player's row. But I was wondering if there is a way to do this by using the Table behavior section at the bottom, when a row is selected. Perhaps with a LINKTOVIEW expression. But I'm not sure how to make this LINKTOVIEW expression choose the right view to go to.

[dbaum]

If you indeed need different views, you could presumably use a single action. In the "App: go to another view within this app" action's Target property, enter a conditional expression that uses the IF or SWITCH function to return the appropriate view.

Consider also whether you even need different views. Potentially you could use a single view based on a slice whose row filter condition limits each player to their pertinent rows.

[chadstonks]

Okay thanks, I figured maybe I shouldn't have made all the different views in the first place. 

In terms of creating a single view based on a slice, how would I get the row filter to show only each player's data? I understand that if I did:

[Player]="Player 1" 

I would see that person's data in the slice. But how would I make it conditional so that, if I had clicked on Player 2, it will show Player 2's data in the slice instead?

[dbaum]

SWITCH

It sounds like you might also be interested in some of the techniques outlined in  SUMMARY TIP: User permissions, roles, and settings - Google Cloud Community . 

[RedVox · Accepted solution]

Perhaps what you are looking for is the LINKTOFILTEREDVIEW() function?