Very complicated deep link

[mic_anghileri]

Good evening, i already ask your forgiveness for the question i am about to ask as there is a very simple way to obtain the same result with an action but graphically I like it less I try to explain myself…

Let’s consider these 3 tables: “Income”, “Users”, “Ref menu”

1- Income: contains all the entries of the various projects in the app and each row in this table has a reference user from the second “Users” table

2- Users: this table as mentioned above contains all users who can add rows within the “income” table and other tables.

3- Ref menu: and that’s where the complex part comes in for me. “ref menu” is a sheet table to which I have assigned a view as a gallery and then insert it as “ref” inside the “Users” table in order to be displayed in Users_Detail.

so I would like it to behave in the following way but I don’t know how to do it. for example by clicking on the first card of the gallery, the one with the label “Income”, I would like to see the view of the income that have been added by the user from which detail page the gallery button was clicked.

I don’t know if this is possible and how it could be. I tried creating slices, behavior and I don’t know how many other ways but without success.

I trust in your support! thank you all guys

[SkrOYC]

Two things.

1. The “Ref” you are refering to that you made to make an inline view is not a ref, it’s a List column type, Ref column type is different.
2. What do you expect to do exactly with the “Ref menu” table? I mean, what are those exactly? You are going to have another “Outcome” table apart from the “Income” one?

Finally, this is done by using an Action that you can attach to the “Select” event for your inline gallery view

[mic_anghileri]

yes forgive me, that’s exactly what you wrote, a List Column type, and yes I also have an “Outcome” table in addition to the “Income” one.

I would like to click for example on the “income” card of my gallery view to display the income page with only the results added by the user from which Users_Detail page the gallery was clicked.

what I am wondering is, how can I collect the user ID in question with an action applied to the table linked with the list column type? it’s possible? and if this were possible how can I then filter the rows of the “Income” table so that only those of this user are displayed?

Thanks for your help, I hope I was clear because it is difficult for me to even explain it

[SkrOYC]

The easiest way would be this IMHO:

1. On your “Link” column (if you don’t plan to use it for anything else) put the name of the Income and Outcome View, as named on AppSheet under UX → Views. This should be a ListView (Deck, Table, etc). In your case, use the name of the view you told us you made for the “Income” Table.
2. Create an Action related to the “Ref menu” table with a “Do this” of “App: go to another view within this app”. Under Target add this expression:

LINKTOFILTEREDVIEW(
  [Link],
  [TheUserColumnOnTheIncome/OutcomeTable]=[_THISROW]
)​

• It’s Prominence should be “Do not display”
• Go to the Gallery view you made and under “Behavior” → Selected, select the action you made on #2

I’m not completely sure if AppSheet will pass the user on the Target expression I gave you so first tried and come back with the results

[mic_anghileri]

unfortunately I have already tried this solution several times but it doesn’t work.

I think the problem is that the action refers to the table “Ref menu” and therefore does not find neither the [Link] column nor the [Added by] column (TheUserColumnOnTheIncome / OutcomeTable), which should then compare with the ID of the user whose User_Detail page is displayed at that time but again it doesn’t work.

[mic_anghileri]

@Steve do you have any idea?

[Marc_Dillon]

No, you can’t get the user value from the top-level view’s record, within a row select behavior on an inline view. (unless the inline records are somehow related to the top-level record, which it sounds like they aren’t).

I suggest foregoing the inline “menu” selection, and just use Action buttons on the user detail to execute your LINKTO… actions.

[SkrOYC]

Sorry on my late reply.

I echo @Marc_Dillon 's comments