If I have a simple table that stores a PDF [u]in the database[/u], and I'm showing those lines on a grid... normally you drill down to the Form, then click the attachment Widget and the attachment is shown in a popup. I'd like to popup a window directly from the grid (to save a step) - lets say from a row operation button (or I could get fancy and trap a click on a grid column) If it was an image, and it was in the filesystem, I could popup a window with an html cell using and show the image like that. How can I show the PDF directly from the grid? [upl-image-preview uuid=e28a71cb-9505-42df-935f-1ecdd4ed0d48 url=https://www.awareim.com/forum/assets/files/phpbb_migrated/885_b4cf2b408d8eabc1019333720378de36 alt=Screen Shot 2021-11-22 at 11.41.26 AM.png] Without having to bring up a form and clicking in the widget: [upl-image-preview uuid=4c0a5012-53c8-4f20-b929-d4d16d9dd49e url=https://www.awareim.com/forum/assets/files/phpbb_migrated/885_3cf26a5d3417d3965c80fd287f4242c8 alt=Screen Shot 2021-11-22 at 11.42.54 AM.png]

[quote=johntalbott post_id=56787 time=1637607809 user_id=1013] To test it out, you could use an operation button that executes JavaScript with some hardcoded values. [/quote] Yes, this works quite nicely: [upl-image-preview uuid=6682df71-ee61-4287-a858-8cd7d95fd5ca url=https://www.awareim.com/forum/assets/files/phpbb_migrated/885_8595b0afdb523258a1db8b9c2ccb99c0 alt=Screen Shot 2021-11-22 at 6.09.06 PM.png] But I need to dynamically get the ID in there. Tried several things.

[SOLVED] how can i view a PDF Attachment directly from the Grid?

Jaymer

If I have a simple table that stores a PDF in the database, and I'm showing those lines on a grid...
normally you drill down to the Form, then click the attachment Widget and the attachment is shown in a popup.

I'd like to popup a window directly from the grid (to save a step) - lets say from a row operation button (or I could get fancy and trap a click on a grid column)

If it was an image, and it was in the filesystem, I could popup a window with an html cell using <img> and show the image like that.

How can I show the PDF directly from the grid?
Screen Shot 2021-11-22 at 11.41.26 AM.png

Without having to bring up a form and clicking in the widget:
Screen Shot 2021-11-22 at 11.42.54 AM.png

johntalbott

AwareApp.viewDocument might do what you are looking for.

To test it out, you could use an operation button that executes JavaScript with some hardcoded values.

AwareApp.viewDocument (BOName, BOID, BOAttributeStoringPDF)

Jaymer

johntalbott wrote
To test it out, you could use an operation button that executes JavaScript with some hardcoded values.

Yes, this works quite nicely:
Screen Shot 2021-11-22 at 6.09.06 PM.png

But I need to dynamically get the ID in there. Tried several things.

johntalbott

This should do the trick.

const id = parser.m_highlightedRow.refValue.split(":")[1];

AwareApp.viewDocument ("ReqLines", id, "ReqAttachment");

Jaymer

yep, thx!

karelh

Hey Jaymer,

We simply have a process that runs the following command.
DOWNLOAD DOCUMENT BO.DocAttr

If its a PDF it will open in the browser.

Jaymer

Thx K
Yes, thats more what I was originally thinking. I rarely (if ever) use DOWNLOAD DOCUMENT. Early on, I was thinking I'd make a report with the Document inside it, then DISPLAY DOCUMENT. Less than ideal. So I asked here thinking I was missing something obvious - which I was.

I tried it, but I like it my original way... for these reasons:
1) Even on my machine, it downloaded the file, requiring a click to open it. Would hate to hassle with a group of users and make them install the viewer plugin (or whatever settings allow it to auto display)
2) Opened in new tab - vs. Popup. I actually like the popup in this case to briefly view the PDF.

My Code (with help from John):

var theID = parser.m_highlightedRow.refValue.split(":")[1];
AwareApp.viewDocument ('ReqLines', theID , 'ReqAttachment')

--> JaymerTip Display PDF directly from Grid