- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 19, 2025 07:46 AM
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!
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 19, 2025 08:09 AM
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 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.
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 19, 2025 08:13 AM
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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 19, 2025 08:09 AM
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 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.
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 19, 2025 08:13 AM
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 19, 2025 09:20 AM
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!
