I would like to build a To Do list into my time sheet database and I am guessing that somebody has probably done this before and may have some suggestions.
"Task" table fields (TaskID, Description, DueTime, TaskDuration in hours, EmployeeID Employee assigned the task, Finished Y or N, PredecessorTaskID)
I think I will have to create another table with fields to enter how many hours a day each employee works each day of the week. We have some employees that only work a couple of days a week. Jay M=8, T=8, W=8, Th=8, F=8, Sa=4. Mark T=8, W=8.
Here is some information that I want the program to show me:
- What task should be worked on next for each employee
- Calculate each tasks start date in order to meet DueDate with logic that accommodates predecessor Tasks
- Show a "window" of available time if a client calls and requests work done
- Show how many hours we are behind to get on schedule
I can keep on going, but I think this is enough for now.
To summarize, I'm not looking for table setup or other fundamental setup help. I'm looking for help on the code to determine when each task should be started, how many hours are Tasked each day to each employee...