I’m having a bit of a hard time figuring out Bots.
I have a Projects table and an Objects table. A Project has many Objects.
Both Projects and Objects have due dates.
I’d like to make a Bot that goes something like this:
- When the DueDate of a Projects is updated
- If the DueDate of it’s asociated Objects was equal to it, then update that DueDate too,
- And for those Asociated Objects that did not have the same DueDate as the Projects, leave it as it is.
The point being that Objects have an Initial value for the DueDate to be equal to the Project. So if it’s not equal, it means someone changed it on porpouse so no need to change it if the Projects changes. But if it’s the same, than it should change at the same time as the Project.
This really sounds like something a Bot should be able to do but I can’t figure out how.
The event is easy but the Process, steps and tasks … actions … anybody could sketch these steps out for me and I’ll give it a better go?
Or if it’s not something that can be done than, at least I know now