Expand my Community achievements bar.

Don’t miss the Workfront AMA: System Smarts & Strategic Starts! Ask your questions about keeping Workfront running smoothly, planning enhancements, reporting, or adoption, and get practical insights from Adobe experts.

Nested Document List to Show Approval Report

Avatar

Level 4

Hi,

 

Can anyone help me with trying to get the document approval date to show in this field please? I've added {currentVersion}.{approvalDate} but it does nothing. I'm in a project report.

 

displayname=Quote Approval Date
listdelimiter=<p>
listmethod=nested(documents).lists
type=iterate
valueexpression=IF(!ISBLANK({currentVersion}.{proofID}),IF(CONTAINS("Quote",{currentVersion}.{fileName}),{currentVersion}.{approvalDate},""),"")
valueformat=HTML
width=200

 

Thanks

Matt

1 Reply

Avatar

Level 1

It seems you’re trying to access the document approval field from the Project (parent) object, which isn’t directly available and that is the reason you're getting nothing / blank.

The easier approach is to create a Document Approval Report, where the Approval Date field is by default and you can then filter it for documents containing “Quote”.

Alternatively, you can capture this value using Fusion and store it in a custom field on the Project, so it’s visible in your Project Report.