Add a program field to a task level report | Community
Skip to main content
L
lizpowell
New Participant
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

RandyRoberts
RandyRobertsAccepted solution
New Participant
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

 

    L
    lizpowellAuthor
    New Participant
    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.

    Rafal_Bainie
    Rafal_Bainie
    New Participant
    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

    Terms & ConditionsAccessibility statement

    Loading footer...