Exporting Attachments

Question

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 access the attachments from the export?------------------------------Thanks in advance,Jennifer Paschal------------------------------

blakeharrison · Answer

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/
------------------------------

jenniferpaschal · Answer

Hi Thanks so much!&nbsp;The formula work when in the report (shows the link starting with http) but when I download the report it displays the full formula: &lt;a href="https://directv-9861.quickbase.com/up/bqtpc4828/a/r18/e6/v0"&gt;example.docx&lt;/a&gt;Do you know why it is doing this?------------------------------Thanks in advance,Jennifer Paschal------------------------------

markshnier__you · Answer

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
------------------------------

jenniferpaschal · Answer

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------------------------------

blakeharrison · Answer

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 Harrisonbharrison@datablender.ioDataBlender - Quick Base Solution ProviderAtlanta GA404.800.1702 / http://datablender.io/------------------------------

Forum Discussion

Exporting Attachments

Related Content

Attachment - file name

Notification with attachment

PDF Document Generator, automatically attached to a record

Export QuickBase table to Sharepoint csv file

IF Statement based on a file being attached