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.
  • _anomDiebolt_'s avatar
    _anomDiebolt_
    Qrew Elite
    7 years ago
    Use this version and then spontaneously break into a celebratory cubicle dance:
    function download(url, fileName) {
      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();
        })
    } 
    var url = "https://haversineconsulting.quickbase.com/up/bm3ttgwp6/g/rb/eg/va/rythm.mp3";
    var fileName = "Kryptonite.mp3";
    download(url, fileName);

    You can test this by navigating to the Pastie Database and pasting the code into the console.

    Pastie Database
    https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=691


  • _anomDiebolt_'s avatar
    _anomDiebolt_
    Qrew Elite
    7 years ago
    BTW, the reason the download attribute does not work is because QuickBase sets the Content-Disposition header which has a higher priority in naming the file.


  • LauraShelley's avatar
    LauraShelley
    Qrew Member
    7 years ago
    Thank you, but I'm trying to use a Rich Text Formula field to create a download link, as you had indicated in your first response to the original question, so I don't think I can incorporate javascript in this case. Is there any way to rename a .jpg file for download using a Rich Text Formula field?
  • 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();})"
  • _anomDiebolt_'s avatar
    _anomDiebolt_
    Qrew Elite
    7 years ago
    So simple:
    "<a href=# class='Vibrant Success' onclick=\"fetch('" & [url] & "',{credentials:'include'}).then(response=>response.blob()).then(blob=>{var link= document.createElement('a');link.href=window.URL.createObjectURL(blob);link.download='Kryptonite.mp3';link.click();})\">Download</a>"
    This is a Rich Text Formula field that uses the field [url] and a hard-coded file name of Kryptonite.mp3. 

    It looks like this on my test page:


  • _anomDiebolt_'s avatar
    _anomDiebolt_
    Qrew Elite
    7 years ago
    I rarely use the javascript protocol in a URL formula field because you can't style it as a button. If you are careful you can modify my formula to make the literal string "Kryptonite.mp3" a parameter in the same way you did with the formula variable Text fileName.
  • LauraShelley's avatar
    LauraShelley
    Qrew Member
    7 years ago
    Ah, that makes sense. Thanks again!