Update Airtable with Typeform or any survey answer

2025 Update:

This is not possible with Typeform on its own, so you would need to use Make’s TypeForm integrations and Make’s Airtable integrations to automatically update your Airtable records with data from TypeForm form submissions.

If you’ve never used Make before, I’ve assembled a bunch of Make training resources in this thread. For example, here is one of the ways that you could instantly trigger a Make automation from Airtable.

However, your #1 best bet for all of this is to permanently leave TypeForm altogether.

Instead, you will want to use Fillout’s advanced forms for Airtable because it communicates directly with Airtable and it lets you update Airtable records directly from a form.

Fillout is 100% free, and it offers hundreds of features that Airtable’s native forms don’t offer, including the ability to update Airtable records using a form, create custom PDF files from a form submission, accept payments on forms, pre-fetch dynamic data from an Airtable record, customize the style and branding of your form, customize a theme for your form, display Airtable lookup fields on forms, create new linked records on a form, add a login page to your form, perform math or other live calculations on your forms, collect signatures on a form, create multi-page forms with conditional paths, connect a single form to dozens of external apps simultaneously, add CAPTCHAs to your form, and much more.

I show how to use a few of the advanced features of Fillout on these 2 Airtable podcast episodes:

• Using Fillout to update an existing Airtable record & create an eSignature approval process with PDF file creation.
• Using Fillout to create an order entry form with line items.

Hope this helps! If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

Thanks, do you mean if i subscribe to Zapier, I can do it without code? just using trigger?

If I need the scripts do you have an idea how much will it cost?

2025 Update:

You mentioned Zapier in your message above, but I would STRONGLY recommend against using Zapier. Make is INFINITELY more powerful & customizable than Zapier, yet it is SIGNIFICANTLY CHEAPER than Zapier. I wrote an entire post here comparing Make vs. Zapier.

Instead, you will want to use Fillout’s advanced forms for Airtable because it communicates directly with Airtable and it lets you update Airtable records directly from a form.

Fillout is 100% free, and it offers hundreds of features that Airtable’s native forms don’t offer, including the ability to update Airtable records using a form, create custom PDF files from a form submission, accept payments on forms, pre-fetch dynamic data from an Airtable record, customize the style and branding of your form, customize a theme for your form, display Airtable lookup fields on forms, create new linked records on a form, add a login page to your form, perform math or other live calculations on your forms, collect signatures on a form, create multi-page forms with conditional paths, connect a single form to dozens of external apps simultaneously, add CAPTCHAs to your form, and much more.

I show how to use a few of the advanced features of Fillout on these 2 Airtable podcast episodes:

• Using Fillout to update an existing Airtable record & create an eSignature approval process with PDF file creation.
• Using Fillout to create an order entry form with line items.

Hope this helps! If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

Hey there @Weng-IC !!

Can you explain your use case a little more? I think there are definitely some easier ways than what has been proposed in this thread and ones that wouldn’t require you to write any custom code, scripts, or use Zapier/Make.

I’ve worked with forms a ton and can probably give you some pointers!

1. I will have a list or empty Main customer profile.

2) I will send survey from Typeform or Mailchimp to customer and with their responds from the survey. The main customer profile will add on to the existing field or create if the field is not there.

3) We will use email as main identifier.

We will continue to send new survey in future so this “Scripts” or “trigger” will need to work for my future survey forms.

Thank you

Alright got it working for you. No scripts needed :grinning:

STEP 1
First you are going to want to create a link to the form via a formula in your records table

That formula will need to be constructed via concatenate() and utilize the encode_url_component() formula as well. Here is my example formula I wrote:

Then when you invite your users to fill out the form, you NEED to give them the link in their record-row (which is a unique prefilled form link to them)

You can provide this via an automated email from Airtable or you can manually copy and paste that link and provide it to the correct individuals

STEP 2
Then you are going to want to write an automation that catches those new form submissions and updates the correct record. Heres my automation

Overview:

Find Records:

Update Record:

LAST THOUGHTS

I did my working example with an Airtable form (which you can do as well depending on the complexity of your actual form), but if you choose another you will have to do a few more steps. Depending on your form-provider of choice you have some different options.

For example, Jotform provides a native Airtable integration and the ability to prefill form fields just like Airtable.

Same with Typeform! Heres their native integration information → Typeform<>Airtable

Lastly, if you do choose to use Typeform or Jotform, you would just need to change your automation trigger in Airtable to be “When record is created” rather than “When form is submitted”

Hopefully that helps!