Skip to main content
Solved

Update record based on form

B
  • BEASK
  • New Participant
  • 1 reply

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!

 

 

 

Best answer by ScottWorld

@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 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 

View original
Did this topic help you find an answer to your question?

3 replies

ScottWorld
Forum|alt.badge.img+20
  • ScottWorld
  • Brainy
  • 8711 replies
  • Answer
  • February 19, 2025

@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 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 

Scott Rose, Expert Airtable Consultant at ScottWorld.com
B
1 person likes this
  • B
    BEASK
Mike_AutomaticN

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

B
1 person likes this
  • B
    BEASK
B
  • BEASK
  • Author
  • New Participant
  • 1 reply
  • February 19, 2025

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!

ScottWorld
Mike_AutomaticN
2 people like this
  • ScottWorld
    ScottWorld
  • Mike_AutomaticN
    Mike_AutomaticN

Reply


Most helpful members this week

Terms & Conditions