Map detail showing filtered rows from another table

[sfd_pl]

To create appsheet to track items on respective lanes and allow user to click on the pin of respective lane to see the number of pallets and details of the pallets. Details of pallets are store in table[F1 Summary].

I added an action which will bring me to F1 summary view and now i’m struck on how to filter and show only the 24 pallets detail on F1-1. There is no such actions otherwise i think the solution is to group these actions.

[Suvrutt_Gurjar]

Your requirement is not very clear. But it sounds that you are looking for LINKTOFILTEREDVIEW()?

help.appsheet.com

LINKTOFILTEREDVIEW()

Constructed deep link to filtered view

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.

AppSheet

AppSheet : mobile apps from spreadsheets : Template: for the industry

This app shows how to filter your data using a form. Try filling out the form and saving. You'll be taken to a filtered view of the data based on the form values.

[sfd_pl]

Sorry bout that.

So F1 summary contains a full detail of F1-1 to F1-42. When user click on the “eye” beside actual pallets, information of all pallets in F1-1 will be shown.

How do i incorporate the linktofilteredview here?

[Suvrutt_Gurjar]

Maybe

LINKTOFILTEREDVIEW(“Your Summary View Name”, [Lane]=[_THISROW].[Lane])

[sfd_pl]

Ok but where should I insert this into? Action behavior only allow Yes or No.

[Suvrutt_Gurjar · Accepted solution]

In the Target setting of the action’s image you have shared.

[sfd_pl]

Hi Suvrutt_Gurjar,

Thank you for the solution and it works! Just need to change Lane to XY position.