Yes, one of the easiest & best ways of doing this is to use Fillout’s advanced forms for Airtable.

You would simply have them type their email address onto the form, and then Fillout gives you the ability to prevent duplicate form submissions based on their email address.

For even more security, you can create a login page for your form that gives you even more security restrictions. For example:

1. You can restrict the logins by SSO.
2. You can restrict the logins by email domain.
3. You can restrict the logins by password.
4. You can restrict logins based on a pre-approved list of email addresses that you have stored in your Airtable base.
5. You can verify & confirm that the user is typing in a valid email address.
6. You can limit form entries to one entry per person.

After the user logs in using your login page, that will let Fillout know who the user is and what the user’s email address is.

You can even use this information to automatically prefill other fields on your form based on who logged into your form, and you can even use this information to do other advanced tricks with Fillout.

For example, you could use Fillout’s advanced filtering features to filter your linked record fields to only show the user the linked records that they are allowed to see.

And Fillout offers lots of other advanced features for Airtable as well, such as the ability to update Airtable records using a form, create custom PDF files from a form submission, accept payments on forms, display Airtable lookup fields on forms, create new linked records on a form, control access to a form via SSO or email domains or a list of email addresses stored in Airtable, perform math or other live calculations on your forms, collect signatures on a form, create multi-page forms with conditional paths, connect a single form to dozens of external apps simultaneously, add CAPTCHAs to your form, 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