Skip to main content
ConnorO2
ConnorO2
Level 4
August 13, 2025
Répondu

Text Mode for Custom Field on Hour Report

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! 

Ce sujet a été fermé aux réponses.
Meilleure réponse par 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}

6 commentaires

VicSellers
Adobe Champion, Community Advisor, UG Leader
VicSellersAdobe Champion, Community Advisor, UG Leader
Adobe Champion, Community Advisor, UG Leader
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
ConnorO2Auteur
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
Adobe Champion and Community Advisor
skyehansenAdobe Champion and Community AdvisorRéponse
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}

Conditions d'utilisationAccessibility statement

Loading footer...