Question

Keeping Airtable up-to-date

  • 28 July 2021
  • 5 replies
  • 14 views

This seems like it would be a simple task, but I can’t logic how to make it work.

We use Google Forms for  a program sign-up. That goes to Sheets, and we have a zap that takes the info from Sheets and creates a record in AirTable.  Works great.

But now I want our participants to be able to update some of their info. It seems like this could be done via an AirTable form.  But - we don’t want it to create a new record - as we have lots of notes fields now attached to their original record.  

Do we create a Zap back to Sheets? It appears AirTable doesn’t have this functionality (to update a record) within their own platform, and they suggest a multi-step Zap. But that info doesn’t translate to what I’m trying to do.

Is there a simple solution to this??


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

5 replies

Userlevel 7
Badge +10

Hi@TTeens!

I had a detailed explanation ready to go, including screenshots and instructions, but there was an issue submitting it and I lost it all. So instead I’ve created a share link to the demo base I created. 

And here’s the automation I created in Airtable (you can do the same thing in Zapier but for simplicity’s sake I used the built-in automations):

It’s not a terribly elegant solution but it would work. You would have to send the person their record ID when the record is created in Airtable (you could create a Zap to send that out). 

NOTE: If you need them to overwrite the notes then you can do away with the Notes table and instead, just update the record itself with the new note. That will replace what’s currently there.

Hope that helps!

Userlevel 7
Badge +12

Hi @TTeens 

Check out miniExtensions for updating Airtable records: https://miniextensions.com/

Also, On2Air: https://on2air.com/

Userlevel 7
Badge +10

Yes, and what @Troy Tessalone said. MiniExtensions is honestly the best option, in my opinion, if you’re willing to pay for an external tool. They offer ways to do what you’re looking for and soooo much more :) 

Thanks @nicksimard and @Troy Tessalone for the info. We’ll give the automation a try. We’re a group of high schoolers with a very limited budget :disappointed_relieved:  so working with low-cost/free tools right now!  

 

 

Userlevel 7
Badge +10

Hey @TTeens!

I totally get it. I try to stick with free and low-cost as much as I can too :) In some cases it will either require upgrading some apps or coming up with creative workarounds (I’ve done both hehe). Not sure how tech-savvy you are but there’s a great deal on AppSumo for this app: https://www.directual.com/. They offer a portal function and can pull in records from Airtable. It would at least just be a one-time payment and then you’d have access to the tool.