Expand my Community achievements bar.

SOLVED

Proof Approval Reporting Examples

Avatar

Community Advisor

I'm looking for some examples of reports people are using for proof approvals. What columns are you displaying, anything fun i could be adding in text mode, etc. Our users want reporting but don't do a great job elaborating on what they want to see so hoping some creatives out there have ideas. 

 

I would also like to know which type of reports people are using for proof approvals and the reasoning. They each have their own limits on functionality they can display.

  • Document
  • Document Version
  • Proof Approvals

 




1 Accepted Solution

Avatar

Correct answer by
Level 10

 

Thanks for meeting with me on this yesterday, @Kurt_Jones,

 

Hey folks! I'm pleased to announce that the Package of Kurt's Generic Proof Approvals Report is now available for anyone interest to deploy into their own Workfront domain, as follows:

 

  • Log In to AtAppStore (or Create Account if it's your first time)
  • Under My Account > Connections ensure (or set up) your Workfront domain
  • In the Packages side menu, click the Generic Proof Approvals icon
  • Click the Parameters tab then log in to your Workfront domain
  • Once connected, click the orange [Good! Lets run it!] button
  • Check the confirmation box and click the [Run Solution] button

 

With the report now deployed to your environment...

 

  • In Workfront, search for a report called Generic Proof Approvals and open it
  • Click Report Actions > Edit Report
  • Click the Link to Proof Column, then edit its textmode
  • Replace yourdomain.my.workfront.com with your Workfront domain
  • Save the report, run it to confirm it's working, share as needed, and enjoy!

Regards,

Doug (and Kurt -- thanks again!)

 

Doug_Den_Hoed__AtAppStore_0-1680282128558.png

 

View solution in original post

44 Replies

Avatar

Community Advisor

Proof.png

 

This is one we just created as we start to use Proof, there is some textmode with it.  Happy to share how its made.

Avatar

Community Advisor

I like this! Which type of report did you use to build this? I would love more on how it was built especially text mode components. 




Avatar

Level 5

This looks great, I'd be interested in the text mode as well.

Avatar

Level 3

Hi Kurt,

 

Can I get the info to make this? 

 

Also, is there a way to pull a proof report to just see proofs, where I am the reviewer? 

Avatar

Community Advisor

Sbhuta,

Follow the instructions in the green accepted answer box above that Doug outlined, that process will help install the report into your Workfront domain so you have it.  If you have trouble with that then send me an email and I'll send a doc of instruction.

The report I provided above was for a use-case for folks that needed to see proofs across their system in various stages to be able to monitor and wanted to see a visual of the proof.  In this case, a document version report allows the thumbnail field (proof report not so much). The report also has a lot of textmode.

I cant think of a way to filter proofs by the reviewer, the reporting folks on the approver and approval stages within the API.

Avatar

Level 1

This looks like exactly what I need! Are you still willing and able to share how it is made?

Avatar

Level 4

I know this is several months old, but I would also love to see the text mode behind this Proofing Report. Can I shoot you an email?

Avatar

Level 2

hey ,

 

can you tell me which filter should you use to make this report?

Avatar

Level 1

This looks great. Are you able to share the text mode for pulling in the document thumbnail? I have tried to replicate this column and am struggling with it. Please let me know. I can email you if that is preferred.
Thanks!

Avatar

Level 4

You kindly shared the text mode with me - thank you! I love the column "Approvers and Dates."

I'm trying to implement that same idea in an existing Proof Approvals report rather than Document Version report (like yours), but I am not getting it to work.

 

Do you know if it's possible to list the approvers and dates in that type of report? Hoping I'm just overlooking something simple.

Thanks, Cathy

 

Nice report, Kurt!

 

Given the continuing interest from other folks, if you'd like to wrap it into a deployable Package so others can easily install it (as we've done with the DRA@WF Cleanup Dashboard, Workfront Cleanup Dashboard, User Initials, etc.), I'd be happy do do so with you sometime.

 

Regards,

Doug

Avatar

Community Advisor

Hi Doug,

Happy to work within your schedule over the next few weeks when you have time and we can do it.  Hopefully you still have my email for our earlier work, send invite and we'll go from there.  Thanks for the offer.

Avatar

Level 2

Can any one suggest me which filter i can use for show only open projects proofs in this report?

Avatar

Community Advisor

Arnab, there isn't a way (that I'm aware of) or the ability in the Workfront API to connect project status within a Document Version or Proof Approval report type.  There are no available collection or reference fields to help make a relevant connection to the project status field...its simply a limitation of the reporting.  For my report and the Proof Approval report those report types are built to focus on the document/proof and its stages.

Avatar

Level 1

Hi Arnab,

I ran across the following text mode code in another post that will allow for filtering a proof approval report by projects in current status. Hopefully this helps.

 

EXISTS:a:$$OBJCODE=DOCU
EXISTS:a:project:status=CUR
EXISTS:a:project:status_Mod=in
EXISTS:a:versions:ID=FIELD:documentVersionID

 

Avatar

Level 2

i used this filter its not working on my report, can you send me your report and filters screenshot on arnab.laha2018@gmail.com mail id?

Avatar

Level 2

now i am trying to add a new tab called project status in document type report where i need to show only current and onhold project proofs in my report , can you guide me which filter and column i need to use?

Avatar

Community Advisor

Arnab, based on update from Frank322 above, you should be able to change the filter in my report I provided you to look like the below:

EXISTS:1:$$OBJCODE=DOCU
EXISTS:1:ID=FIELD:documentID
EXISTS:1:project:status=CUR OHN
EXISTS:1:project:status_Mod=in
isCurrentVersion=true
isCurrentVersion_Mod=eq
proofedByUserID_Mod=notblank

 

My report is a Document Version report and it did work for me in my testing and should show proofs on projects that are still current.  As Frank322 noted, what he provided above works on a Proof Approval report as well.