then the Calendar will allow the user to drag and place records in 1 minute increments (thanks to the DragPrecision declaration) and the user will also be restricted from creating new appointments (thanks to the AllowCreation declaration).
Available Overrides
| JavaScript Variables |
Brief Description |
| WhereClause |
An SQL 'WHERE' clause which allows you to specify the calendar found set. This can be useful if you need a complicated set of match criteria. |
| CreationValues |
A slice of SQL 'UPDATE' clause which allows you to specify the default values to set in a field when used in conjunction with 'CreationFields'. This is useful if you want to automatically populate some data each time you create a record. |
| CreationFields |
A slice of SQL 'UPDATE' clause which allows you to specify the fields to set when used in conjunction with 'CreationValues'. This is useful if you want to automatically populate some data each time you create a record. |
| AllowCreation |
Let the user create new records using the Day Calendar ( Default: true ) |
| AllowEdits |
Let the user edit records using the Day Calendar ( Default: true ) |
| AllowDeletes |
Let the user delete records using the Day Calendar ( Default: true ) |
| AllowDeselect |
Let the user deselect records using the Day Calendar ( Default: true ) |
| ScriptOnDelete |
A script to run on delete. Uses parameter defined in ActionOnSelect (or the FileMaker record ID if none is provided). |
| CreationMethod |
How you allow the user to create records ( Default: 'drag' ) |
| AppointmentColour |
The default colour of appointments when the appointment doesn't have a colour set in its colour field, or the colour field is not used ( Default: '#5588bb' ) |
| StartCalendarHours |
The time of day that the Day Calendar will start drawing hour blocks ( Default: '00:00:00' ) |
| EndCalendarHours |
The time of day that the Day Calendar will stop drawing hour blocks ( Default: '24:00:00' ) |
| StartWorkHours |
The time of day that the Day Calendar will stop drawing its darker highlight colour representing non-work hours ( Default: '08:00:00' ) |
| EndWorkHours |
The time of day that the Day Calendar will re-start drawing its darker highlight colour representing non-work hours ( Default: '18:00:00' ) |
| datelineOrientation |
The position of the horizontal bar which contains the date labels ( Default: 'bottom' ) |
| timelineOrientation |
The position of the vartical bar which contains the hour labels ( Default: 'left' ) |
| timelineWidth |
The width of the blue bar which contains the hour labels ( Default: 80 ) |
| DragPrecision |
The precision in minutes used when dragging and creating appointments ( Default: 15 ) |
| MinHourHeight |
The smallest height that a single half hour block will shrink to ( Default: 24 ) |
| MinDayWidth |
The smallest width that a single day block will shrink to ( Default: 95 ) |
| DefaultScrollSpeed |
The maximum scroll speed when holding down the button ( Default: 15 ) |
| ScrollPercent |
The starting scroll position ( Default: 0.575 ) |
| ScrollDay |
The number of the day that is scrolled to when the calendar loads ( Default: 0 ) |
| AppointmentOpacity |
The standard opacity of a normal appointment ( Default: 1 ) |
| OverlapOpacity |
The opacity of bookings which are overlapping ( Default: .8 ) |
| DragOpacity |
The opacity of bookings while they are being dragged ( Default: .5 ) |
| isPollActive |
Allow polling of the data in the appointment table for automatic updating of the Day Calendar if records are changed ( Default: true ) |
| isDebugPoll |
If set to true, will provide debugging feedback of polling ( Default: false ) |
| DefaultPosSpeed |
Animation speed of default/drag positioning of elements. ( Default: 50 ) |
| PollPosSpeed |
Animation speed of poll update positioning of elements. ( Default: 300 ) |
| RecolourSpeed |
Animation speed of colour changes in elements. ( Default: 2500 ) |
| SelectSpeed |
Speed of appointment select animation. ( Default: 300 ) |
| DragOpacitySpeed |
Speed of fade on drag animation. ( Default: 500 ) |
You can provide your own manually crafted WhereClause thus accessing much more powerful filtering capabilities and avoiding the need to even use a relationship on the graph at all.
The 'WHERE' clause is part of an SQL statement and needs to be written and formatted accordingly.
Examples are to be provided here.
Refer to the FileMaker odbc/jdbc documentation for more details on how to structure this where clause, otherwise use the default functionality.
This should be a snippet of SQL which is able to be passed directly to the INSERT statement. It should begin with a comma, and list any values in escaped SQL values list for use directly in the record create query. The below would set the values '1' and '2' into the fields defined in Creation Fields. A similar effect may be achieved by using auto enter values, although remember you can use field references and SQL calculations here.
This should be a snippet of SQL which is able to be passed directly to the INSERT statement. As with CreationValues, it should begin with a comma and list any field names in an escaped SQL values list for use directly in the record create query. If used in conjunction with the creation values variable above, '1' would be set into the field "my_field1", and '2' would be set into the field "my_field2" upon record creation.
Note: You may need to escape quotation marks in your JavaScript, depending on the type of encasing quotation marks you have used.
E.g: , "my_field1", "my_field2"
A simple on/off toggle for allowing users to create records, or not. If set to 'true' the user may create records. If set to 'false', the user won't be able to create records using the Day Cal.
Default: true
A simple on/off toggle for allowing users to edit records, or not. If set to 'true' the user may drag, resize or otherwise change records within the Day Cal. If set to 'false', the user won't be able to edit records using the Day Cal.
Default: true
A simple on/off toggle for allowing users to delete records, or not. If set to 'true' the user may delete records. If set to 'false', the user won't be able to delete records using the Day Cal.
Default: true
A number value which determines the accuracy of appointment drag placement. Set in minutes, a value of 15 will allow the user to create or move an appointment to 15 minute accuracy. If set to 1, the user will be able to create, move or resize an appointment to 1 minute accuracy.
Unit: Minutes
A time from when the calendar will start drawing. If we set StartCalendarHours to '08:00:00' we would see that the calendar won't render the hours from midnight till 8am. This time should be in 24 hour format (HH:MM:SS).
Unit: Time
Default: 00:00:00
A time until which the calendar will draw. If we set EndCalendarHours to '20:00:00' we would see that the calendar won't render the hours from 8pm till midnight. This time should be in 24 hour format (HH:MM:SS).
Unit: Time
Default: 24:00:00
Similar to
StartCalendarHours above, only this sets the time at which to STOP displaying the shaded 'non-work' blocks. The non-work blocks will display from StartCalendarHours until the time specified in StartWorkHours. If you don't want the non-work blocks to appear, simply set this value to the same or less than StartCalendarHours. This time should be in 24 hour format (HH:MM:SS).
Note: This only takes effect for weekdays. Weekends will alwasy be classed as non-work.
Unit: Time
Default: 08:00:00
Similar to
EndCalendarHours above, only this sets the time at which to RE-START displaying the shaded 'non-work' blocks. The non-work blocks will display from EndWorkHours until the time specified in EndCalendarHours. If you don't want the non-work blocks to appear, simply set this value to the same or greater than EndCalendarHours. This time should be in 24 hour format (HH:MM:SS).
Note: This only takes effect for weekdays. Weekends will alwasy be classed as non-work.
Unit: Time
Default: 08:00:00
Allows you to change the position of the horizontal 'dateline' which contains the date labels. The values you can use are as follows.
Reactor Implementation Guide
Comments