Find similar email and update records

Hi, I have created a Typeform survey and a Airtable to record all the answer.
However, if a user using a same email. It will create a second record with same email.
How can I have AirTable filter by email and update records accordingly? Is this achievable?

Please look at 1st Survey table.

Thank you

Below are some options to help you accomplish this:

First, you could leverage an integration tool such as Zapier or Integromat as middleware sitting between Typeform & Airtable. You could configure a scenario in either case that would do the logic of first searching for a record with that email address to see if it exists & update if it does; otherwise insert the record normally.

Another option is to let the data flow to Airtable as is in all cases, but have the target table act not as the final set of data, but rather as a processing queue. Then, use the Automations feature in Airtable to trigger an automation that essentially does the same logic as in the option above–checking to see if the email address exists & updating if so, otherwise inserting.

Depending on your use case the logic may differ a bit, but this general scenario is common in data processing & is many times referred to as an “upsert” (update if exists/insert if doesn’t).

Hope this makes sense!

2 Likes

this is what i’m working on as well.

my form is in Airtable, and i want it to match people by email. can i do the “up” and the “sert” in the same automation? i’ve gotten it to find a person who matches by email and update them. but i’m not sure how to tell it “if it doesn’t match, create them” without making a new automation. and i am limited to 25 automations, with a bunch more things i want to automate, so i’d love to combine if possible.

thanks for any advice you can provide!!

1 Like

In my personal opinion, the best way to tackle all of this is to use a professional automation tool like my personal favorite Integromat, which also has a native “Upsert” module for Airtable:

1 Like

how did you managed to find a person match email?

I am watching some YouTube guides.

Can I know what view is this? I don’t seems to find this view.

You might benefit from watching my free, beginning-level, Airtable training course entitled “Learning Airtable”:

1 Like