Using Time Reporting view
Table of Contents
Set up
The recommended method of setting Time Reporting up is to use Workspace Template, as described in Installation chapter. This creates all the necessary boards, columns and views to start tracking time.
Workspace Template creates set of boards connected as below:
Level 1 board (e.g. Clients) - has Allowed People and Allowed Level 2 columns which limit selection of Level 1 items per Person, and Level 2 items per Level 1 item. This is useful if, for example, you want to limit which Clients can be selected per Person, and which Level 2 items (e.g. Projects) can be selected per Client.
Level 2 board (e.g. Projects) - has Allowed Level 3 column which limit selection of Level 3 items per Level 2 item. This is useful if, for example, you want to limit which Level 3 items (e.g. Activities) can be selected per Project.
Level 3 board (e.g. Activities)
Time Reporting board with several columns necessary to manage time data. It also contains a preconfigured Time Reporting view and an Integration which can be used if board has permissions set to "Edit content only in items assigned in the Person column(s)"
Holiday boards - configured in Time Reporting view Holiday Settings.
Custom setup
It is also possible to set it up from scratch without the Workspace Template. To do that, you'll need at least 2 boards:
- board with reference items (e.g. clients, projects or tasks)
- main board for tracking time
1. Create reference items board
(Optional) Create new workspace to keep the new boards
Create new board (e.g. Tasks)
Delete unnecessary columns
- delete Status
- delete Date
(Optional) Add people to Persons column if certain tasks are only available for certain people. Rename column to "Allowed Persons"
Add some example tasks
(Optional) Assign people to tasks
2. Create main board setup
Create new board
Remove items and unnecessary group
Add columns
- Time (Numbers)
- Note (Text)
Connect reference board(s) by creating Connect boards column and connect it to previously created reference board
Delete all the items. Items will be created and managed by Time Reporting view
Create Time Reporting view and configure Note column (other columns - Level 1, Time, Date, Status - should get configured automatically)
Basic usage
Adding rows
Before adding any time, create a row. Row has to contain a Person and at least 1 level of reference.
Note, that selections for level 1- level 3 may be constrained based on the setup of respective boards.
- Level 1 values can be constrained by Allowed People column in Level 1 board and show only items allowed for selected person
- Level 2 values can be constrained by Allowed Level 2 column in Level 1 board
- Level 3 values can be constrained by Allowed Level 3 column in Level 2 board
Selection of columns with constraints is controlled by column name prefix, which can be set in View Settings of Time Reporting view. By default first columns of matching types are taken as constraints.
Entering times
Entering times is intuitive and similar to using spreadsheet. You can usee keyboard navigation too and move to the next cell using Tab or Enter (Shift + Tab/Enter to move to previous cell).
Adding notes
You can add a note on the time by clicking "dog ear" in the upper right corner of the cell (it appears when you hover over the cell).
Notes are visible as black "doe ears" in cells. Hover to see the note as a tooltip.
Deleting rows
To delete a row, use dropdown menu to the left of every row.
Constraining level 1 - 3 values
Using board permissions to control access
By default (i.e. Board edit permissions set to Edit everything) everyone can view and edit everyone else's time. To edit everyone's times, add yourself to Manager's list in View Settings of Time Reporting view.
In case this is not desirable and you want to limit edit permissions so that everyone, except boards owners, can only edit their own times, change Board edit permissions to "Edit content only in items assigned to them in the Person column(s)".
This alone would prevent non-board owners from entering new times or deleting them as this entails creation/deletion of items on the board. To address this, install Integration which comes with Time Reporting app.
From now on, users who are not board owners, won't be able to edit others' times. This applies even if they're on the Managers list in View Settings.
Configuring holidays
Holidays can be marked on the board, but we won't prevent you from adding or editing times on these days.
There are 2 types of holidays:
- Corporate - apply to everyone
- Personal - apply to selected persons
An example of a simple personal holiday board using Date From/To columns:
Note, that it's possible to use Timeline column instead of Date From/To columns. A corporate holiday board can be created in a similar way, but Person column in that case wouldn't be required.
Once you've created holiday boards, navigate to "..." menu in the Time Reporting view and select Holiday Settings.
You can then add as many boards for Corporate or Personal holidays as necessary. Holidays from each board can be marked with selected colors.
Implementing time approval process
- Add new status column to Time Reporting Board, name it for example Approval
- Restrict editing of that column to selected people with approval rights
- Edit available statuses according to your process, e.g. New item, Ready for review, Approved, Declined
- Duplicate Time Reporting view and name it for example Time Approval
- Set up Time Approval's view settings to point Status Column to newly created status column Approval
- Set up automation: When Status changes to Submitted, change Approval to Ready for review
From now on approvers can use Time Approvals view to quickly review and approve/decline entered times.