We’re helping a client build their marketing site, and we also want to help release an MVP using Airtable (I think).
The app will match a “teacher” with “student”. Each party will receive an email introducing them, and encouraging the next steps.
Everyone will register through the site; this is an easy part— to connect Typeform to Airtable to collect all the data. (2 forms: teacher form + student form)
On the admin backend, the “matching” of the teacher and student will be done manually.
The admin will manually select both parties from a list and click to send both parties the same HTML email that contains connection instructions. (one email send to both parties)
So here are the questions…
Is it possible to build functionality to select two rows (teacher & student) and fire-off a pre-formatted HTML email to these members?
What platform be needed to hold the email template and on-command, populate several fields with data from Airtable + send the email?
To have an admin record of the pairing, we also need a way to write back to Airtable. (my thought— this could be triggered by a “CC” on the email, but maybe there’s a better way)
There will be other needs— the admin should be able to filter the records to narrow the list. In my generic view, I’m showing a handful of records, but there could be hundreds to wade through.
If possible, an interesting solution could be to:
 Find a student
 Lock student
 Find a teacher
 Lock a teacher
 Mash the GO Button
I’m sure several of you have awesome answers!
Please post comments/questions here, or email me directly: firstname.lastname@example.org
Airtable Support just blew my mind. Before posting to the forum, I send the same question to Support, and (Laurie) replied with this!
(I told her the following too)
Please know that this type of response is key to converting me from tire-kicker to platform champion.
__________ SUPPORT __________
I’ve given some thought to your setup and have the following suggestions.
That would take care of how to pair up the students and teachers. You would next want to use an integration service like Zapier to make a custom email that would send to both the teacher and the student. To get started with building a Zapier integration for Airtable, I’d recommend taking a look at (redacted: Using-Zapier-to-integrate-Airtable-with-other-apps-and-services). We have a specific article for custom emails at (redacted)
Sounds pretty cool and pretty simple.
Check out Zapier.
One possible solution can be, if you are doing things semi-manual, you can create a new base (linked to the Members base) where you can input the teacher and the student. Zapier can watch for new entries, and send an email via GMail (or a number of other email service providers).
You can check out wufoo also.
Best of luck.