Working hours

From Resco's Wiki
Jump to navigation Jump to search

Working hours is a feature that allows you to configure the working hours of your resources. On the Schedule Board, this restricts the time interval for scheduling tasks to this resource.

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

tables needed for the working hours feature on dataverse

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.
Add lookup column to your resource table, pointing to Working Hours table

Enable the tables in Woodford

Start Woodford and enable the necessary tables and columns. Also, create Woodford views and forms for these tables.

SB Settings
Enable the columns First Day Of Week, Start Of Day, Working Day Duration, Working Hours, Working Weekends.
Create a view and a form for this table. The only necessary column is "Name". The form will automatically include the working hours editor.
SB Working Hours
Enable the column Data.
Create a view and a form for this table. Include the SB Working Hours lookup column on the form.
Resource table
Enable the new column (SB Working Hours lookup).
Add the column to your form.

Finally, add these tables to your home screen so that you can enter the data.

Add tables necessary for working hours configuration to your app project

Define working hours in the app

First, use the mobile app to define the working hours. Create a new working hours record and add the hours.

Define working hours in the app
Add multiple sets of working hours for different users.

Next, select one of the working hour records as the company default.

Define company-default working hours in thee app
Even if you keep the lookup field empty, you can use other fields like "Start Of Day" (specify the number of minutes since midnight) and "Working Day Duration" (again, in minutes) to define the hours.

Finally, you can assign working hours to your resources.

Assign working hours to resource records
Resources without specific working hours assigned fall back to company default.

Working hours editor

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

how to use the working hours editor in the app
Use the plus button to add a new range of working hours. Use the x button to delete it. Use the clone button to copy working hours from a different day.
Set a day to "Unavailable" if you don't want to work on that day. Set it to "Inherited" to fall back to company default / hardcoded values for that day.

The hours are stored in the "Data" field in JSON format. The numbers are in minutes. Don't edit the "Data" field directly; when you save the record, values from the custom editor overwrite the "Data" field.

You can also create a standard form for this table in Dataverse. In this case, no special editor appears. You can work with the Data column directly. We recommend using the editor in Resco mobile apps.

  "workingHours": [
        "start": 480,
        "end": 780
        "start": 840,
        "end": 1140
        "start": 480,
        "end": 960
  "workingHolidays": false

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.

Schedule board timetable with working hours

Was this information helpful? How can we improve?