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 help categorize Community content and increase your ability to discover relevant content.
Views
Replies
Total Likes
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).
Views
Replies
Total Likes
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?
Views
Replies
Total Likes
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.
Views
Replies
Total Likes
Okay. Thank you. I appreciate your help!
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies
Views
Likes
Replies
Views
Likes
Replies