Text Mode for Custom Field on Hour Report

Forum|Forum|6 months ago
August 13, 2025
1 reply
453 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!

Workfront

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

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}

VicSellers

Community Advisor

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!

ConnorO2Author

Level 4

@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