Skip to main content
Question

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

  • Jan 4, 2018 9:32 PM UTC
  • 0 replies
  • 391 views

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 which requires a specific file name.

Instead of having to rename the file manually each time once its exported from QB, is there a way to have the file name automatically renamed to a custom file name (for example, from Customers-##.csv to MyCustomers.csv)?

Thanks for any help you can provide!
This topic has been closed for replies.

AviSikenporePro
Forum|alt.badge.img+1
I dont think you can do it natively, but it is definitely feasible using a workato recipe. In fact if you are using a cloud service it will upload the csv file into the specific destination as well.

SO essentially you will trigger a webhook using a button that calls a workato recipe. It creates a csv file based on the query and uploads the resulting csv file to your designated location. 

  • Qrew Corporal
  • Jan 5, 2018 11:39 PM UTC
First of all, you can do this natively and what can't be done natively can be done with script. Second of all you should endeavor to do everything you can within QuickBase before resorting to external services. I am sure Workao is a fine product but a best practice that you should keep at the top of your list st to minimize the number of external services you employ as it just creates more potential points of failure and additional cost.

You can do this with a plain old native boring formula rich text field. It is painful for me to answer with a native solution and not use script but alas some of you mistakenly think native is easier to use then script.

In the following formula I am forcing the downloaded file to have a base file name of "myfile" while preserving the original extension of the [file] file attachment field field (pdf, mpeg, etc)

var Text fileName = Part([file], 1, ".");
var Text fileExtension = Part([file], 2, ".");
"<a href='https://haversineconsulting.quickbase.com/up/bnddv44yh/g/r"; & [Record ID#] & "/f6/v0/' download='myfile." & $fileExtension & "'>Download myfile." & $fileExtension & "</a>"

See screenshot taken after clicking both hyperlinks (note file name in download area):



Notes:

(1) You will have to substitute your dbid and subdomain.

(2) My formula assumes you only have one versoin of the file attachment field

(3) You might have to play with the logic a bit to get your desired download behavior in consideration of the specific types of files you will be downloading and the desired name you want to assign.

(4) BTW, you can download any content whatsoever as a file WITHOUT having a file attachment field.

(5) This formula uses the download attribute of the <a> element to force the renaming of the file to the value specified. In some cases the MIME type (extension) may be overridden by a server sent header and there may be different behavior in the various browser (I only tested this in Chrome). If you use this formula do everyone a favor and report your success by testing your implementation in the various browser.

(6) Here is a resource to help you understand using the download attribute:

https://davidwalsh.name/download-attribute

  • Qrew Corporal
  • Apr 27, 2018 7:02 PM UTC
The script in this Pastie shows you one way of forcing a name for the downloading of a Report as CSV:

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

Below is a screenshot of manually running the script from the console. Note that the downloaded file has the name "Formulas.csv" instead of the default name "Formula_Functions_Reference.csv". When using this solution it is probably best to date and time stamp the file name so that the file will automatically have a unique name. This is because the browser will add a suffix to the file name if you have already downloaded the file.



If you need help with this solution feel free to contact me off-world using the information in my profile:

https://getsatisfaction.com/people/dandiebolt/

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.