Help

Referencing multiple records in one base

Topic Labels: Base design
Solved
Jump to Solution
615 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Isaac_S
5 - Automation Enthusiast
5 - Automation Enthusiast

I know there are a million variations on this question already but I’ve read all the solutions and spent several days trying to resolve it and am still stuck. Perhaps my issue is unique, perhaps I’m just slow.

I have 3 tables in my base. Trip Test, Members and Trip sign ups.
Members is a list of members
Screen Shot 2022-09-23 at 10.36.57 AM

Trip Test is a list of trips
Screen Shot 2022-09-23 at 10.36.40 AM

Trip sign ups is a sign up form where a member selects which member they are in a form (from a look up of the Members list)
Screen Shot 2022-09-23 at 10.37.16 AM
Which ends up looking like this in grid view
Screen Shot 2022-09-23 at 10.40.00 AM

I am trying to create a view in Trip Test that pulls in and shows which member has signed up for each trip (preferably so that member can also be clicked on to show additional info like their photo). All I’ve ended up with though is another selection field to choose those members rather than pulling those that have already signed up.
Screen Shot 2022-09-23 at 10.39.41 AM
Screen Shot 2022-09-23 at 10.44.04 AM

The hoped for behavious is that field 5 in the Trip Test gallery/table displays information that’s in the 2nd column of Trip Signup.

I’ve been tearing my hair out. Any help is greatly appreciated. Thanks in advance!

1 Solution

Accepted Solutions
TheTimeSavingCo
17 - Neptune
17 - Neptune

Hey, I’ve put something together here for you, but I’m not sure if it’s what you’re looking for

Members table:
Screenshot 2022-09-26 at 5.47.03 PM

Sign ups table
Screenshot 2022-09-26 at 5.47.07 PM

Trips table:
Screenshot 2022-09-26 at 5.46.33 PM
Trips table, gallery view:
Screenshot 2022-09-26 at 5.46.39 PM
Trips table, gallery view, Trip 1 clicked:
Screenshot 2022-09-26 at 5.46.47 PM
Trips table, gallery view, Trip 1 clicked, then Member 1 clicked:
Screenshot 2022-09-26 at 5.46.55 PM

See Solution in Thread

3 Replies 3
TheTimeSavingCo
17 - Neptune
17 - Neptune

Hey, I’ve put something together here for you, but I’m not sure if it’s what you’re looking for

Members table:
Screenshot 2022-09-26 at 5.47.03 PM

Sign ups table
Screenshot 2022-09-26 at 5.47.07 PM

Trips table:
Screenshot 2022-09-26 at 5.46.33 PM
Trips table, gallery view:
Screenshot 2022-09-26 at 5.46.39 PM
Trips table, gallery view, Trip 1 clicked:
Screenshot 2022-09-26 at 5.46.47 PM
Trips table, gallery view, Trip 1 clicked, then Member 1 clicked:
Screenshot 2022-09-26 at 5.46.55 PM

Thanks so much for this Adam, very grateful indeed. I’ve started playing around with it and trying to get my head around how to make it work with my existing data. I’ll follow up once I’ve had more time.

Isaac_S
5 - Automation Enthusiast
5 - Automation Enthusiast

Well, it took 8 days to get my head around it but I’ve done it! Hugely grateful Adam. Thanks!