I absolutely recommend Fillout for this. I use it for events and I don't find it to be glitchy at all. Feel free to schedule a session if you need further assitance!
Using Airtable’s native forms for this is not often recommended because Airtable doesn’t offer any straightforward nor easy way of doing this. But note that if you do use Airtable’s forms, you don’t actually need to have people choose their email from a list… you can just have them type in their email address, and then you can use an automation to find their record.
However, as Brian mentioned above, your #1 best bet for this is to use Fillout’s advanced forms for Airtable, which lets people update their own Airtable records from a form.
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, 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:
Also, most importantly for you: with Fillout, you can create a login page for your form, which will give you these options:
- You can restrict the logins by SSO.
- You can restrict the logins by email domain.
- You can restrict the logins by password.
- You can restrict logins based on a pre-approved list of email addresses that you have stored in your Airtable base.
- You can verify & confirm that the user is typing in a valid email address.
- 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 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.
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
Instead of getting attendees to select their email, get them to type it in. Then you can have an automation look for that email in your primary table and update the record it finds. There's a possibility that people might end up typoing their own emails though, so I'd also recommend setting up an action to email you if no record can be found with the email they've keyed in
Yes, that’s what I already said above. Again, this is not the recommended approach, but that’s how you would do it if you wanted to take the non-recommended approach.
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