Expand my Community achievements bar.

Text Moding Adjustment from Project Report to Hour Report

Avatar

Level 2

How do I update the following text mode field in a Project Report to show up for me in a Hour Report:

 

displayname=Asset Release date
listdelimiter=<div>
listmethod=nested(tasks).lists
textmode=true
type=iterate
valueexpression=IF({milestoneID}="65eb4286001da5f4059b8acb3e9c4ab8",CONCAT("",{plannedCompletionDate}),"")
valueformat=HTML

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

4 Replies

Avatar

Community Advisor

Hi @WF_Admin_Dell_Tech - The above is a collection text mode, which on an hours report the only collections available are for objectCategories and parameterValues. Collection text modes usually work better at the top of the object hierarchy (ex. project) to pull information up from objects below it (ex. tasks). 

 

What are you looking to achieve here? There might be a different solution. Unfortunately, on an hours report, you can't say for this hours record, hop to the related project, to then pull up task information (too many jumps).

Avatar

Level 2

Not sure, I just know the user wants to see the Asset Release Date on the hours report and so I pulled the custom data from a project report that was created and was hoping I could make some adjustments and pull the same information into an hour report. 

 

Could I make a calculated field on the custom form to pull the data?

Avatar

Community Advisor

Ah, unfortunately, no. Calculated fields can't pull up information to a custom form (only possible on reports). You could probably explore a Fusion scenario if worthwhile to write the information into the custom form from the task.