Skip to main content
Aug 5, 2023 1:52 PM UTC
Solved

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

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.
 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
lgaertner
lgaertnerAccepted solution
Level 9
Aug 7, 2023 9:01 AM UTC

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-p/504878/highlight/true/page/2

 

Regards

Lars

2 replies

lgaertner
lgaertnerAccepted solution
Level 9
Aug 7, 2023 9:01 AM UTC

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-p/504878/highlight/true/page/2

 

Regards

Lars

Translate
Aug 8, 2023 9:21 PM UTC

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.

Translate