Approve event requests, then add them to the calendar

Event requests pile up in a table and approvals get lost in chat. When someone adds a request, the operations manager is asked to approve it with the date, place and number of guests in front of them.

Approved events go on the calendar and the requester gets the link; declined ones get the manager's reason.

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 yes

Yes

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 Calendar

Tell 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!Gmail

No

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