Text Moding Adjustment from Project Report to Hour Report

Forum|Forum|1 year ago
September 12, 2024
1 reply
826 views

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

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

VicSellers

Community Advisor

Hi @michellefr2 - 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).

M

MichelleFr2Author

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?

VicSellers

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.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded