How to enable this function on Glides?

Ask for Help
1

Hello Kings & Queens of Glide!

Below is the screenshot of a random Gsheet extract i made & want to display this data on the app.

I want each specific users to click on a ‘view invoice’ button & a small table appears which display their particular invoice and its amount against it.
How do I enable this function on Glide?

Note - My master data source is G sheets already linked to the app & already created a row ID for each users (the Row ID appears before the ‘Code’ column & cropped for obvious reasons)

{93B7E916-9AC9-48D5-8C0C-4D9C31DEC4D8}
{93B7E916-9AC9-48D5-8C0C-4D9C31DEC4D8}1074×554 50.7 KB

2
2 Likes
3

What I’ve done one time, is when a user clicks that button, it opens a new screen with a relation.

  1. So you have table 1 with you invoices.
  2. Table 2 with your invoice items (or child-invoices, etc).
  3. Create a relation from table 1 to table 2 based on the invoice number.
  4. Then clicking on the button opens a new screen using the relation to table 2 and displays a collection table of all items related to the invoice from table 1.

I hope this helps. Is that what you are looking for?

4

That’s exactly what I figured last night & its working now. Thanks JB! :yellow_heart:

1 Like
5

For people trying to do the same, could you mark my answer as the solution? Thanks!