I have two tables in Airtable: Meetings and Members. I’d like to create a new Google Calendar invite any time a Meeting record is created or edited[*]. I have that (mostly) working.
The trouble is, I need the list of attendees to be populated from (a view within) the Members table.
There doesn’t seem an easy way to do this, since the Zap seems to want everything to come from the same table (though that table seems to be numbered #1, so I’m hoping I can join Members as #2?
I toyed with the idea of using an Automation to populate an Attendees column in every record in the Meetings table, but creating a lookup column of the emails in a multi-reference to Members column was foiled because I could not use that lookup column in the Attendees field in the Zap. It appear that it wants me to enumerate the attendees in the Zap?
Is there something obvious (or clever, even) that I’m missing? I don’t really want to have to write a script that builds on these two APIs myself, since I feel like I’m SO CLOSE!
[*] I know that can lead to duplicate events, I’m going to start with this as the proof-of-concept, and refine it from there.