I want to use a form to allow volunteers to register for upcoming events. Each volunteer can select multiple events. Volunteers may also return to fill out the form more than once, as many of them will return for future events. The volunteers will just be members of the general public, not Airtable users.
Is it possible to set up my tables and form to ensure the following conditions are met?
1. Each volunteer is listed in the Volunteers form once, with a unique email address and phone number for each volunteer.
2. Volunteers select one or more upcoming events from a list of upcoming events.
3. Volunteers who return to fill out the form more than once can select other events, but the name and contact information they enter is not duplicated in a new record. Only the new events they sign up for are added to the record that already exists for them.
Yes, so long as you're using an Airtable Pro account to setup the Base and the Table's Form Views, you can have an Automation run after each form submission to do a check against the users name/email and if the existing volunteer already exists, then use the original member record ID and remove the duplicate that's created upon filling out the form more than once.
There's a chance someone here can show you a no-code method of doing the same thing.