Automatic Status connection with To-Do List

[Eric]

Hi,

is it possible to setup To-Do List with let´s say 3 Sub Task´s and when all 3 are checked, then the Automatic Status Field in Tasks is changing to Done ?

Regards

[rmcdonald]

you could put your sub tasks into a sub entity then run a function in a mysql formula field for the parent record to count the open tasks when it hits 0 that trigger can be used in the auto status settings.

You can simply hide the mysql formula field from users so they dont see the calculation

[Eric]

Sorry but my knowledge is not enough to be able to follow your idea, could you give me more advice how to do this please?

[rmcdonald]

Do you have the extensions installed?

[Eric]

Yes, the Extension is installed.

[rmcdonald]

Ok then in that case you would create your main entity for the project , then you would create a sub entity for the tasks.
using functions you can count the tasks that are not completed
https://docs.rukovoditel.net/index.php?p=48

Then put a mysql formula field in your main entity to call the function https://docs.rukovoditel.net/index.php?p=25 so when this counts 0 all the tasks are complete.

Then you can create an auto status field to like at the mysql field and when it is 0 all tasks complete

[Eric]

First of, thank you for your attempt to help!

It is impossible it seems according to missing description about this to get it done for me.
My knowledge about programming isn't high enough as it has to be to work with.
Still trying but no success.

Problem for me is to understand how to setup a function that can identify checked field or unchecked field in todo list, i know the field id and when creating a new field i can put in the field id for todo's but then this only counts all todo's and is returning the total amount of existing todo's in all tasks i have.

For my case with todo's i believe i need a formula to count checked fields from todo's but i am unable to create the code for this.

Ideas?