Add a new attachment to Airtable without deleting existing ones

I am using Make for my workflow. My goal is:

  1. Receive a Jotform submission.
  2. Convert it to a PDF.
  3. Add this PDF to an Airtable record.

I have already built the scenario (see the screenshot). It works, but I have one problem:
When I add a new file to the Airtable attachment field, it overwrites (deletes) the old files. I want to keep the old files and just add the new.
How can I tell Make to “append” the new file instead of replacing everything?

Thanks for your help!

Hi @Victor_Shutov This is a common issue with Airtable in Make. The trick is to first fetch the existing attachments from the record before updating it, then merge the old attachments array with the new file and pass them all together in the update step. That way Airtable sees all files at once instead of replacing them.

Hi @wisdomdavid ,

Thanks for your reply !

I actually tried using the Array Aggregator to collect the files, but I’m struggling with the final step. I don’t know how to correctly map the output of the aggregator into the “Update a Record” module in Airtable.

Hey Vitor,

you toggle the map option next to the array field, not the one that appears when you click +Add item

Hi,

I think the issue is with my Array Aggregator settings or the way i’m passing the data to the Airtable module. I am trying to collect the URLs of the files, but the output doesn’t seem to match what Airtable expects.

Try changing the targeted structure and see if there is one available for airtable. And if its not, switch to aggregate to JSON module and build the array in a way that airtable expects it.

I finally found the solution !

Thanks for your help

2 Likes