Relations Question

I have 3 sheets.

  1. Trips
  2. Categories
  3. Reservations

I’m trying to link everything like the following:
Open Trip 1 > View All Categories (i.e. Flights, Agenda) > View only the related items for this specific trip

It’s easy for me to link Trips & Reservations, but can anyone help me get the “Categories” in there first, and then show the reservation details?

I’m digging in some more but not following one piece.

In my example, I’d like for the middle page (i.e. categories) to be static and not change. So every trip has a flight, every trip has a schedule, etc. I’m having trouble linking the Trip to the Category, and then the Category to the relevant details.

Does this showcase app help?

Does this comment help?

Thanks for this, though I admit I’m still confused!

On sheet 1, I have all of the Trips (i.e. NYC, Miami, etc.). On sheet 3, I have all of the info correlating to each trip. On sheet 2 I want to have a static image of a plane. So:

When one opens NYC, they see the flight icon, open it and view the flight.
When one opens Miami, they see the flight icon, but when they open it they view the Miami flights only. Is this doable? I’m running into issues with both concept apps here.

Can a category have multiple pieces of information? For example, if you had multiple flights for one trip? Would you only want to only see one flight icon to click through and see all flights, or would you want to see multiple flight icons, but with the same image?

Great question, thanks for clarifying.

The “flight” category can have multiple flights, but only want to view the ones directly related to that trip. The issue I’m having is getting the categories to match the trip ID on one end, and then match the flight AND trip on the other end.

What I would do is create another sheet that replaces your category sheet and uses the unique formula to build a list of unique trips/categories. Then create a relation to link the trip sheet to the trip/categories sheet and display this as an inline list. Then you can click through from the trip to the trip/categories details. Within the glide data editor, you can then create an if/then column to refer to an associated image url or use a relation to another sheet that contains your images and categories followed by a lookup to pull in the image url. Also create a template of the trip/category in the trip/category sheet and do the same in the reservations sheet. Then you can create a relation to link the two templates and you can then have an inline list of the associated reservations within the details of the trip/category sheet.

1 Like

Thank you! Let me play around with this idea, and report back!

2 Likes

Circling back, how does the UNIQUE formula help? I’m hitting the same issue again:

When I open a trip to view the flights, I view flights for EVERY trip, and not that specific one.

The UNIQUE formula takes all unique values inside the defined range. Can you show me how you setup your data now?

Here’s a sheet with the bare bones.

I want to link the NYC1000 to Flights to then view both corresponding flights

I’m able to link the Trips to the Reservations, that’s easy with a Relation. However, I can’t figure out how to get every Trip it’s own set of Categories, which then link to the relevant reservation. Does that make sense?

So let me go through this again to see if it helps.

You have a bottom level sheet, which contains all the reservations. Let’s say it contains columns of trips, categories and reservations.

We go backwards to the 2nd level, which is the “categories”. For this one I want a unique for all trips & categories, the 2 top levels. I use a formula like this to take into account the empty rows as well.

=UNIQUE(FILTER(Res!A:B,Res!A:A<>""))

Then, in the top level, I follow the same logic and get uniques for all the trips. That would be:

=UNIQUE(FILTER(Res!A:A,Res!A:A<>""))

Then you can build all the relations as I have mentioned in the linked post. Tell me if I can help.

1 Like

Following a bit more now. What’s this for (on the Reservations tab by each item), and how do I move forward with it? Do I add to it?

Reservation
A001
A002
M001
P001
A001

Yeah that’s just my example data, fill in what you want within that column.

How did you pair/use that column with anything else?

You mean the reservations? It’s the last level of your data, so I don’t do anything with it. Just going from that last level backwards using UNIQUE.