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: email@example.com