Skip to main content

Hello,


So we have a “Survey Results” table that… wait for it… collects our “Survey Results”. It basically runs off an automation. The 'initial trigger is a checkmark in another table. When you tick the checkbox, the “Survey Results” table starts a new row by adding two items - a four-digit RO# and the subs email.



Jotform then takes that information, and adds it to a form and sends it out. It then returns the results back to the “Survey Results” table… BUT IN A NEW ROW!



This doesn’t seem that hard to figure out, but it sure has stumped me!


Please advise, thanks

DG

2025 Update:

  1. JotForm will always add a new record to your Airtable database, unless you use Make’s JotForm integrations to update your existing records in Airtable.

    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.
  1. However, if you’d like to update existing reocrds from a form, your easiest & best solution for this is to use Fillout’s advanced forms for Airtable.

    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, display Airtable lookup fields on forms, control access to a form via SSO or email domains, perform math or other live calculations on your forms, accept payments on forms, collect signatures on a form, create multi-page forms with conditional paths, create new linked records on a form, and much more.

    You can see how to set this up in my video below, which also shows off many other advanced techniques using Fillout: Using Fillout to create an eSignature approval process with PDF file creation.

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

WOW ScottWorld,


That’s a lot of… good but disappointing information there. Thank you? lol


Just kidding.




  1. I know little to nothing about “scripting”, so this one is out




  2. Very interesting options here, and NO dupes! I promise




  3. No need to worry @Hannah_Wiginton, I read that thread and already checked them out. No free version!?! lol




  4. Already used “MiniExtensions.com” on another table, and the (you guessed it) free version of Airtable only lets us use one. (free is killin’ me!)




  5. Now THIS is the money shot!!! I like where you are going with this one. BUT, what if I collected the 'Form" data in a JOTFORM TABLE? Then, as you said, use MAKE (I use zapier (4-free!] and automate.io talso 4-free!]) to move the data ‘back’ into it’s original ‘Airtable’ table!?!




Thanks again!


DG

2025 Update:

Yes, Make has a free plan.

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.

However, your best bet is to use Fillout’s advanced forms for Airtable, which lets you natively update Airtable records from a form.

- ScottWorld, Expert Airtable Consultant

 

Yes, Make is also free! And it’s way more powerful than Zapier. I have never used Automate.


No, I agree! But I’ve only used MAKE once (as I just ran across it the other day)


Automate.io (https://automate.io/) is like zap, a drag-&-drop program.

So, did anyone have anything further to add to our “JOTFORM TABLE?” idea???


:cowboy_hat_face:

SOLVED!!!


Jotform found the automation within zapier!



Thanks EVERYONE for the help!

SOLVED!!!


Jotform found the automation within zapier!



Thanks EVERYONE for the help!


Right, as I previously wrote above, Make and Zapier both do this. But Make is less expensive & significantly more powerful than Zapier. But if you like Zapier, go for it!!

No, no, no… I’m trying it on ‘MAKE’ now.


I’m getting stuck here:



Any chance you could help me figure this out? It’s literally the LAST step in this painstaking task that I took on through no choice of my own!?!


(sorry - had to vent for a sec. lol)

No, no, no… I’m trying it on ‘MAKE’ now.

I’m getting stuck here:

14902i5C83982E6041620D.png

Any chance you could help me figure this out? It’s literally the LAST step in this painstaking task that I took on through no choice of my own!?!

(sorry - had to vent for a sec. lol)

 

As I outlined above in my previous post, you would need 3 modules in Make:

 

Your 1st module would be a JotForm module (to receive the form submission), your 2nd module would be an Airtable Search module (to search for the matching record in Airtable), and then your 3rd module would be an Airtable Update Record module (to update the record in Airtable). You can also use the Upsert module to either create a new record or update a record, depending on whether it already exists or not.

Hope this helps!

If you have a budget and you’d like to hire the best Airtable consultant to help you with this or anything else that is Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

Glad you figured something out!

Yes On2Air Forms can make this happen. We have a Free plan to get started, then other plan options if you need more forms and form submissions. We have a Starter plan for $10/month.

Reply


Terms & Conditions