Forum Discussion

BenjaminBenjami's avatar
BenjaminBenjami
Qrew Member
8 years ago

Is it possible to customize the file name when exporting a report from a table?

Hi, When I export a report in csv format say from a Customers table, the file that gets created has the name Customers-##.csv.  I have another application which I need to upload this file onto ...
Data import and export
reports and charts
LauraShelley's avatar
LauraShelley
Qrew Member
7 years ago
Dan, unfortunately your solution above doesn't seem to work properly with .jpg files for some reason. I'm not sure if Quickbase handles photo files differently or what...

I tried it the original way you have above, which resulted in an unreadable .jpg file named myfile.jpg.

I also tried this:

var Text fileExtension = Part([Photo], 2, ".");

"<a href='" & URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/e6/v0/' download='myfile." & $fileExtension & "'>Download Photo</a>"

This resulted in a download of the original file (not renamed). I'm using Chrome.
LauraShelley's avatar
LauraShelley
Qrew Member
7 years ago
The following solution works in a URL Formula Field. Thanks for your help, Dan! Very much appreciated!

var Text url = URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/e6/v0/";
var Text fileName = "Photo.jpg";

"javascript:fetch('" & $url & "',{credentials: 'include'}).then(response => response.blob()).then(blob => {var link = document.createElement('a'); link.href = window.URL.createObjectURL(blob); link.download = '" & $fileName & "'; link.click();})"