Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

How can I add an attendee to a calendar invite once they fill out the Airtable registration form?

Topic Labels: Automations
116 1
Showing results for 
Search instead for 
Did you mean: 

We have an event that is in multiple different locations. We have a form where they select which location they want to attend. I want to automatically send them the calendar invite when they fill out the form based on their response. Ex: We have an event on Monday in New York, Tuesday in Boston, and Wednesday in Chicago. If they select Wednesday in Chicago they will receive the outlook calendar invite for that specific event.

1 Reply 1

Hi Ana,

I believe you should have an Events table and a Form Submissions table of some sort?

If so, I would create a link between the two tables so that each Form Submission was linked to the right event. You could accomplish this link by adding a linked field to the form and allowing your users to select the event, or via an automation

Screenshot 2022-10-21 at 1.13.51 PM

Screenshot 2022-10-21 at 1.14.19 PM

From there, I’d create a lookup field in the Events table to get all the emails for that event, and I would finally have an automation which has a trigger “when record updated” that would watch the Email (from Form Submissions) field, and its action would be to update an Outlook Calendar Event, specifically the Attendees field with the list of emails like so:

Screenshot 2022-10-21 at 1.18.08 PM
Screenshot 2022-10-21 at 1.18.14 PM