Skip to content
How to update an Ai...
 
Notifications
Clear all

How to update an Airtable record with an array

2 Posts
2 Users
0 Reactions
5 Views
Theo_TILLIER
(@theo_tillier)
Posts: 1
New Member
Topic starter
 

What are you trying to achieve?

Hello,
I’m building a Make scenario that:

Iterates over a list of items

Calls Placid to generate an image for each item

Aggregates all resulting image URLs

Updates a single Airtable record’s Attachments field once, with the full list of URLs in one go

My goal is to avoid N separate updates that overwrite each other, and instead perform exactly one update containing the complete array of images.

Steps taken so far

Used Array aggregator with Group by = 1 to force a single group

Tried the (now-missing) “Emit once” / “Commit aggregated bundles” advanced setting

Try with commit aggregator but impossible to find

Switched to an HTTP—Patch request against the Airtable API, supplying records:[{id:,fields:{…}}]

Built auxiliary variables (allURLs, totalCount) plus a Router to fire the update only on the last iteration

Mapped both Field Name and Field ID into the JSON body

The “Update a record” action is executing successfully each time, but instead of appending each new image to the Attachments field, it completely replaces the previous file with the newest one (the operation 2 replace the operation 1).
As a result, after the scenario runs through all of my items, Airtable only contains the last image generated, rather than the full set of images.

I can give you everything you want but i need this solve (24h on it lol)

Thank you in advance

Screenshots: scenario setup, module configuration, errors

 
Posted : 10/06/2025 10:15 am
Terry_Hopper
(@terry_hopper)
Posts: 8
Active Member
 

Hi,

Welcome to the callin.io community!

Firstly, to ensure the call to Airtable only triggers once, you'll need to adjust your array aggregator settings. Set the “Source Module” to your Iterator, not the Placid module. This will cause the array aggregator to output a single array, ideally containing three items.

Next, configure the Array Aggregator to structure the data in the format Airtable requires. Do this by setting the “Target Structure Type” in the array aggregator to your Airtable attachments field and mapping the File URL and File name from your Placid module.

Then, thirdly, ensure the array is mapped correctly to the Airtable module. It should appear as follows:

NOT like this:

Please let us know how it works out! If this resolved your issue, kindly mark it as the Solution. Thank you!

Best regards, Terry.

 
Posted : 10/06/2025 2:21 pm
Share: