How to display PDF in file attachment fields
File attachment fields can show the attached files in forms and reports, but only a few file types are accepted (jpeg and such). Is there a way around this so that PDF attachments can be shown eithe...
Forum Discussion
I would like QuickBase to be able to display embedded PDFs from my network. I do not know if this is possible.
Side note: Formula - URL field can open files into Chrome, e.g.: "C:\\\\Users\\wesmc\\Desktop\\"&"Empower.pdf"
Using the Magic Buttons app, I have a PDF (file attachment) displaying embedded in a form. I am trying to take it a step further by displaying a file from a hyperlink (to the file on my local network).
Left: Attachment; Right: Hyperlink
I am not sure if this is possible since the file is not actually in QuickBase. The error in the iframe looks like what you get when trying to display the PDF without checking the box "Allow open access" in the Field Properties for the file attachment.
This makes me wonder if there might be a way around this.
Any ideas about whether this is feasible would be appreciated.
Thanks!
Side note: Formula - URL field can open files into Chrome, e.g.: "C:\\\\Users\\wesmc\\Desktop\\"&"Empower.pdf"
Using the Magic Buttons app, I have a PDF (file attachment) displaying embedded in a form. I am trying to take it a step further by displaying a file from a hyperlink (to the file on my local network).
Left: Attachment; Right: Hyperlink
I am not sure if this is possible since the file is not actually in QuickBase. The error in the iframe looks like what you get when trying to display the PDF without checking the box "Allow open access" in the Field Properties for the file attachment.
This makes me wonder if there might be a way around this.
Any ideas about whether this is feasible would be appreciated.
Thanks!
Another thought I had is if it would be possible to use a rich text field to display a button that - when clicked - actually attaches a file to a record (from the established location), redirect/refresh to the record, and then display.
Basically, this would be a step between my URL field to the PDF on my network and the file attachment field that is displaying as needed.
Basically, this would be a step between my URL field to the PDF on my network and the file attachment field that is displaying as needed.
- Does anyone have the final solution here to get this to work? I was not able to find this in the magic buttons application and cannot get the formulas listed to work either.
------------------------------
Zach Shumate
------------------------------- Have you tried the solution in Magic Buttons? I seem to remember I was able to get that to work, however I couldn't use it because it only works with the file attachment field is open to everyone, and for security reasons we could not do that.
I never found another good solution for when attachment field is private.
------------------------------
Mike Tamoush
------------------------------- I couldn't seem to find the field that this is used in Magic Buttons.Zach ShumateShuma SportsE: zshumate@shumasports.comC: 770-500-6716800 Progress Center CourtSuite 250Lawrenceville, GA 30043
- MarkShnier__You
Qrew Legend
Maybe it's your lucky day. I am in a small airport waiting room with WiFi waiting for a helicopter to get me across the border into the US.
I don't think the technique is listed in the current Magic Buttons app. I think what happened is a while back Quickbase was talking about blocking the use <iframes>. There was a bit of an uproar from the community and upon further investigation they realize they did not have to be quite so draconian.
During that time Kirk Tracy removed that example from his Magic Buttons App. He may also have removed it because it relies on the goodness of Google to continue to provide this free utility.
So with the proviso that this technique relies on the good graces of Google, you can try making a formula Rich Text called [Report Link PDF Viewer formula]
If(
[Document Name] = "", "No File",
"<iframe src=\"https://docs.google.com/gview?url="&URLRoot() & "up/" & dbid() & "/a/r" &[Record ID#] & "/e99/v0" & "&embedded=true\" width=\"800\" height=\"2400\" frameborder=\"0\" target=\"_blank\"></iframe>")
// set the height and the width of the PDF preview window in the line above
//Replace 99 with the field ID of the file attachment.
Then make a report link field and configure both the left and the right matching fields to be that same report link formula field above. The viewer should be able to preview the usual kinds of documents including Excel, Word and PDF, and I believe Powerpoint.
Oh, and importantly as Mike stated, you need to set the checkbox on the file attachment field so it can be accessed without logging into Quickbase. Google needs to be able to look at your file in order to preview it. But since their motto used to be "do no evil", I'm sure your secrets are safe with them. But that is for you to judge. :)
Let us know how it goes.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
