Introduction to SchedulersUniversal GUI
A Scheduler can be used to visualize appointments or tasks on a timeline.
An example of a Scheduler in an end application
Available features in a SchedulerUniversal GUI
Drag & drop is allowed in the Scheduler. The start- and end date of a row can be changed manually, and by dragging the resource horizontally. If the subject is a view, this could require an instead-of update trigger. Dragging an activity to another resource will update the Group Until column to the target value. Note that, since the translation of lookups is not yet supported, you might have to translate this back to a correct foreign key value using an instead-of update trigger.
Zoom in or out to another timescale. This can provide a better overview. The scheduler component remembers the timescale the user selected: When reopening the scheduler window, the last timescale chosen is displayed. This preference is saved in the browser (for example, Google Chrome on your device) but is not persisted across browsers or devices.
Not yet available:
- Double-click events, for instance, tasks or appointments.
- Double-click time cells.
- Drag & drop an external row, for instance, from a grid.
Set up a schedulerUniversal GUI
To show a Scheduler in your end product, a table or variant needs a screen type with a Scheduler component. See Scheduler component.
To set up a scheduler for a table or variant:
menu User interface > Scheduler > tab Tables
menu User interface > Subjects > tab Components > tab Scheduler
Select the table or variant to which you want to add a scheduler.
If you already configured one or more Scheduler views, you can select one in the field Default view. For more information, see Add Scheduler views.
Define Linked columns to populate the scheduler with resources:
- Resource grouping column: the column used to represent a resource on the scheduler. Rows with the same value in the resource grouping column will be grouped together in the same resource row in the scheduler.
- Activity title column: contains the title for the activity.
- Activity tooltip column: contains the tooltip for the activity.
- Activity start date column: contains the start date for the activity.
- Activity end date column: contains the end date for the activity.
- The activity color can be set with a conditional layout in the Activity title column.
- You can add resources that do not yet have an activity by including a row in the subject with an empty start- and end date.
Specify the Drag-drop permissions
- Allow date dragging: Allows the activity to be dragged to another date for the same resource.
- Allow resource dragging: Allows the activity to be dragged to another resource for the same date.
A Scheduler starts in the current month.
Set up a scheduler for a table or variant
Add scheduler views and timescalesUniversal GUI
The Scheduler views determine how the scheduler is displayed in your end product. It is possible to add multiple timescales.
menu User Interface > Schedulers > tab Tables > tab Scheduler views
menu User Interface > Subjects > tab Components > tab Scheduler > tab Scheduler views
- Enter a Sequence no. If no default is selected, the first Scheduler view according to its Sequence no will be shown as the default instead. The other available Scheduler views can be selected by the user in your end application.
- Clear the Show scheduler view box if this Scheduler view should not be available for this table or variant.
- Configure the settings for the Scheduler view:
- Not yet available *Sliding pagination* - The UI uses the top timescale to determine the pagination. If sliding pagination is disabled, the window will start and end at the full interval of the highest timescale (e.g., a full calandar year). If sliding pagination is enabled, a sliding window will center around the current data and time (e.g., summer this year to summer next year).
- Labels for lowest timescale: Determines whether the lowest timescales will be labeled. If selected, the cells of the timeline will be split according to the lowest timescale interval. This allows for a more fine-grained display of the timeline and more precision when dragging and dropping activities. For example, every hour interval could be split into 30-minute intervals. If deselected, instead of every 30-minute segment, only the hours will be labeled and each hour will contain two segments denoting the 30-minute intervals.
- Configure one or more timescales. You can select an existing scheduler as default in the Scheduler tab.
- The highest timescale will be used as the scheduler's scale.
- The lowest timescale will be used for the scheduler's cells.
- The lowest timescale and any other available timescales will become scheduler headers.
- The highest two headers are combined when relevant to save space, for example, by placing the year after the month.
- Intervals higher than 1 will be denoted in a way that indicates the duration, e.g. "1 AM - 12 AM".
If you customize one year, one month, and one day as timescales:
- Your scheduler will scale across a year.
- Each cell will be a single day.
- A header will show the day and month.
Scheduler views and timescales