How to display PDF in file attachment fields

We need the same thing. It would be awesome if there were a way to preview the file instead of downloading upon clicking, much like in gmail? Any way to do this?

Hi Berry & Matt,
I've not heard of this being possible natively however it would be really useful, would suggest you add it as a feedback item and vote it up, the Quickbase team are always looking for good ideas to enhance Quickbase and add functionality. In case your unfamiliar with the feedback button you can find it on the My Apps page its an orange table half way down on the left. If you let me know when you have put it up ill add some votes to it myself as its something I too would like added.
Regards
Jack

We have an invoice management application in Quickbase where all the 3rd party invoices are stored as PDF files in Amazon S3 and this application is integrated with S3. In the application we created a button which contains a link to the S3 document. Clicking this button will open the document in a separate window.

Well, we had that using dropbox but it was a nuisance, especially when dropbox got issues with their shared links recently.  The new Quickbase rates for storage are competitive and we want to move everything in quickbase now, just need a way to see the document like you see JPEG files and such.  Am not keen for any third party stuff.

I was able to accomplish this with the Image Onload Technique:
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=320&rl=psr

Create a Formula - Text Field named Attachment Viewer (separate from the Image Onload field) in the desired table. Be sure to check the box allowing HTML and insert the following:

var text URL =
  "https://docs.google.com/gview?url="; &
  URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/eFID/v0&embedded=True";
"<embed src=\"" & $URL & "\" height=\"650\" width=\"900\">"

Replace FID with the field # of your attachment field.



In the module.js page under the desired headings (Edit Record/Display Record) paste the following:

$("#tdf_22").html($("#tdf_22").text().replace(/{{/g,"<").replace(/}}/g,">"));


Where I have 22 you'll need to adjust this # to be the placement of the Attachment Viewer in your form. Start with testing the # to the left of the field in the form builder and decrease from there if necessary. 
Ex: In my case it's the 23rd object on the form, and I need to use 22 in the script page.

I've attached a picture of the final result.

Hi,

so I've tried this but can't get the PDF to display.
Got the JS Field & page:

(function(){
$("#tdf_26").html($("#tdf_26").text().replace(/{{/g,"<").replace(/}}/g,">"));
$("#tdf_27").html($("#tdf_27").text().replace(/{{/g,"<").replace(/}}/g,">"));
})();

Got the field to display

var text URL = "https://docs.google.com/gview?url="; & URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/e30/v0&embedded=True";
//"<embed src=\"" & $URL & "\" height=\"650\" width=\"900\">"
"<iframe src=\"" & $URL & "\" height=\"650\" width=\"900\">"

But get this error:



Help?!

Did you find a fix for this error ? I have it too

I suggest you put in a suggestion over at the UserVoice ghetto and wait a few years to realize that this feature will not be added to the product. Then use script as suggested by Ryan above. If you have an issue using script ask a new question with exactly what problem you are encountering. Script solves all QuickBase problems.

Hi Dan,
I used the script as per Ryan's suggestion and I have the same error as Carlos. Instead to show the pdf , it shows the html of the page in pdf format :).

something curious, for an image I use the same formula(without google docs) and instead an iframe tag I use an image tag and it is working.
It seems the url  ....../a/r1/e21/v0 it works for images but not for the pdf. It not gets the pdf file but the html page.

Any sugestion ?
Regards,
Mihai

I'm getting a syntax error when trying to save the rich text formula field. Any thoughts?

Formula syntax error

A formula cannot end with an assignment to a variable declaration.


var text URL = 
  "https://docs.google.com/gview?url=";   & 
  URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/e269/v0&embedded=True";
"<embed src=\"" & $URL & "\" height=\"200\" width=\"193\">"