Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Oct 11, 2020 11:40 AM
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!
Oct 11, 2020 01:09 PM
I think you first should read this to get started … after which, you’ll surely have more questions. :winking_face:
Oct 11, 2020 01:18 PM
Thanks Bill – I just set everything up to upload into a write-only google drive folder – easy enough solution for now.
Jan 10, 2023 03:18 PM
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?