Skip to main content

I am attempting to use a form to update a record in the existing table.

So an account executive fills out a form with the new terms and rate amounts for 2025 2026 and 2027

I tried coping a workflow shared by a community member (https://community.airtable.com/t5/other-questions/updating-existing-records-problem/td-p/187594) where they made a new table from the form and then updated the old table but that isn't working for me.  I think it was from Consultant @ The Time Saving Co

Before that I was bypassing the second table and that did not work either. Does anyone have a workflow similar to what I'm looking for they could share a screen shot of:

Here is how far I got:

 

 

Thanks!

 

 

 

@BEASK 

It’s possible that your “find records” action returned more than one record, which means that you are sending more than one Record ID to the “update record” step.

You can only send one Record ID at a time to the “update record” action, so you’ll need to add a repeating group to loop through the found records, which would enable you to only send one record ID at a time to the “update record” action.

If you’re certain that your “find records” action only found one record, make sure you’re putting the list of record ID’s in the area where it asks for Record ID. (You didn’t show this part of your “update record” action in your screenshots above.)

However, there is a much easier & much better way to do all of this, which doesn’t require any automations at all, and also doesn’t require you to keep changing the prefill URL (if you’re using prefilled URLs).

You can simply use Fillout’s advanced forms for Airtable, which is 100% free and allows you to update Airtable records directly from a form. No automations necessary and no complicated prefilled URL’s. Fillout also offers hundreds of extra features that Airtable’s native forms don’t offer.

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, display Airtable lookup fields on forms, create new linked records on a form, control access to a form via SSO or email domains or a list of email addresses stored in Airtable, 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:

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 @BEASK! I might be missing some context on your business/workflow. But wouldn't it be easier to get the updates done via a Fillout "update record" form? They do have direct integration with Airtable.

 Mike, Consultant @ Automatic Nation

I bet you are right! In a lot of tests and cases it is more than one record. I am very excited to look at the fillout update record form. Thanks so much for both of your help!

Terms & ConditionsAccessibility statement