:thumbs_up: +1 This would be super helpful for our communications with user research participants. We usually send recruits emails to confirm their attendance at sessions/workshops.
With the low numbers of recruits / participants for each study, this could even work on an ad hoc basis, as a 1-by-1 compose email through my native desktop email client (Outlook). Not sure whether batch processing might suit others better.
@Ben_Orozco ideally how would this work for your situation?
Ben, did you figure this out? You send to a single contact/record simply by setting the filter so only that record shows in the view. Let me know if I misunderstood the question.
Let’s say you have an Airtable form that gathers name, email, phone number, and favorite color. Each time a form is submitted, a new record is created in your table with those fields. Now, go to your SendGrid block, choose the appropriate table, view, and email field, and finally compose your email using variables from the single record that were populated by the form:
Dear {Name},
Thanks for submitting the form! We now have your contact info as {email} and {phone number} in our files, and we know your favorite color is {favorite color}. Please let us know if anything changes!
Now, obviously you don’t want to send that email again to people who have already received it. You can control for this by adding a checkbox field to your table, then creating a new view that filters out the records with this field checked. Now, set your SendGrid block to use this new filtered view. After you send your new form responses, just check the box in the corresponding record and it will disappear from the view – and you’re ready for a fresh form response and new welcome email.
