Working hours: Difference between revisions

Jump to navigation Jump to search
No edit summary
Line 1: Line 1:
'''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 [[Releases/Winter_2021|release 14.3]]), but it can be potentially reused for other organizations that use Schedule Board.
'''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 [[Releases/Winter_2021|release 14.3]]), but it can be potentially reused for other organizations that use Schedule Board.


== Necessary entities ==
== Prepare the necessary tables and columns ==


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


* Working hours (fs_workinghours) - allow you to save different working hours under a name
;SB Working Hours (resco_fs_workinghours)
* Company settings (fs_settings) - select one of the configured working hours as the company default (the entity must have a lookup to the Working hours entity)
: Each record corresponds to a different set of weekly working hours. You can define multiple working hours, each with a different name.
* Resource (fs_resource) - select one of the configured working hours for each resource (or other entity that you are using for your Schedule Board; the entity must have a lookup to the Working hours entity)
: <small>On Resco Cloud, the entity is called Working hours (fs_workinghours).</small>
 
;SB Settings (resco_fs_settings)
: Select one of the configured working hours as the company default (the entity must have a lookup to the Working hours entity)
: <small>On Resco Cloud, the entity is called Company settings (fs_settings).</small>
 
;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".
:[[File:Resource-table-lookup-to-working-hours.png|200px|alt=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.


== Defining working hours ==
== Defining working hours ==

Navigation menu