Trigger a csv download from a script

[persojgs]

Hello All,

I’m looking to see what my options are to create and download a csv file generated from a base, but with a very specific format.

Right now I have a script that loads records from the base, creates a stringified csv document, and then saves that string into a multiline text cell in a different table.
The issue is that in order to use that text, I have to copy and paste the contents of the cell into a text document, save as a csv, then open in Excel.

Does anyone know of a way I could directly trigger a download of the csv, or even save it as a downloadable attachment in cell instead?

Thanks!

[Bill_French]

persojgs:

Does anyone know of a way I could directly trigger a download of the csv, or even save it as a downloadable attachment in cell instead?

I think you first should read this to get started … after which, you’ll surely have more questions. :winking_face:

Export Rich Text Field as Markdown Product Suggestions

Okay - here’s a very raw script that demonstrates the process of exporting from a table into a CSV file, uploading the file to DropBox, and then using that host as the staging to upload as an attachment into a different table. It is the quick and very dirty version of a concept that almost everyone could improve with very little effort. You’ll need a Dropbox account and a Dropbox App (with app token) configured in your Dropbox account profile. This code uses a simple table of sales data and an…

[persojgs]

Thanks Bill – I just set everything up to upload into a write-only google drive folder – easy enough solution for now.

[Nora_Brown]

I'm successfully generating a CSV in a script block, and adding the result to a multi-line text field, as well as outputting it as text to the block `output`. But I'd prefer to attach it as a file, or better yet, have it download automatically. The latter doesn't seem possible right now. To attach a file you need to provide a url, but it doesn't seem to work with data/blob urls. Has anyone found a solution that doesn't involve uploading it to a 3rd party?