Is this possible?
Topics help categorize Community content and increase your ability to discover relevant content.
Hey Sam, I had people check and it looks like this might not be possible, but I know there are some text mode wizards out there that might be aware of some kind of fancy work around.
Kyna
Thanks @Kyna Baker - inactive‚!
Views
Replies
Total Likes
I'd kind of like to hear more about the use -- what is the report trying to do, and why can't we use the proof thumbnail instead of the document version thumbnail? And is it possible to get close with a document report calling out proof details?
Views
Replies
Total Likes
@Skye Hansen‚ It's specifically a proof approval report which we can't get close to with a document report (Unless you know how to filter document reports down to this). I need to display all the proofs a specific user is currently the pending approver on.
They want to see the thumbnails because it gives them a quick way to identify what something is. A proof thumbnail would be great! Support gave me the text mode for it:
displayname=Preview
image.valuefield=documentVersion:document:previewURL
textmode=true
type=image
valuefield=documentVersion:document:previewURL
valueformat=HTML
But if proofs are PDFs then it won't generate a thumbnail. Most of our proofs are PDFs 😒
Views
Replies
Total Likes
haha I'm not sure I understood all of that post. Also we still don't use Proof Approvals in our environment. But here's my question anyway.
Can you do a document report, and use the Large Thumbnail field on the view, and put this in the filter?
EXISTS:a:$$OBJCODE=PRFAPL
EXISTS:a:approverID=$$USER.ID (or if there really is a specific ID put it here)
EXISTS:a:approverID_Mod=eq
EXISTS:a:documentVersionID=FIELD:currentVersionID
EXISTS:a:isAwaitingDecision=true
EXISTS:a:isAwaitingDecision_Mod=eq
Mainly I want to see if that generates the same number of lines as a proof approval report that filters on approverID=$$USER.ID and Awaiting Decision=true. It does for me, but we have like.... 23 outstanding proof approvals to experiment with (most of which were probably mistakenly entered).
And my Large Thumbnail column shows a thumbnail for a PDF (I read that you said yours does not, but I don't know which report you're on and I didn't bother using your textmode since the canned field works for me).
Views
Replies
Total Likes
Uhhh. Wow. That worked.
If only I understood EXISTS filters 😂
The large thumbnail worked! It wasn't available as a canned field on a proof approval report and the substitute that support gave me would only generate thumbnails for PNGs and JPGs. Here's another question for you though - all of the sudden my text mode for generating a link directly to the proof doesn't work.
displayname=Proof Link
shortview=true
textmode=true
usewidths=true
valueexpression=CONCAT("https://melaleuca.my.workfront.com/document/",{documentVersion}.{ID},"/proof/",{documentVersion}.{proofID},"/view")
valueformat=HTML
width=200
Can I get your thoughts O great and powerful Workfront Wizard?
Views
Replies
Total Likes
OK long story, but I promise this is kind of related and I can't avoid telling the story because we're still in Classic and as I mentioned, not using Proofs. So I am zero help to anyone using Proofs in NWE.
About your comment about understanding Exists filters -- So my goal for the year is to hammer EXISTS into someone else's head. With that in mind, I'll let you know I'm not good at them either, and I carry the following around with me at all times and amend it as necessary. (I got it from wf-pro.com)
In the project report you are making, show projects that:
4a. EXISTS:a:name_Mod=eq
(I am good at projects and tasks and that's about it, so this is my cheat sheet that I use to translate with.) With that, I got:
In a docu report, show docu's that:
Back to your question: all of the sudden your text mode for generating a link directly to the proof doesn't work. Not surprising, since you're in a whole other type of report.
Pointing at the obvious: the "documentVersion" part is from your proof approval report -- and you know this, because it's on the API listing for proof approval and we already know it's not in the document API listing. We also learned that the currentVersionID was a direct equivalent, when we did our exists statement, so at the very least, we need to make that switch.
So I would probably try that first. It begs the question -- is this ALL we need to change? Fingers crossed... I would love to hear if just this one switch works.
Views
Replies
Total Likes
Hi @Samantha Isin‚
Looking for some other ideas of how to extend the proof approvals report and came across this request. Great solution by Skye..as always. From the Proof Approval Report that comes out of the box...you can also just add:
displayname=Image
image.valuefield=documentVersion:document:previewURL
textmode=true
type=image
valuefield=documentVersion:document:previewURL
valueformat=HTML
And that should add the image.
Cheers!
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies
Views
Likes
Replies