Expand my Community achievements bar.

SOLVED

Access Task Fields from Project Custom Field

Avatar

Level 5

Is it possible to create a custom field that lists all of a project's task statuses? If not, what would be the best way to display this information in a field that would be readable by Fusion.

Topics

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

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi,

 

No, i'm afraid that this isn't possible. Tasks are classed as a collection on the project object (since a project can have multiple tasks) and it's not possible to pull the values from every task into a single field.

 

If the desired outcome is to pass all of the task statuses on a given project to Fusion, is there a reason why you wouldn't just use Fusion to read the tasks and retrieve the statuses?

 

Best Regards,

Rich.

 

View solution in original post

3 Replies

Avatar

Correct answer by
Community Advisor

Hi,

 

No, i'm afraid that this isn't possible. Tasks are classed as a collection on the project object (since a project can have multiple tasks) and it's not possible to pull the values from every task into a single field.

 

If the desired outcome is to pass all of the task statuses on a given project to Fusion, is there a reason why you wouldn't just use Fusion to read the tasks and retrieve the statuses?

 

Best Regards,

Rich.

 

Avatar

Level 5

I am trying to create a scenario to auto close projects and I am trying to make the initial filter better so I am not pulling hundreds of bundles in the first search, but I guess this cannot be avoided.

Avatar

Community Advisor

Is this what you're looking for?

ScreenShot 2025-01-21 at 9.13.12 am.jpg

displayname=Task Status
listdelimiter=<br>
listmethod=nested(tasks).lists
textmode=true
type=iterate
valuefield=status
valueformat=HTML

TIP: if this solved your problem, I invite you to consider marking it as a Correct Answer to help others who might also find it of use.
If you like my content, please take a moment to view and vote on my Idea Requests: https://tinyurl.com/mysocalledideas