Case Study: Event Registration Powered by Airtable
This case study outlines how I used Airtable to organize registration for an offline event, one day meditation courses.
About
In Belarus, one day meditation courses are conducted on a mothly basis since 2017.
Every month, an email campaign is sent via SendGrid. This campaign contains a link to Airtable form. People apply for such course by filling this Airtable form.
Process
Once a user fills the form, two things happen:
- The applicant receives confirmation email saying that application is received.
- The organizer receives actionable Slack message with application data. The application can be either approved or canceled without leaving Slack.
The form itself is Airtable interface, and the above actions as powered by Airtable automations.
 |
|---|
| Actionabe Slack message with application data is sent to the organizer. The Organizer can either approve or cancel it. |
Once an organizer verifies the application an email with route details is sent to the applicant. In case of cancelation the cancelation email is sent.
One thing to note about such meditation courses is that this event can be held in different places. Also, the contact peson can be different. To address this problem an Email Pieces table was created where a proper place address can be selected as well as contact person details.
 |
|---|
| The email with route details can be confgiruered so that place adrress can be selected as well as contact info details. |
Here is the full list of Airtable automations:
- When new application is submitted, an email and Slack actionable message is sent
- When application status is set to confirmed, the email with route details is sent to the applicant. This email is composed so that one of places can be selected as well as contact person details. Also, Slack notification is sent to the organizers.
- When application status is set to canceled, the cancellation confirmation email is sent to the applicant. Also, Slack notification is sent to the organizers.
Contact
I would be happy to discuss your case. Feel free to contact me at preshetin@gmail.com
© Peter Reshetin.RSS