Hi there,
I am creating an Airtable base with 3 tables to track events, contacts, and an event registration form:
- Table 1: Tracking events: event info, including a linked field to Table 2 (contacts)
- Table 2: Tracking contacts: contact info, including a linked field to Table 1 (events)
- Table 3: Event registration form: will track responses to the registration form, including people who are already existing contacts as well as new contacts
I am stuck on how to automate - either with Zapier or Airtable’s internal automations - how to create/update contact info when an event registration form is submitted.
- When a record in Table 3 (registration form) is created, I want to create a new record in Table 2 (contacts) if the contact does not exist. If the contact does already exist, then I just want to update the record, but not create a new one (which would mean a duplicate record)
- I know how to do EITHER create a new record or update a new record, but I do not know how to tell Airtable to first search for the record and if it doesn’t exist then to create it.
Thank you so much in advance for any support available!