Display Custom Field That is Two Objects Away

Question

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

imgrund · Accepted Answer

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

NickVa7 · Answer

Imgrund for the win!Thanks, Anthony.

Sign up