Hi WF Community,
I have a project report, whereby I am trying to surface values from custom fields on related programs. However, the result in my report custom column displays code.
Here's the text mode data for the Client Engagement Lead column:
displayname=Client Engagement Lead
linkedname=program
namekey=view.relatedcolumn
namekeyargkey.0=program
namekeyargkey.1=WF Client Engagement Lead
querysort=DE:program:WF Client Engagement Lead
textmode=true
valuefield=program:WF Client Engagement Lead
valueformat=customDataLabelsAsString
I played with the valueformat, but it's not seeming to make a difference.
Does anyone know what adjustment I might make to just display names without the extra code?
Thanks,
Nick
Solved! Go to Solution.
Good news, @NickVa1
I SWEAR that I tried this before and it didn't work, but I saw it working in another environment and tried again with a fresh mind.
Caveat is that you can't do this with a calculated view. But, you can do it if you add a calculated field to your project form.
On your project custom form, add a similarly named calculated field, like "Program Principal" (presuming the field name of the typeahead on the program form is called "Principal")
The expression for your project calculated field is easy:
{program}.{DE:Principal:name}
Recalc your project expressions, then your project view/report can be built to just reference your new project-level field "Program Principal"
Tested and working. Good luck!
Views
Replies
Total Likes
Good news, @NickVa1
I SWEAR that I tried this before and it didn't work, but I saw it working in another environment and tried again with a fresh mind.
Caveat is that you can't do this with a calculated view. But, you can do it if you add a calculated field to your project form.
On your project custom form, add a similarly named calculated field, like "Program Principal" (presuming the field name of the typeahead on the program form is called "Principal")
The expression for your project calculated field is easy:
{program}.{DE:Principal:name}
Recalc your project expressions, then your project view/report can be built to just reference your new project-level field "Program Principal"
Tested and working. Good luck!
Views
Replies
Total Likes
Thanks so much for your thorough attempts at a resolution, and details related to them, WE.
Views
Replies
Total Likes
Last we heard about this is they de-prioritised it in Feb '22. The original post was from 2019. It isn't really a "**bleep**y" new feature that could drive sales so I wouldn't get my hopes up.
Views
Replies
Total Likes
Thanks for circling back, WE. We ended up creating a program report, instead of a project report, and just included less info in it. Since I didn't have to reference fields from a different object, the JSON code does not appear. I'll keep your solution in mind should we wish to go back to our original requirement that included data from multiple objects.
Views
Replies
Total Likes
Views
Like
Replies
Views
Likes
Replies