CalLite (Calendar Lite) allows you to create, move or change a booking with full support for drag and drop.
To set up, you will need two related tables. On the first table (the parent) setup any fields you need in order to constrain the relationship (e.g. specifying whose calendar records to show). The second table (the child) will hold the appointment records and requires the following fields setup:
- "zModID" a calculation with the number value of Get(RecordModificationCount) unstored
- date: representing the start date
- number: for the length of the appointment
- text: describing the appointment
CalLite( displayStartDate ; displayNumDays ; "dateFieldName" ; "startTimeFieldName" ; "durationFieldName" ; "descriptionFieldName" {; actionOnApptSelect })
Parameters
| 1 | displayStartDate | The first date to show on the calendar. Can be a date in quotes or the name of a field (on either the parent or the appointment table) containing the date, or a calculation producing a date. If a field name is used, it is NOT enclosed in quotes. |
|---|---|---|
| 2 | displayNumDays | The number of days to show. The width of each day shown is fixed, so you will see as many days as will fit in the Web Viewer you’ve drawn. Can be a number or the name of a field (on either the parent or the appointment table) containing the number of days, or a calculation producing a number. If a field name is used, it is NOT enclosed in quotes. |
| 3 | dateFieldName | The field on the appointment table containing the appointment date. Must be of type Date. The field name needs to be enclosed in quotes and be the full TO::FieldName form. Note that parameters 3, 4, 5 and 6 should not be calc fields if you want to be able to update records. |
| 4 | startTimeFieldName | The field on the appointment table containing the Start Time of the appointment. Must be of type Time. The field name needs to be the full name and enclosed in quotes. |
| 5 | durationFieldName | The field on the appointment table containing the Duration of the appointment. The field name needs to be the full name and enclosed in quotes. Entered as a number eg. 30 mins entered as 0.5. |
| 6 | descriptionFieldName | The field on the appointment table containing the Description of the appointment. The field name needs to be the full name and enclosed in quotes. |
| 7 | actionOnApptSelect (opt) |
The name of the script or a command to run on selection of an appointment. (useful for obtaining the record number of the record currently being edited). See note on syntax below. |
Action Parameters
Optional Action parameters allow you to run a script or set a field when a field is selected. See Action Parameters for details.
Example: The following shows a Web Viewer, followed by what it produces in Browse mode.
You can scroll up and down by clicking and dragging on the time panel on the left. Note that record changes are not automatically updated in the Lite version.
Important Notes:
The DayCal requires the use of the zMODid field, and uses the relationship between the layout context it's on the 'appointment' table. You will need to read the linked pages on those subjects.
Refresh Issues
Sometimes it can be difficult to get the Web Viewer calculation to refresh. For more information about resolving this issue, read here.