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
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
Link used for the base linked above: 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:
How many emails can I send per day?
No matter the plan type, you can send any number of daily emails to collaborators that have verifiedemails 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.