This should be so simple, but I just cannot find an easy way to accomplish it.
In one table I have some Tasks
Once a week, the manager wants to plan what some of his workers are to do the next week.
So I have the idea, that when you click on this task a script will make a new record in a new table and automatically fill in the text, and then manually you fill in:
the day of week ( popup - mon to fri )
initials of the person ( pop up from user table )
estimate of how long it will take to fulfill the task. (pop up with intervals of 15 min - up to 8 hours)
This should then be presented in a nice view something like this.
My problem is the coloring - combined with the time-estimate.
At the end of the week - everything should just be deleted, and we will start all over again.
Any ideas of how to structure this would be very welcome.