Showing a Task Custom Form value in a Project Report column

[JasonLe2]

Hi Jason, Congrats on getting that going with Narayan. Your use of the phrase "giving my stakeholders a clearer picture of what's going on" reminded me of "https://community.workfront.com/discussions/community-home/digestviewer/viewthread?MessageKey=316d7273-fb57-49fe-8478-74233e456cfb&CommunityKey=aaafaff0-5e4e-4e38-8903-f1f990935567&tab=digestviewer#bm316d7273-fb57-49fe-8478-74233e456cfb" The 2nd Coolest Textmode Column I Invented This Week (from Mar, 2017 mind you), which I invite you to review, steal, and adapt as you see fit! Regards, Doug Doug Den Hoed - AtAppStore

[NRYNR]

Hi Jason, What you're describing is "https://wf-pro.com/how-to/how-to-add-a-collection-to-a-view/"> How to Add a Collection to a View . I'd recommend following the tutorial so you understand what's going on. After that, you can try some example, such as the ""https://wf-pro.com/textmode/text-mode-views-collections/#tasks-and-assigned-to">Assigned Tasks " example. Narayan

[JasonLe2]

Hi Narayan, Thanks for the quick reply, I'm looking through the API Explorer and I can't seem to find what I need. I want to return a value from a custom field on a custom form that is a Task form, to be displayed in a Project report. I'm using TASK as my (OBJECT), but when looking for {FIELD}, I'm not seeing how I can get to a particular custom form, and then a custom field on that form. Does that make sense? Thanks again! Jason Lego Stanley Black & Decker, Inc.

[NRYNR]

Hi Jason, My text mode example had an error, so that's probably why things didn't work out. Here's the text mode for grabbing a custom field value from tasks using a collection. valueexpression={DE: Your Field Name } listdelimiter=

listmethod=nested(tasks).lists valueformat=HTML displayname=Task Name textmode=true type=iterate shortview=true You can do a ton with the value expression as seen in "https://wf-pro.com/textmode/text-mode-views-collections/" this section of the WFPro text mode site . Some examples are: Show the task name: valueexpression={name} Show a task name and custom field value: valueexpression=CONCAT({name}," - ",{DE: Your Field Name }) Add conditions: valueexpression=IF({DE: Your Field Name }="Yes",{DE: Your Field Name },"Missing") Let us know how it works out! Thanks, Narayan Narayan Raum Workfront Delivery Lead - SunTrust Bank https://wf-pro.com for Text Mode & Solutions

[JasonLe2]

Hi Narayan, Worked like a charm! I was able to pull the value I needed from the task form. This is a big help and going forward it's going to save me a ton of time as well as giving my stakeholders a clearer picture of what's going on. Thanks again! Jason Lego Stanley Black & Decker, Inc.

[Doug_Den_Hoed__AtAppStore]

Hi Jason, Congrats on getting that going with Narayan. Your use of the phrase "giving my stakeholders a clearer picture of what's going on" reminded me of "https://community.workfront.com/discussions/community-home/digestviewer/viewthread?MessageKey=316d7273-fb57-49fe-8478-74233e456cfb&CommunityKey=aaafaff0-5e4e-4e38-8903-f1f990935567&tab=digestviewer#bm316d7273-fb57-49fe-8478-74233e456cfb" The 2nd Coolest Textmode Column I Invented This Week (from Mar, 2017 mind you), which I invite you to review, steal, and adapt as you see fit! Regards, Doug Doug Den Hoed - AtAppStore

[JasonLe2]

That is brilliant, Doug! Thanks! Jason Lego Stanley Black & Decker, Inc.

[NRYNR]

Hi Doug, While I admittedly haven't tried the code, I've gone ahead and added the code to the new "https://ddh.my.workfront.com/report/public/view?publicToken=cJC39KazDMyl5tJVSWFgiyVNJctelp14yRATPbVzoMoKFXEYuICk2BnLtAKI0nYbLFABYDMZIB5C3yHVZojbm8VPRSqmMsK-&endcap"> WFPro Text Mode Library . These long-ago solved issues are exactly what we need to capture to reduce the rework. This goes for everyone in the community. If you tag me in text mode solutions, I'll add them to this library. Thanks, Narayan

[MichelleBo1]

I love this library, but wish I could just copy and paste from it Michelle Bowden Fiserv ETG

[Doug_Den_Hoed__AtAppStore]

Hi Michelle, Thanks for pointing that out. Copying and pasting from a grid in Workfront is slightly tricky, but not too bad once you know how (using Chrome in this example): Regards, Doug Doug Den Hoed - AtAppStore