Skip to Content
Menu
This question has been flagged
1 Odpoveď
3232 Zobrazenia

I need to create automated action that will send me an email when the total number of hours spent on tasks will exceed the number of hours planned.

But i don't know how to compare those two variables into a domain, also the total number of hours spent can be used as a trigger but not for the domain.

Do i need to use python or is there a way around it ?

Avatar
Zrušiť
Best Answer

Hi,

If you want to use compare two fields in automated action so you need to use python code and send an email from python code, or you can add another field which store the value of the comparation and then use it in the automated action domain.

Avatar
Zrušiť
Autor

How can i add another field calculating that ?

Are you using Odoo Enterprise with Studio app or using Odoo Community?

Autor

Odoo enterprise

You can create Boolean computed field in task and set the field store as True (to be able to use in domain) and use depends on fields (total number of hours spent, number of hours planned) and then in compute python code set your python code to compare the two hours and set the Boolean field to true or false.

Follow the below article for how to create computed field using studio
https://odootricks.tips/about/building-blocks/computed-fields/

Autor

It's working ! Thank you so much, you're a life saver

Related Posts Replies Zobrazenia Aktivita
1
okt 23
2896
0
feb 25
18
1
okt 23
2662
0
mar 23
1634
1
mar 23
9154