LinkedIn
Twitter
Hi,
I'm making a resource planning application where when a task is completed the hours planned get removed from the employee since they completed the task.
I set up a few actions to change the status of the task to complete but I'm having difficulties with subtracting the hours from the employee that did the recently completed task. I have a table Employees, Tasks and a table Hours with a ref to Employees, when the task gets set to complete the hours of that employee should be subtracted by the hours of the task.
Right now I have this Group set up
I've looked some things up but can't seem to figure out the right expression to execute the action the way I want.
