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