User Database - New Records

Hi First-time Airtable user,

I am working to create database for a yearly event.

I have the current table of past year attendees and plan to use Zapier during this year’s registration period to send the record when someone registers from the ticketing platform.

My question is if the attendee has attended in past years, how to associate that new record with an existing record vs. create a new line?

Before the record is added, looking up to see if an attendee with that email is already in the database. If yes, associate that new record with an existing record, if no, create a new line?

Thanks!

  • Josh