Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
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 ?
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.
How can i add another field calculating that ?
Are you using Odoo Enterprise with Studio app or using Odoo Community?
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/
It's working ! Thank you so much, you're a life saver
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up| Related Posts | Replies | Views | Activity | |
|---|---|---|---|---|
|
1
Oct 23
|
1752 | ||
|
1
Oct 23
|
1127 | ||
|
0
Mar 23
|
864 | ||
|
1
Mar 23
|
6234 | ||
|
1
Dec 22
|
1667 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
