Add a program field to a task level report | Adobe Higher Education
Skip to main content
Level 2
January 11, 2024
Beantwortet

Add a program field to a task level report

  • January 11, 2024
  • 2 Antworten
  • 820 Ansichten

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

Dieses Thema wurde für Antworten geschlossen.
Beste Antwort von 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 Antworten

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
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

 

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.