LINKTOVIEW to search records in another AppSheet in TABLEVIEW

I'm trying to search for a specific record in 2Appsheet using a button action in my 1Appsheet.

The button works launching the 2Appsheet with desired View but are  shown all existing records in that table and not only the record i've selected, why ?

LINKTOFORM("Name_of_the_view_in_2AppSheet",
"Name_of_the_column_in_2AppSheet", [_THISROW].[ID],
"2nd_AppSheet_Link")

 

0 44 602
44 REPLIES 44

Hello @FaCe 

Your issue is happening because LINKTOFORM() is designed to open a form view and pre-fill it with the provided valuesโ€”it does not filter an existing view to show only a specific record.

Solution:

You need to use LINKTOFILTEREDVIEW() instead of LINKTOFORM(). The correct syntax is:

 

 
LINKTOFILTEREDVIEW("Name_of_the_view_in_2AppSheet", "Name_of_the_column_in_2AppSheet" = [_THISROW].[ID])

 

 

Explanation:

  • LINKTOFILTEREDVIEW("View_Name", Filter_Expression) opens a filtered version of the view.
  • "Name_of_the_column_in_2AppSheet" = [_THISROW].[ID] ensures only the record matching the selected row is displayed.

Alternative:

If you want to open a detail view of the selected record in 2AppSheet, use:

 

 
LINKTOVIEW("Detail_View_Name") & "&row=" & ENCODEURL([_THISROW].[ID])
 

This will navigate to the detail view of that specific record.

Let me know if you need more help

We should try this too. Perhaps we can save ourselves the trouble of taking the actions I was proposing.

Hi @Tijesuni but LINKTOFILTEREDVIEW() seems not to work among 2 Apps, or i'm wrong ?

Notes

LINKTOFILTEREDVIEW() cannot be used to navigate to another app.

 

And i'm trying to go to a table view in my second App not detail view

@FaCe 

Can you please send me your question again

I've open a new thread here specific for how to create a deep link, so probably we can solve my request with another approach. 

Top Labels in this Space