Display Custom Field That is Two Objects Away

[NickVa1]

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

[AnthonyIm · Accepted solution]

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

[NickVa1]

Imgrund for the win!

Thanks, Anthony.