The easiest & best way to do this is by using Fillout’s advanced forms for Airtable.

Fillout is 100% free, and it offers hundreds of features that Airtable’s native forms don’t offer, including the ability to update Airtable records using a form, display Airtable lookup fields on forms, control access to a form via SSO or email domains, perform math or other live calculations on your forms, accept payments on forms, collect signatures on a form, create multi-page forms with conditional paths, create new linked records on a form, and much more.

In your case, as soon as they fill out a “new record form” for the first time, their new record will be created in Airtable, and you will send them an automated email that gives them a special URL. This special URL will enable them to update their record in Airtable by using a Fillout “update form”.

You can see how to set this up in my Airtable podcast video here, which also shows off many other advanced techniques using Fillout as well. So this video isn’t only about updating records from a form, but that is a part of the video.

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

I take it you’re using a ‘Find record’ step to look for the email in your main table, and then updating the fields from there? If so, I’ve put it together here for you to check out

And this is how the automation looks

You can duplicate the base into your own workspace to poke around and compare it to your own set up; lmk if you hit any issues and I’ll see what I can do to help!

---

Airtable also has a guide on how to do this here with linked fields instead: https://support.airtable.com/docs/use-case-update-records-via-a-form

The principles are pretty similar but I usually don’t like putting a linked field into the form as that could lead to bad data if people unlink the value and link to another record.  Depends on your use case though; if it’s all internal and you trust the people involved then the linked field version’s easier to set up for sure!

I second Scott’s suggestion to use Fillout.

If you’re interested to try it out, here’s an overview of what you’d need to do to set it up.

1. Create a Fillout account and add a new form
2. Link your Airtable base to your new form
   1. Choose “Update record” – Update an existing record when the form is submitted
3. Add a new formula field in Airtable to store your unique Fillout link – you’ll send this unique form link to people to fill out as many times as they want. Instead of creating new records per form submission, the original record will be updated with the new information. 
   (The nice thing about this form is it’ll already be prefilled with info people have submitted before, so they won’t need to redo everything—just a quick check to confirm it’s all still correct, make quick corrections, fill in missing gaps.)
4. Create your form with newly synced Airtable fields, and publish your new form!

Example gif of using a form to update existing records, instead of creating new ones:

Example Airtable base and Fillout template to get you started:

• https://airtable.com/invite/l?inviteId=invqpml3ulxyDuxNV&inviteToken=57b549aaeb08500f90743c3ffc4c705e81210143194c4feff91c34b69e1d8923&utm_medium=email&utm_source=product_team&utm_content=transactional-alerts
• https://www.fillout.com/templates/update-airtable-record?ref=bryan20

Bryan