View tasks from table client_tasks based on related table client.id

[stefanasks]

I have a table clients and a table client_tasks. Now I need to tap on a client row and open a view that shows tasks from a related table client_tasks.

My problem is how to use/send the client id to the other view in order to select tasks from the given client id.

For now I have this in a action of table clients:

LINKTOROW([id], "Client tasks")

 This should open Client tasks - what it does - but all of it. I need to pass the [id] to the view or slice in order to get the tasks from only the given client id.

[Suvrutt_Gurjar · Accepted solution]

In general related tasks would be available in the detail view of each "clients" table record. If you wish to navigate directly from the summary view, please try LINKTOFILTEREDVIEW() something like below

LINKTOFILTEREDVIEW("Client Tasks", [Ref column name in the client tasks table that references client table]=[_THISROW].[Key of the client table])

Here "Client Tasks" is assumed to be the summary view that lists all the "Client Tasks"

App column type (deep link) - AppSheet Help

LINKTOFILTEREDVIEW() - AppSheet Help

[stefanasks]

Thanks, that helped a lot. I managed to make the related tasks to show up in the details view.

[Suvrutt_Gurjar]

You are welcome.