Sure, you can do this before or after the form is submitted.

To do it before the form is submitted:

You’ll need to use Fillout, and create a login page for your form. Then, after the user logs into the form, you can automatically default their email address into a linked record field on your form. Then, when the form is submitted, everything will already be tied together in Airtable.

To do it after the form is submitted:

If your linked record field in Airtable displays email addresses, then you could just use the email address on the form in an Airtable automation to “Update the Record” to update the submitted record’s linked record field with the email address that they typed into the form.

The primary field on the linked field is the person’s actual name, not the email address.
I see how that works if the email is the primary field in the linked table, but is it possible to make it happen without it being the primary? Thanks.

Yes, at the time when this was written, Airtable’s Automations didn’t include a “find records” action, but now they do. So you can use a “find records” step to find the record you’re looking for.

However, for more powerful automations, I always recommend using Make’s advanced automations for Airtable.

Awesome, thanks for your help!