Working hours

Working hours is a custom entity that allows you to configure working hours of your resources in the Schedule Board. This feature was designed for the resco.FieldService project (since release 14.3), but it can be potentially reused for other organizations that use Schedule Board.

Prepare the necessary tables and columns

The following two tables are necessary for this feature. On Dataverse, install a recent version of Woodford to make them available in your organization.

SB Working Hours (resco_fs_workinghours)

Each record corresponds to a different set of weekly working hours. You can define multiple working hours, each with a different name.

On Resco Cloud, the entity is called Working hours (fs_workinghours).

SB Settings (resco_fs_settings)

This table has a lookup column to the Working Hours table. Create only one record in this table. The lookup defines your company's default working hours.

On Resco Cloud, the entity is called Company settings (fs_settings).

Resource table with a lookup to Working Hours

Additionally, designate a table that corresponds to your Schedule Board resources (i.e., the people responsible for a particular activity). This can be a standard table, for example, System User, or a custom table. In either case, this table must include a lookup column to the Working Hours table, called "workinghoursid". This allows you to select working hours for each resource.

Enable the tables in Woodford

Start Woodford and enable the necessary tables and columns.

Define working hours

When you create a form for the Working hours table in Woodford, the form automatically includes an editor.

The hours are saved in the Data field. If you need to work with the data directly, it is stored in JSON format. The numbers are in minutes.

{
  "workingHours": [
    [],
    [
      {
        "start": 480,
        "end": 780
      },
      {
        "start": 840,
        "end": 1140
      }
    ],
    [
      {
        "start": 480,
        "end": 960
      }
    ],
    [],
    [],
    [],
    null
  ],
  "workingHolidays": false
}

Associate resources with working hours

Once the working hours are defined, you can associate them, either as the default setting of the organization, or with a particular resource.

Working hours in action

If everything is properly configured, you can see the working hours highlighted in the Schedule Board timetable. Note that Luke's working hours are different from other team members.