Hello fellow Odooers,
I’m trying to set up an automation rule in Odoo that sends an automated email whenever a date field matches the current date.
Here’s the use case:
We have a custom date field called "Due Date" (x_studio_due_date) in the Sales Module. I want to automate an email trigger such that when today’s date matches the "Due Date," an email is sent to the followers of the document asking them to check on the order and update the records.
I’ve tried using the condition “Due Date is set/is not set”, but the automation isn’t working as expected. It seems like the trigger isn’t being properly recognized.
Has anyone successfully implemented something similar or have insights into how I can get this to work? I’d really appreciate any guidance or tips!
Thanks in advance! 😊