Text Mode for Custom Field on Hour Report

Forum|Forum|5 months ago
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!

Workfront

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

ConnorO2Author

Level 4

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}

@skyehansen

Still not getting what I need from this. Again I'm trying to pull this information from the project level onto the hour report. The column was reading data before and I guess maybe an update changed the way it was referencing the data.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded