When an event request is added in Airtable, asks the ops manager to approve it, then books it and tells the requester.
Uses
Airtable
Gmail
Google Calendar
Approve event requests, then add them to the calendar
AirtableWhen a record is added to Event requests. Save it as request.When a record is added to Event requests. Save it as request.
Operations manager's emailSet ops_manager_email to blank.
Day and time of the eventMake request.fields.Start readable and save it as event_day.
Ops manager approves the eventRequest approval: Approve event: request.fields["Event name"] Save it as decision.
Who to ask: ops_manager_email
Prepared by: request.fields["Requester email"]From request.fields["Requester name"] (request.fields["Requester email"]): request.fields["Event name"] on event_day at request.fields.Location. Expected guests: request.fields.Guests
If decision.approved is yesIf decision.approved is yesYes
Put the event on the calendarCreate the event request.fields["Event name"] from request.fields.Start to request.fields.End. Save it as event.
Location: request.fields.Location
Attendees: request.fields["Requester email"]Google CalendarTell the requester it is approvedSend an email to request.fields["Requester email"]. Save it as approved_email.
Subject: Approved: request.fields["Event name"]Hi request.fields["Requester name"],
Your event is approved and on the calendar: event.html_link
Thanks!GmailNo
Tell the requester it was declinedSend an email to request.fields["Requester email"]. Save it as declined_email.
Subject: Not approved: request.fields["Event name"]Hi request.fields["Requester name"],
We could not approve this event. decision.commentGmail