Automatic Status connection with To-Do List

Ask your questions here.
Post Reply
Eric
Posts: 43
Joined: 25 Jun 2020, 13:40
Name: Eric Henrich
Location: Germany

Automatic Status connection with To-Do List

Post by 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
Sponsor
Sponsor
Posts: 202
Joined: 19 Dec 2018, 02:33
Name: Robert McDonald
Location: Auckland, New Zealand
Company Name: Unicloud

Re: Automatic Status connection with To-Do List

Post by 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
Posts: 43
Joined: 25 Jun 2020, 13:40
Name: Eric Henrich
Location: Germany

Re: Automatic Status connection with To-Do List

Post by 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
Sponsor
Sponsor
Posts: 202
Joined: 19 Dec 2018, 02:33
Name: Robert McDonald
Location: Auckland, New Zealand
Company Name: Unicloud

Re: Automatic Status connection with To-Do List

Post by rmcdonald »

Do you have the extensions installed?

Eric
Posts: 43
Joined: 25 Jun 2020, 13:40
Name: Eric Henrich
Location: Germany

Re: Automatic Status connection with To-Do List

Post by Eric »

Yes, the Extension is installed.

rmcdonald
Sponsor
Sponsor
Posts: 202
Joined: 19 Dec 2018, 02:33
Name: Robert McDonald
Location: Auckland, New Zealand
Company Name: Unicloud

Re: Automatic Status connection with To-Do List

Post by 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
Posts: 43
Joined: 25 Jun 2020, 13:40
Name: Eric Henrich
Location: Germany

Re: Automatic Status connection with To-Do List

Post by 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?

Post Reply