Mass download files in a ZIP

Hi there

I am loving the ability to upload files to Coda - it has opened up a lot of new use cases, and removed the awkwardness of previous solutions that involved linking to files stored in other services.

However, I am already encountering quite a few scenarios where I have a large-ish table with a file attachment for each row, and I find myself needing to mass-download either all the files, or the files from a particular filtered selection of rows. There doesn’t seem to be any way to do this at the moment, aside from manually clicking each file attachment cell for each row (and that takes three clicks: one to open the preview screen, another to hit the download button, and another to close the preview screen).

It would be very useful if there was a Download() function that would accept a list of files stored in Coda, and download them as a ZIP. For example, Download( [TableName].filter( LastModified > now()-days(2) ).FileAttachment ) would give me all the files from the ‘FileAttachment’ column for rows where the date/time in the ‘LastModified’ column is no older than 2 days prior to the current time.

Anyone else think they would need this?

Cheers
Tim

1 Like

Cool idea.

You have to keep in mind that Coda either stores these files in a cloud provider (AWS, Azure) or has a CDN, both of which are metered. Having the ability to programmatically download files is costly, as this functionality can now be triggered by automations or formulas much faster than the user would be able to, and without getting tired. It’s also risky, if some formula or automation causes the files to be downloaded multiple times in rapid succession it could strain the CDN and incur fees. It would require a mechanism to rate limit download requests.

Good point - I had not thought of that. A throttle on the download rate would be fine with me, as would a confirmation pop-up along the lines of “You’re about to download a ZIP of 100MB. Are you sure you want to go ahead?”.

1 Like