Hi WF Community,
I'd like to do the following, when creating a new calculated field on a project form, and wondering how to go about it:
I'm uncertain how to reference fields from a child object.
Thanks,
Nick
Solved! Go to Solution.
Hi Nick,
Short answer is, you can't. Collections aren't accessible in a calculated field's expression.
A calculated field can only reference objects found in the "references" tab of the object in the API Explorer. So a task can reference its project, but a project can't reference its tasks.
If you have Fusion, a scenario can be designed to aggregate your task or issue data within Fusion and then write that to a calculated field on a project form. The expression of that calculated field only references itself so the value can only be overwritten by Fusion.
Hi Nick,
Short answer is, you can't. Collections aren't accessible in a calculated field's expression.
A calculated field can only reference objects found in the "references" tab of the object in the API Explorer. So a task can reference its project, but a project can't reference its tasks.
If you have Fusion, a scenario can be designed to aggregate your task or issue data within Fusion and then write that to a calculated field on a project form. The expression of that calculated field only references itself so the value can only be overwritten by Fusion.
Thanks, WE. I now recall that information, after you explained it.
We do have Fusion, and that was my backup plan, so thanks for detailing a solution.
Cheers!
Views
Replies
Total Likes
Any chance you can share this Fusion recipe?
Views
Replies
Total Likes
Hi @ChristinaJay - see attached screenshots. Go top to bottom and left to right for proper sequence. Cheers!
Views
Replies
Total Likes
Hi @NickVa1 We are running into something similar.
Until the campaign object is released, we are using a workaround for campaign relationships. In other words, we want to tie projects to campaigns in a one to many ability.
In an ideal world, after 1.b above, Workfront would automate and add the newly generated value to a running list that makes up the "Campaign Related" field and which could be used for reporting. Going to post this in the ideas section because it feels like a good workaround if they don't release campaigns.
Hi All,
Has anyone successfully been able to reference a child on a calculated field?
We have a custom form that is attached to a parent task and then a WIP Milestone on a child task. Have created a calculated field on the parent and child to remove reference to a completed task so we can try and filter it out of a task report, however it is not filtering out as it is not detecting the child.
Any suggestions?
Thanks
Views
Replies
Total Likes
per this previous post, you can only reference objects that are on the References tab in the API explorer.
Views
Replies
Total Likes