Create a zipped document of all airtable attachments within a table

Questions
,
1

Hi,

I have an Airtable table which has a name, location and attachment. The attachments change over time and I would like to build a bulk download option for my interface for people to obtain a copy of all of the latest files for printing.

I have setup a custom webhook trigger button in airtable.

This runs a search records > Get a file - HTTP > Array aggreator > Create Archive > OneDrive - upload file.

The problem I have is that multiple zipped files are being uploaded to onedrive each containing an attachment. Instead of a single zipped file with all of the files within it.

Can anyone help me please? When testing 10 records, every step is outputting 10.

3

Hello,

Create Archive works as an array aggregator.

All you have to do is delete the Array Aggregator and map the Create Archive module to Airtable’s Search Records.

simplymation_map_airtable
simplymation_map_airtable764×664 37.3 KB

simplymation_archive_airtable_scenario
simplymation_archive_airtable_scenario1044×423 27.3 KB

Take a look on example scenario here:

One day ago there was a similar post- there is a lot of valuable knowledge there: Create archive from Firestore images

4

You are simply the best! Worked 1st time :clap:t3: :clap:t3: :clap:t3: Thank you very much for taking the time to help me.

1 Like
5

@mszymkowiak do you happen to know how to extract only the latest file versions? My Airtable attachment field has file versioning switched on, but it is taking the original file, not the latest version. I have played around with filtering and am now getting all the versions. I just cant seem to filter just the latest version.

6

Airtable does support revision history, but full file versioning is only available on the Business and Enterprise plans (if I remember correctly).

If you need file versioning on lower Airtable plans, you can replicate it by using two tables.

Create a separate table dedicated to file versions, where each record represents one version of a file. Then add a linked record field that connects these version records back to your main table. Each time a new file is uploaded, simply create a new version record in the versions table and link it to the appropriate main record.
This gives you a clean, controlled version history without relying on Airtable’s native file versioning.