Locked Time Sheet

When adding a job/task to your time sheet, WorkBook adds 7 records (called a sequence), representing the work week (from week start to week end). Each sequence is given a unique number, and a whole sequence is represented as a single row in the time sheet.

The employee (or fallback to company) setting of Week start day is what decides how this sequence is placed, and how the time sheet is displayed.
So if the week starts on Monday, any new sequences will go from Monday to Sunday, and the time sheet will display columns in the order Monday to Sunday.

If an employee (or the whole company) gets a new week start day, this affects the time sheet view of all affected employees, and it affects any new sequences that will be created for them.
However, it will not affect the existing sequences, which are going to stay in the system, with the week days that they were originally added with.

As an example of this, consider the following scenario:

Karina’s week starts Monday. She adds multiple jobs and hours in two weeks (Monday 8/27 to Sunday 9/2, and Monday 9/3 to Sunday 9/9).
This means that two sequence for job 12 are added (sequence 1 and 2, the blue selected line in the pictures below), going from and to the dates above.

The next day, her boss changes the week start day to Sunday, which means that the work week now goes from Sunday to Monday instead. When Karina looks at her time sheet, it now displays from Sunday to Monday. This means that when she looks at the time sheet, it will show the 26th August to 1st. September instead of 27th of August to the 2nd of September. However, sequence 1 is still in the system as going from the 27th of August to the 2nd of September,. So when the week is displayed from the 26th August to 1st September, there is actually nothing in the system for the 26th, which results in the cell being locked.

 If she then goes to the next week (2nd September to 8th September) it will look even more strange.
In this week, the last day of sequence 1 is shown (Sunday the 2nd September, the first selected line), but there are no more dates in sequence 1 that matches the current week. So that will show as a line where only the first cell is open, and the rest are locked.

Below that will be sequence 2. It will look like a duplicate (it’s also job 127), and because sequence 2 does not contain the first date in the shown week, the first cell of this row is locked, and the rest are open.

If Karina then adds a new job to the week (2nd September to 8th September), the system looks at her week start setting, and finds that it should go from Sunday to Monday.
This new row will look “normal”, with all cells open, because all 7 dates of the sequence match the week that he is viewing.

When Karina gets to the next week again, she will still see the last day of sequence 2. This will display just like sequence 1 did in the week before, because only the last date of sequence 2 is available.

Finally, after a few weeks, all new sequences added will match the current view of the time sheet, and there will not be any locked cells due to missing dates.

Start date calendar settings can be accessed on an individual basis , or company-wide, as detailed on the following images.

Calendar Settings from Employee Settings:

Calendar Settings from Company Settings:



Was this article helpful? Useful Useless 0/1 found this article helpful.