Filter by _row

AppSheet AppSheet Q&A
1

I’ve given up despite many hours of searching and trying different things (noob alert)

structure
table 1 work orders table view (filtered by open only) works lovely

table 2 inspection form view of Inspection records table works lovely add/edit records as wanted

Now when you click the work order row it opens to show you the row in full, I have an action button there that I would like to to show me all records from the inspection records table where the specific location of work order table clicked row matches inspection records table.

using LinktoView I get the closest but always blank using [_Row].[Specific Location] but if I swap this part for “example of specific location” it works!?

Parent table key is “Specific location” child table also has “specific location” as ref to parent

somebody please put me out of my misery. Please please please

2

The table 2 records have a Ref to a table 1 record? There should be a [Related…] VC, which should display as an inline view when showing that column in the table1 detail view. That should already get you what you want, no?

Otherwise, perhaps you should use LINKTOFILTEREDVIEW instead of LINKTOVIEW?

https://help.appsheet.com/en/articles/2357260-linktofilteredview

And do you mean [_THISROW] when you say “[_Row]”?