AnsweredAssumed Answered

Week Planner

Question asked by larsheise on Jan 30, 2013
Latest reply on Feb 1, 2013 by RubenVanDenBoogaard

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.

week.jpg

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.

 

Lars

Outcomes