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
Thank you for hunting this down for me.
"<iframe src=\"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>"
in that field.
I also tried to just do this as a URL field and use the native quickbase ability to display in iframe. This did not display anything on the screen for some reason. The closest solution I have thus far is leaving it as a URL formula, displaying that URL as a button, and clicking that button to have it displayed in another tab. This does help avoid downloading the file every time but does not allow it to display directly on the form as needed.
Thanks,
Zach Shumate
770-500-6716
800 Progress Center Court
Suite 250
Lawrenceville, GA 30043
MarkShnier__You
Qrew Legend
Qrew LegendDid you create the report link field that I ask led you to create? Or did you skip that step.
------------------------------
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
------------------------------
- I am not sure I follow what you mean by "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"This is the formula I have in the Rich text field. Which I have labeled [PDF Viewer].If(
[Proof] = "", "No File",
"<iframe src=\"docs.google.com/gview?url="&URLRoot() & "up/" & Dbid() & "/a/r" &[Record ID#] & "/e6/v0" & "&embedded=true\" width=\"800\" height=\"2400\" frameborder=\"0\" target=\"_blank\"></iframe>")The file is located in FID 6. The name of that field is [Proof].Thanks,Zach Shumate770-500-6716800 Progress Center CourtSuite 250Lawrenceville, GA 30043 - MarkShnier__YouYou need to create a second field of type report link, configure it like I said and then put the Report Link field on the form.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------ - I see. It appears to be showing the iframe now but it is not recognizing the link. Screenshot attached.Thanks,Zach Shumate770-500-6716800 Progress Center CourtSuite 250Lawrenceville, GA 30043
- MarkShnier__YouDid you check the checkbox on the file attachment field as I said?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------ - I believe so. Screenshot attachedZach Shumate770-500-6716800 Progress Center CourtSuite 250Lawrenceville, GA 30043
- MarkShnier__YouCan you copy and paste your formula field?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------ - Thanks a lot for the suggestions.
I am using a similar combination of the iframe tag and google viewer which is displaying well, but I am getting the "This field includes unsupported content" warning pop up which seems to be caused by the iframe tag.
I get exactly the same warning pop up when using the suggested formula
If(
[Proof] = "", "No File",
"<iframe src=\"docs.google.com/gview?url="&URLRoot() & "up/" & Dbid() & "/a/r" &[Record ID#] & "/e6/v0" & "&embedded=true\" width=\"800\" height=\"2400\" frameborder=\"0\" target=\"_blank\"></iframe>")
Is there any communication that this will work after the August 21 release?
------------------------------
Lisa Hohneck
------------------------------ - If(
[Proof] = "", "No File",
"<iframe src=\"docs.google.com/gview?url="&URLRoot() & "up/" & Dbid() & "/a/r" &[Record ID#] & "/e6/v0" & "&embedded=true\" width=\"800\" height=\"2400\" frameborder=\"0\" target=\"_blank\"></iframe>")
------------------------------
Zach Shumate
------------------------------ - MarkShnier__YouI'm hopeful that is a false warning. Initially they plan to block all I frames and then they backed off from that I believe. It would be good for one of us to put in a support ticket and ask for an official answer.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------ - MarkShnier__YouZach, is your file attachment field ID #6?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------ - MarkShnier__YouLisa the April Release Notes say this
Embed a secure, external website as an iframe on a form. This provides builders a way to embed YouTube videos or other file services (Box, Drive, etc.) as a file preview. For security purposes, the only *.quickbase.com URLs that are supported are for code pages. All other native pages (*.quickbase.com URLs) do not function when embedded on a Quickbase form.
I interpret this that it will continue to work after August 21st and that the pop up is a false warning. The concern over iframes had something to do with security but I think they determined that it was only a security risk if you embed Quickbase pages within Quickbase pages.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------ - Hi Marc,
it says external website. This works well, I was able to do it. But displaying a PDF which is saved as file attachment in quickbase is a native quickbase page.
I have double checked with support and got this answer when I specifically asked for code with iframe tags in a formula field and the August 21 release:
I did some more digging and iframes are indeed no longer going to be supported on old forms. That being said, any existing ones in your app won't be deliberately disabled. I was reading that we already have a secure example of embedding PDF previews in the new dashboards, and that our product team is working on a similar secure solution for the upcoming new forms. It appears the only option at this point would be to move this to a code page [...].
------------------------------
Lisa Hohneck
------------------------------ - MarkShnier__YouThx for checking with support on this.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
