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?
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).
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.