Calculation based on imcompleted/total task counts?
is there a way to calculate number of uncompleted tasks on a particular item? 2 examples would be:
calculating the progress of an item:
[number of completed tasks] / [Number of Total Tasks]
CRM "pipeline" where a client is in a "requires follow up" but no task is open so it is a "danger zone"
trying to avoid creating a task app and trying to get my team to switch from pressing " T " to actually creating relationships....
William - did you ever find an answer here? I'm using a Projects app and a Deliverables app, wit Tasks on the deliverable. I've got Globiflow set up to average out the Deliverable progress levels to update the overall project progress but there's no such logic in place for tasks. I assume it's because Tasks can be attached to pretty much anything in the system. They aren't customizable objects like app items. I can't find any documentation for GlobiFlow that helps point toward how to reference the task object via PHP either.
Without Globiflow I feel like Podio is way too basic for any sophisticated enterprise use because it requires too much manual data management. The more I can automate the process for my team, the more likely we are to see high levels of adoption.
Just adding a note that I put in a feature request for this issue.
In Globiflow, there's a collector for open tasks (https://www.globiflow.com/help/get-item-tasks-collector.php), but none for all or closed ones. You won't be able to calculate the ratio completed/total, but you can check whether or not there are any open tasks.
As you say, it's better to avoid tasks. Comments under tasks are content graves, and you can't calculate with them in calculation fields and only limited in GF.
If you want to model a hierarchy between an item and "sub-tasks", you can do this with a sub-issues app or, more elegantly, create a "Parent" relationship field with reference to the app itself. Then you can do all kinds of JS and GF magic.
Please sign in to leave a comment.