Expand my Community achievements bar.

SOLVED

Display Custom Field That is Two Objects Away

Avatar

Level 10

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

View solution in original post

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 10

Imgrund for the win!

Thanks, Anthony.