How to Create an Action Button that Opens another View with Filtered Data based on This Row Column Value

[flyboy_aby]

Hi, this my First App. I have Three Tables in my App. “Orders” table has all the Orders , “Supplier” table has all the suppliers. The third table “Matches” all Orders with all the Suppliers. A Filtered view is generated based on conditions . The Key in the Matches Table is Concatenate of Key of Order and Key of Supplier. This is working fine and shows ALL the Suppliers for ALL the Orders for any User.

What i want to do is : - Action Button to Show ALL the Suppliers for THIS Order of the User

I just can’t figure out how to do this. Any Help would be appreciated

Thanks

[Aurelien]

Hi @flyboy_aby

You may want to have a look here:

help.appsheet.com

App Column Type (Deep Link)

Learn how to use deep links to navigate to another view in the same app, or in another app.

help.appsheet.com

LINKTOFILTEREDVIEW()

Constructed deep link to filtered view

Can you try with it, and if you don’t succeed, can you share:

• what you tried so far
• your tables structures

[flyboy_aby · Accepted solution]

Thanks @Aurelien . LINKTOFILTEREDVIEW() helped ! Its working. Thanks again