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:

Time Reporting setup
  • 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

  1. (Optional) Create new workspace to keep the new boards

    Create workspace
  2. Create new board (e.g. Tasks)

    Create reference board
  3. Delete unnecessary columns

    • delete Status
    • delete Date
  4. (Optional) Add people to Persons column if certain tasks are only available for certain people. Rename column to "Allowed Persons"

  5. Add some example tasks

  6. (Optional) Assign people to tasks

    Reference board set up

2. Create main board setup

  1. Create new board

    Create time reporting board
  2. Remove items and unnecessary group

  3. Add columns

    • Time (Numbers)
    • Note (Text)
    New columns
  4. Connect reference board(s) by creating Connect boards column and connect it to previously created reference board

    Create new Connect boards column
    Choose your reference board to connect to
    No need to mirror data - choose 'Do it later'. Don't allow linking to multiple items
    New column
  5. Delete all the items. Items will be created and managed by Time Reporting view

  6. Create Time Reporting view and configure Note column (other columns - Level 1, Time, Date, Status - should get configured automatically)

    Time reporting view
Note: Make sure there's no automations on your board that change any of the Person, Date, Time or Note columns. This may interfere with the app and produce unexpected results (e.g. assigning times to the wrong person if an automation modified Person column).

Basic usage

Adding rows

Before adding any time, create a row. Row has to contain a Person and at least 1 level of reference.

Add row dialog. Note tooltip showing the reason for constraint.

Note, that selections for level 1- level 3 may be constrained based on the setup of respective boards.

Constraints for level 1 - level 3 items
  • 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.

View Settings - selection of constraint column in Level 1 - Level 3 boards

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.

Example notes
Note: Notes can only be added to cells with values. Deleting a value doesn't delete note (so you're free to delete and enter new value without losing note if one exists)

Deleting rows

To delete a row, use dropdown menu to the left of every row.

Constraining level 1 - 3 values

Level 1 - level 3 boards with Connect board columns defining constraints

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.

View Settings, managers

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)".

Board permissions

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.

Integration

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
Holiday boards - shows columns required for Corporate and Personal holidays

An example of a simple personal holiday board using Date From/To columns:

Example personal holiday board setup

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.

Holiday Settings menu

You can then add as many boards for Corporate or Personal holidays as necessary. Holidays from each board can be marked with selected colors.

Holiday Settings
Example holidays on the board

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.