What I’m trying to do
Example: Two bases, one is People, one is Events. In Persons, I track RSVPs via a list property called RSVP in which I add links to each Event they’re coming to. How to set things up so that in the Events base, I can easily see who has RSVPed to what Event?
Finally, is there a way to use that connection between Persons and Events to pull in the value of a property (e.g. email) for each of the Persons who has RSVPed to a particular event?
Things I have tried
I’ve set up the structure above, but it doesn’t seem there is any way to link the two except for manually. The only connection is in Backlinks. Is there some way to set up a formula to achieve what I’m after, or is there some other strategy, or is it just not possible?