Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Dec 16, 2021 12:15 AM
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
Dec 16, 2021 04:22 AM
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!
Dec 16, 2021 08:24 AM
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!!
Dec 16, 2021 08:43 AM
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:
Dec 16, 2021 06:57 PM
how did you managed to find a person match email?
Dec 16, 2021 09:32 PM
I am watching some YouTube guides.
Can I know what view is this? I don’t seems to find this view.
Dec 17, 2021 03:21 AM
You might benefit from watching my free, beginning-level, Airtable training course entitled “Learning Airtable”:
Jul 11, 2023 08:56 AM
I have been able to made it without Zapier.
Suppose two tables :
What you have to do is :