Text Mode for Custom Field on Hour Report | Community
Skip to main content
ConnorO2
ConnorO2
New Participant
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
VicSellers
New Participant
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
New Participant
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
skyehansenAccepted solution
New Participant
August 14, 2025

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}

Terms & ConditionsAccessibility statement

Loading footer...