Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Sep 23, 2022 07:46 AM
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
Trip Test is a list of trips
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)
Which ends up looking like this in grid view
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.
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!
Solved! Go to Solution.
Sep 26, 2022 02:48 AM
Hey, I’ve put something together here for you, but I’m not sure if it’s what you’re looking for
Members table:
Sign ups table
Trips table:
Trips table, gallery view:
Trips table, gallery view, Trip 1 clicked:
Trips table, gallery view, Trip 1 clicked, then Member 1 clicked:
Sep 26, 2022 02:48 AM
Hey, I’ve put something together here for you, but I’m not sure if it’s what you’re looking for
Members table:
Sign ups table
Trips table:
Trips table, gallery view:
Trips table, gallery view, Trip 1 clicked:
Trips table, gallery view, Trip 1 clicked, then Member 1 clicked:
Sep 28, 2022 10:14 AM
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.
Oct 04, 2022 04:42 AM
Well, it took 8 days to get my head around it but I’ve done it! Hugely grateful Adam. Thanks!