Forum Discussion
ZachShumate
Qrew Trainee
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
3 years agoQrew Legend
Did 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
------------------------------
- ZachShumate3 years agoQrew TraineeI 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__You3 years agoQrew LegendYou 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
------------------------------ - ZachShumate3 years agoQrew TraineeI 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__You3 years agoQrew LegendDid 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
------------------------------ - ZachShumate3 years agoQrew TraineeI believe so. Screenshot attachedZach Shumate770-500-6716800 Progress Center CourtSuite 250Lawrenceville, GA 30043
- MarkShnier__You3 years agoQrew LegendCan 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
------------------------------ - LisaHohneck3 years agoQrew MemberThanks 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
------------------------------ - ZachShumate3 years agoQrew TraineeIf(
[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__You3 years agoQrew LegendI'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__You3 years agoQrew LegendZach, 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
------------------------------