Jul 08, 2022 07:50 PM
I’d like to have a simple form where people can submit key words, separated by a comma. When they hit submit, they will be emailed all of the submissions to date, including theirs. Is this possible? It will be mostly words, but maybe some numbers too. Submitted as example: dogs, cats, fish, horses - Who can help? @Noamsay
Jul 10, 2022 11:22 PM
Hi Neil, yeah that’s possible. I’ve set something up here for you to check out
Here’s a preview of the email
The workflow is:
Users fill out a form with the keywords and their email
The form has a hidden prefilled link field that, on submission, will link each form submission to a single row in another table
https://airtable.com/shrEDiX6bv1a6bIaM?prefill_Rollup=Rollup&hide_Rollup=true
This automatic link will compile all the form submissions into a single cell:
We’ll have an automation that triggers when a form is submitted, that will look for that single row mentioned in the previous step, and then send the rollup text to the email address the user entered.
Happy to answer any questions you have
We’ll have to note this limitation from the documentation though:
No matter the plan type, you can send any number of daily emails to collaborators that have verified emails for their Airtable accounts. Currently, bases on the Free plan are limited to only emailing collaborators with verified emails. For non-collaborators, bases within workspaces on the Pro plan can send emails to 100 unique recipients per day. You can view your current base’s limits at the top of the “Send email” action.