Text Mode for Custom Field on Hour Report

[ConnorO2]

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! 

[VictoriaSellers]

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]

@VictoriaSellers 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 · Accepted solution]

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}

[ConnorO2]

@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. 

[ConnorO2]

@skyehansen @VictoriaSellers 

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? 

[skyehansen]

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.)