Schedule Board examples

From Resco's Wiki
Jump to: navigation, search

This article describes several useful examples of using the Schedule Board.

Filter sources and resources by skill

This example demonstrates how to assign skills to sources and resources and use this in the scheduler to simplify filtering.

We are using the following entities:

  • Case is the source entity.
  • Resource is the resource entity.
  • Case Inspection is the activity (with Resource Lookup and Case Lookup fields).
  • Skill is an entity that lists all skills.
  • Resource Skill is an N:N relation table saying what are the skills of your resources (with skillid field and resourceid field)
  • Case Skill is an N:N relation table saying what skills are required for your cases (with skillid field and caseid field)

Edit your app project. Select Scheduler from the Project menu. Create a new scheduler configuration or open an existing one that you want to modify.

On the Activity tab, set Case Inspection as your Activity Entity. Use Resource Lookup as Resource Lookup Field and Case Lookup as Source Lookup Field.

Scheduler activity tab.png

On the Resource tab, configure Skills for the Resource entity.

Scheduler resource tab.png

On the Source tab, configure Skill for the Case entity.

Scheduler source tab.png

Save your scheduler and project changes, then publish the project and synchronize the app. You can now use Filter Skills to filter both your sources and resources simultaneously.

Schedule board filter in action.png

Filter sources and resources by skill (alternative solution)

The second example solves the problem as before, but somewhat simplified. In this case, we don't use two separate N:N relationship entities to bind skills with sources and resources. Instead, we only add a lookup field to the source and resource entity, that points to skills. The limitation of this scenario is that each source or resource can have only a single related skill.

We are using the following entities:

  • Case is the source entity (with a Skill Lookup field).
  • Resource is the resource entity (with a Skill Lookup field).
  • Case Inspection is the activity (with Resource Lookup and Case Lookup fields).
  • Skill is an entity that lists all skills.

In this case, the schedule board configuration also has to change slightly. On the Source and Resource tabs, the Skill Lookup field from Case or Resource entity is used to link directly to target Skill.

Scheduler source tab alternative.png