Text Mode for Custom Field on Hour Report | Community
Skip to main content
ConnorO2
ConnorO2
Level 4
August 13, 2025
Solved

Text Mode for Custom Field on Hour Report

  • August 13, 2025
  • 1 reply
  • 450 views

I'm looking to add a column to an hour report that shows a specific custom field at the project level. Keep in mind that this field is a typeahead field referencing a Portfolio name. 

I've been reviewing exists statements but I can't remember how to set this one up. 

 

Looking for some help on this one from the Workfront Community! 

Best answer by skyehansen

just a guess:

 

valuefields and querysorts should look like this:    DE:project:field name:name
valueexpressions should look like this:    {project}.{DE:field name:name}

1 reply

VicSellers
Community Advisor
VicSellersCommunity Advisor
Community Advisor
August 13, 2025

Hi @connoro2 - It should be something like valuefield=project:[DE:typeaheadfield]:name in the text mode. Typeahead fields need that name at the end in text mode to show a result (or another variable). Let me know if that doesn't work!

 

 

ConnorO2
ConnorO2Author
Level 4
August 14, 2025

@vicsellers I think that's what I've tried before and it wasn't working. Keep in mind that this is on an Hour Report and not a project report. So I think I'm missing something here. 

 

displayname=Bill To
linkedname=direct
namekey=Bill To
querysort=project:DE:Portfolio To Bill Name:name
valuefield=project:DE:Portfolio To Bill Name:name
valueformat=HTML

skyehansen
Community Advisor
skyehansenCommunity Advisor
August 15, 2025

@skyehansen @vicsellers 

 

I have a feeling it's because the type of custom field is a typeahead field. I can't seem to pull up any typeahead fields within an Hour report. Is it not supported at that object level to reference anymore? 


I'm looking at an hour report right now, and all my typeahead fields are under the project object, without need for any text mode. So in the project section of the view, do you not see a field name that is the same as your typeahead field name? i.e. not in a separate typeahead field section -- in the project section.

 

(If you're not seeing this, I am not sure what your problem would be -- I definitely recommend you clear cache and cookies, and then if that doesn't work, just work with your system admin to get a case opened with the workfront Support team.)

    Terms & ConditionsAccessibility statement

    Loading footer...