I am trying to implement a simple scheduling function which writes tasks to a tasks database. However when a task is created it can be repeated for a number of weeks via a script. I would like to build in a validation step to make sure that the assignee does not have an overlapping task.
ie. a typical task is between 1 and 5 hours long. Thus if they start at 1 pm and finish at 4, I would like the script to pause if there is another job booked in for this assignee for the same day which starts/ends at 3pm and show a warning and would force me to edit the timing of the event.
I am not sure how best to go about this. I have tried it with related records and constraining found sets etc but I have not been able to make this implementation work. any ideas?