I have 3 sheets. Trips Categories 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 “Categorie…

[image] Relating a Category to a List of Episodes to a List of Videos with Details Ask for Help Take a look at Multi-Level Select in https://concepts.glideapp.io/ . The key is to build templates for your relations if you need to go multiple levels deep.

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 det…

Does this comment help? [image] Relating a Category to a List of Episodes to a List of Videos with Details Ask for Help Check out how I make three sheets here: Level 1: Category Level 2: Episodes Level 3: Videos In Level 1, I make a relation to the Episodes sheet. [i…

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 …

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 …

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

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?

Relations Question

Ask for Help

Jeff_Hager May 31, 2020, 6:07am 2

Topic		Replies	Views
Relating a Category to a List of Episodes to a List of Videos with Details Ask for Help	14	952	May 30, 2020
Separation of categories Ask for Help	3	417	May 30, 2020
Help with categories Report a Bug	6	431	May 1, 2020
Issue with datasheet link - inline or related list Ask for Help	9	244	July 19, 2022
Category with buying option Project Showcase	5	373	May 19, 2024

Relations Question

Related topics