Exporting Attachments
Hello, Is there anyway to export a report/table with attachments? When I export a report with an attachments field type, it exports the file name. Is there anyway to export the report so that I can...
Forum Discussion
While you can't export the attachments in this way, you CAN instead include a link to the attachment that would give you the ability to download the attachment from Quick Base. You will need to create a new Formula-URL field and use this as the basis for the formula:
"<a href=\"" & URLRoot() & "up/" & DBid() & "/a/r" & [Record ID#] & "/e16/v0\">" & [File Attachment Field Name] & "</a>"
Replace the 16 with the FID for the File Attachment field and then replace the 'File Attachment Field Name' with the File Attachment Field. Add this to your report and you will then have a link back to the file.
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
"<a href=\"" & URLRoot() & "up/" & DBid() & "/a/r" & [Record ID#] & "/e16/v0\">" & [File Attachment Field Name] & "</a>"
Replace the 16 with the FID for the File Attachment field and then replace the 'File Attachment Field Name' with the File Attachment Field. Add this to your report and you will then have a link back to the file.
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
Hi Thanks so much!
The formula work when in the report (shows the link starting with http) but when I download the report it displays the full formula: <a href="https://directv-9861.quickbase.com/up/bqtpc4828/a/r18/e6/v0">example.docx</a>
Do you know why it is doing this?
------------------------------
Thanks in advance,
Jennifer Paschal
------------------------------
The formula work when in the report (shows the link starting with http) but when I download the report it displays the full formula: <a href="https://directv-9861.quickbase.com/up/bqtpc4828/a/r18/e6/v0">example.docx</a>
Do you know why it is doing this?
------------------------------
Thanks in advance,
Jennifer Paschal
------------------------------
- MarkShnier__You
Qrew Legend
I seem to recall that I did this once and had to have the excel sheet use the =hyperlink function.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- Is there anyway to make it perform as a link on download? So that the user does not have to change anything in the Excel, for best user experience.
------------------------------
Thanks in advance,
Jennifer Paschal
------------------------------- Since it downloads as a CSV, I don't know that you're going to completely get away from the user having to do some type of formatting, but you can get around the issue of the formula in the download. You'll want to create a 2nd field for the URL, but this one will just be a plain text field. Then, you'll want to create an Automation that runs when the record is created. This automation will just need to copy the value of the URL formula field over to the new Text field. You can then use the Text field in the download and it should have no associated code in it.
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
