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