Getting a portfolio name from a project typeahead field

[ktrivedi]

I have a typeahead custom field (of type 'Project') defined in one of my custom form; custom form is attached to Issues. Name of project is "Resource By" in example below.

I want to create an issue report and display description and owner of the attached project on that issue report. When I try that, I am able to only display name of project, but cannot display anything else. See attached screen shot.

Name: (this works fine)
valuefield=Resource By:name
textmode=true
valueformat=customReferenceObjectAsString
displayname=Resource Project Description

Description: (this does not work)
valuefield=Resource By:description
textmode=true
valueformat=customReferenceObjectAsString
displayname=Resource Project Description

I tried a lot of other combinations (using valueexpression and other), but nothing worked.

Is that possible to show attributes of custom typeahead field in a report?

[skyehansen]

I believe it's still not possible to show anything other than the ID and the name.

[ktrivedi]

OK. Thanks @skyehansen. 

[NicholeVargas · Accepted solution]

This should work for the description field, I tried it on my end and was able to pull it in. 

Let me know if you run into any issues! 

displayname=Requested By Project Description
textmode=true
valueexpression={DE:Resource By:description}
valueformat=HTML

[ktrivedi]

Thank you so much.

[ktrivedi]

@NicholeVargas : This solves majority of my requirements, but I have one more requirement. Is it possible to show a custom field from that project? I have a custom field named "Engineering Manager". I tried following and it did not work.

displayname=Requested By Project Description
textmode=true
valueexpression={DE:Resource By:Engineering Manager}
valueformat=HTML

displayname=Requested By Project Description
textmode=true
valueexpression={DE:Resource By:DE:Engineering Manager}
valueformat=HTML

[NicholeVargas]

Reporting on Typeahead fields in Workfront is fairly limited. You can pull in native fields using valueexpressions, but not custom fields, as far as I'm aware. I also connected with a few folks in Professional Services and they didn't think it was possible either. I have shared this feedback with the Workfront Product team for additional consideration as they are looking to improve reporting capabilities in the near future! 

[ktrivedi]

Thank you.

[SarahWilkersonCA]

We are still in need of the functionality to pull a custom field through a typeahead field into a report.  Any update from product as to when this will be available?

[TimothyBr]

Hello Community! 

We have a project typeahead field on a request form, and were going to use Fusion to populate a filed showing which portfolio that project resides in. 

While setting up the Fusion piece, we thought to ask if there is a way to do this more natively with a calculated field. 

Appreciate any feedback in advance. 

Thanks! 

[skyehansen]

You should be able to use similar to this, to set up a calculated field:

https://experienceleaguecommunities.adobe.com/t5/workfront-questions/displaying-attributes-of-custom...

Something like the below should work.

{DE:YourFieldNameHere:portfolio:name}