Text Mode Syntax for pulling Custom Field User Name from project in a task report

[williamw6605351]

Hi, I have a custom field in a project to capture the primary designer assigned to a project and I want to have a task report that show all tasks assigned to someone and with the primary designer for each one.

I can't seem to figure out how to drill down to the name in the custom field. When I use this code:

displayname=Primary Designer for Project
linkedname=project
namekey=view.relatedcolumn
namekeyargkey.0=project
namekeyargkey.1=DE:Primary Instructional Designer
querysort=project:DE:Primary Instructional Designer
textmode=true
valuefield=project:DE:Primary Instructional Designer
valueformat=HTML
 

I get this result:

{"objCode":"USER","name":"PERSON NAME","ID":"5e7cb8c30043a484dd0143b23bb36220"}

So I tried adding a name argument to the code, but that displays nothing in the column:

displayname=Primary Designer for Project
linkedname=project
namekey=view.relatedcolumn
namekeyargkey.0=project
namekeyargkey.1=DE:Primary Instructional Designer
namekeyargkey.2=name
querysort=project:DE:Primary Instructional Designer:name
textmode=true
valuefield=project:DE:Primary Instructional Designer:name
valueformat=HTML

Any idea what I'm missing? Appreciate any insight.
 

[lgaertner · Accepted solution]

Hello,

It seems, that this is an issue for years as you are not the only one asking for this.

Please see the following thread, as there is a workaround using an additional calculated field in your custom form.

https://experienceleaguecommunities.adobe.com/t5/workfront-questions/reporting-on-typeahead-fields/m...

Regards

Lars

[williamw6605351]

Thanks for pointing me to that article. Glad to know I'm not the only one that was confused why it wasn't working. Maybe one day they'll fix it.