Hey ​@Caroline!

This cant be done using Airtable native forms.

Even using other third party form providers (I would suggest using Fillout) this could still be challenging as you would probably need to build the integration using Make, or n8n for having more control of the workflow. (check this article for more information on different automation tools)

Once the submission has been done, using your automation tool you could check on your backend and (i) search for submissions from same email addres and avoid creating the new record, or creating it but not taking it into consideration; (ii) emailing the respondant to let him know his submission will not be taken into consideration; (iii) use a webhook repsonse to redirect them to a page were they see that the submission did not go through… or similar workflows.

This could be achieved way more easily if you have a clear mailing list that should receive and submit the form. You could have a Contacts table with a dynamic url for the form submission. Form submissions would be created on its own table, linked to contact. If Contact has >0 submissions linked to it already, then fillout would allow you to prevent a new submission, show a banner or similar workarounds.

Fore more info on Fillout vs. Airtable forms you can check out this article.

Please let me know if you need any help setting this up!

Mike, Consultant @ Automatic Nation

​Hi @Caroline,

As Mike said above, you can’t do this with Airtabke’s native forms.

However, you can very easily accomplish this — in just a few seconds — with Fillout’s advanced forms for Airtable.

All you need to do is create a login page for your form, turn on email verification, and then select the option that says “limit to one submission”.

Fillout also offers hundreds of other features that Airtable’s native forms don’t offer, including the ability to update Airtable records using a form, display Airtable lookup fields & Airtable rollup fields & Airtable attachments & formulas on forms, control access to a form via SSO or email domains, and much more.

I show how to use a few of the advanced features of Fillout on these 2 Airtable podcast episodes:

• Using Fillout to create an eSignature approval process with PDF file creation.
• Using Fillout to create an order entry form with line items.

Hope this helps! If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

Fillout is a great option as Mike mentioned. You can also do the following:

1. save all of your forms to one table
2. have an automation create and update records

Some of our clients want to collect forms just one and others want submitters to update information over time so it could totally depend on your workflow.

Cherry (claribase.com)