Add a program field to a task level report | Community
Skip to main content
Level 2
January 11, 2024
Solved

Add a program field to a task level report

  • January 11, 2024
  • 2 replies
  • 819 views

Hello! Is there a way to add a program level field (this is a program data point that is a custom form) into a column of a task level report?

 

I tried copying the text mode (below) of the column in a project level report, but it did not work.

 

displayname=
linkedname=program
namekey=view.relatedcolumn
namekeyargkey.0=program
namekeyargkey.1=PIM | RHC TShirt Size
querysort=DE:program:PIM | RHC TShirt Size
textmode=true
valuefield=program:PIM | RHC TShirt Size
valueformat=customDataLabelsAsString

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by RandyRoberts

Substitute "name" with your desired program field.

displayname=Program linkedname=project namekey=view.relatedcolumn namekeyargkey.0=project namekeyargkey.1=program:name querysort=project:program:name textmode=true valuefield=project:program:name valueformat=HTML

TIP: if this solved your problem, I invite you to consider marking it as a Correct Answer to help others who might also find it of use.
If you like my content, please take a moment to view and vote on my Idea Requests: https://tinyurl.com/mysocalledideas

 

2 replies

Rafal_Bainie
Community Advisor
Community Advisor
January 12, 2024

I think, This cannot be done directly, program is 2 steps away from task (via project).

If you had a field on project that would carry over that data from program, than you could include that in the task report

RandyRoberts
Community Advisor
RandyRobertsCommunity AdvisorAccepted solution
Community Advisor
January 12, 2024

Substitute "name" with your desired program field.

displayname=Program linkedname=project namekey=view.relatedcolumn namekeyargkey.0=project namekeyargkey.1=program:name querysort=project:program:name textmode=true valuefield=project:program:name valueformat=HTML

TIP: if this solved your problem, I invite you to consider marking it as a Correct Answer to help others who might also find it of use.
If you like my content, please take a moment to view and vote on my Idea Requests: https://tinyurl.com/mysocalledideas

 

lizpowellAuthor
Level 2
January 17, 2024

This worked! 

 

Here is the exact info I used.

 

displayname=Program RHC Tshirt Size
linkedname=project
namekey=view.relatedcolumn
namekeyargkey.0=program
namekeyargkey.1=program:PIM | RHC TShirt Size
querysort=project:program:PIM | RHC TShirt Size
textmode=true
valuefield=project:program:PIM | RHC TShirt Size
valueformat=customDataLabelAsString

 

 

BUT I am now running into an issue where that field is blank when I export to excel. There is info in the field in Workfront, but when I export, the field is blank. Any solutions for this? I already tried removing the column then re-adding.