Expand my Community achievements bar.

Interested in applying to or sharing a Workfront-related job opportunity? Check out the Workfront Job Board!
SOLVED

Display Custom Field That is Two Objects Away

Avatar

Level 9

Hi WF Community,

Can anyone assist me with some text mode in an HOUR report column that will show me the following?

  • I want to display the custom portfolio field called Country of Residence as a column within an hour report

Here's the text mode I concocted for this column in my hour report, but it's not displaying anything:

displayname=Client Country of Residence

linkedname=project

namekey=view.relatedcolumn

namekeyargkey.0=project

namekeyargkey.1=portfolioID

querysort=project:portfolio:{DE:Country of Residence}

textmode=true

valuefield=project:portfolio:{DE:Country of Residence}

valueformat=HTML

Any guidance is welcome.

Thanks.

Nick

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Level 10

Hi - you don't need brackets in valuefield, only in valueexpression. Also, you don't need the DE for valuefield. Try

displayname=Client Country of Residence

querysort=DE:project:portfolio:Country of Residence

textmode=true

valuefield=project:portfolio:Country of Residence

valueformat=customDataLabelsAsString

2 Replies

Avatar

Correct answer by
Level 10

Hi - you don't need brackets in valuefield, only in valueexpression. Also, you don't need the DE for valuefield. Try

displayname=Client Country of Residence

querysort=DE:project:portfolio:Country of Residence

textmode=true

valuefield=project:portfolio:Country of Residence

valueformat=customDataLabelsAsString

Avatar

Level 9

Imgrund for the win!

Thanks, Anthony.

page footer