Action to list referenced items

santibarrios · 02-16-2021 12:18 PM

Hello! I´m new to Appsheet, but as far as I see it is really great!

I have the following situation:

I´ve created an app for Inspections and in each inspection, besides the generic information of it, we have to inspect some boxes. So, I have the INSPECTIONS table and the BOXES table referenced (in the BOXES table I have the inspectionID from INSPECTIONS table).

So, in inspection detail view I can see the referenced boxes of it. So far so good.

The thing is that I don´t want to display the referenced table of boxes on inspection detail view but I still need to be able to navigate to the referenced boxes with an action.

So, I want to create an action to navigate from the inspection detail view to the list of referenced boxes of that inspection (the behavior should be the same as the buttom view in the following picture, but it should be available from the inspection details and not from the boxes ref table):

Thanks in advance!

Suvrutt_Gurjar

Welcome to the AppSheet community!

Please turn off the show_if setting for the list type reverse reference column [Cajas en Inspeccion]
Please create a LINKTOFILTEREDVIEW() action on the Inspection table with an expression something like
LINKTOFILTEREDVIEW("Boxes View_Inline", [Inspection Table Key]=[_THISROW].[Inspection Table Key] )

Here "Boxes View_Inline" is the name of the inline view of Boxes table that you will typically find in the View’s list with Show System view option enabled.

santibarrios

Hi Suvrutt,

Thank you very much, it works as expected.