BSTMonthSched Data Files Prompts.

The Appointment(Schedule) File Needs to store the ResourceId mentioned in the above file, and Retrieves the Listbox Display name from that information and ties the files together.  Three Keys are required, a ResourceId-date-time Key, Date-Time Key, and Autoinc SysId key.  Minimum Fields consist of the SysId, ResourceId, Date, Time, Duration, and the Schedule Display. 

The Sched Display(EXPR) is what shows up in the Listbox for the Scheduled appointment, and you can fill it from a customer file, and/or other files, or freehand other entries such as Lunch, Vacation, Business Meeting, etc.  This should be a required field also in your update form for the file.  You can also assign a Local Variable to this field and build the display line in the TakeRecord Appt Embed.

Add another Field for ToolTip Adds the ToolTip Function to the Scheduler Listbox.  You must supply a Default tool tip to display when it is empty.  ToolTip Display(EXPR) is an expression field that can be built with multi lines by adding "& CHR(10) &" to your expression to add line feeds.  You can also assign a Local Variable to this field and build the display line in the TakeRecord Appt Embed.  You can examine them if empty, and only add the line feed if they contain data, etc for appearances.  This information is stored in the Listbox Queue as a Cstring, and you determine the length you need from 1 -255 in Display Length for ToolTip.

Conflict ToolTip (EXPR) checkbox and entry field.  Check this box and select local variable or build an expression to represent a tooltip to use when a conflict is present to be substituted at the time the listbox is being loaded with appointments.

Appointment(Schedule) File

SysId --  Autoinc Key (for update options)

ResourceId--Date--Time  Key

Date--Time  Key

SysId Field, long, Autoinc

Date Field

Time Field

Duration Field

ResourceId Field --- To tie to Unique Field in Resource File

SchedDisplay --- Field that displays in the Appointment Field in the Listbox

Date keys used in the Template need to be in ascending order or the template will not work with the file.

For your convenience, a BSTTxd directory under the Example File contains 6 example .txd files with the idents removed so you can safely add one or more of them to your dictionary for use with the templates.

The Resource File Ideally Needs a SysId(Long) With a key on it.  This field does not have to be a long, but must be unique to identify the Resource.  It also needs a field(s) with the "Information to Display" in the Resource Column or Left Row in the Listbox.  The Resource Display is an Expression Field, so it can be built from other fields.

Select Resource Procedure is used by the template to switch the resource being used at runtime.  You must supply a procedure to satisfy the template, and can delete the selection buttons, etc in the window formatter if you choose not to use this dynamic feature. 

Preload Resource(EXPR) is used for startup of the procedure to load the first Listbox shown, or if you are using as a PIM, substitute the ResourceId from a variable here to Preload the correct resource.

Resource File

ResourceId    Key(Unique)

ResouceName    Key(Optional for Display)

ResourceId Field

ResourceName  Field(s)  ---   Displays in column or row Headers for the Resource.(Can be Expression)