Monkeybread Software - MBS FileMaker Plugin: Calendar Events

Components	All	New	MacOS		Windows		Linux		iOS
Examples	Mac & Win		Server	Client	Guides	Statistic	FMM	Blog	Deprecated	Old

MBS FileMaker Plugin Example Databases

Calendar Events

All examples are included with download of MBS FileMaker Plugin.

Calendar Events.fmp12

Overview
Tables	3
Relationships	2
Layouts	3
Scripts	1
Value Lists	0
Custom Functions	1
Custom Menus	33

File Options
Default custom menu set	[Standard FileMaker Menus]
When opening file
Minimum allowed version	12.0
Login using	Account Name; Account= Admin
Allow user to save password	Off
Require iOS passcode	Off
Switch to layout	Off
Hide all toolbars	Off
Script triggers
OnFirstWindowOpen	Off
OnLastWindowClose	Off
OnWindowOpen	Off
OnWindowClose	Off
OnFileAVPlayerChange	Off
Thumbnail Settings
Generate Thumbnails	On; Temporary

Tables

Table Name	Statistics	Occurrences in Relationship Graph
Events	12 fields defined, 0 record	Events
Attendee	4 fields defined, 0 record	Attendee
Alarm	9 fields defined, 0 record	Alarm

Fields

Table Name: Events - 12 Fields
Field Name	Type	Options	Comments	On Layouts	In Relationships	In Scripts	In Value Lists
isAllDay	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Events		Import
location	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Events		Import
startDate	Normal, Timestamp	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Events		Import
endDate	Normal, Timestamp	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Events		Import
isDetached	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Events		Import
occurrence	Normal, Timestamp	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Events		Import
calendar	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Events		Import
notes	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Events		Import
url	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Events		Import
title	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Events		Import
uid	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German			Events=Attendee Events=Alarm	Import
dateStamp	Normal, Timestamp	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Events		Import

Table Name: Attendee - 4 Fields
Field Name	Type	Options	Comments	On Layouts	In Relationships	In Scripts	In Value Lists
address	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Events Attendee		Import
commonName	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Events Attendee		Import
status	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Events Attendee		Import
EventID	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: Minimal Automatically create indexes as needed Index Language: German			Events=Attendee	Import

Table Name: Alarm - 9 Fields
Field Name	Type	Options	Comments	On Layouts	In Relationships	In Scripts	In Value Lists
action	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Events Alarm		Import
sound	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Alarm		Import
emailAddress	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Alarm		Import
url	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Alarm		Import
relativeTrigger	Normal, Number	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Alarm		Import
absoluteTrigger	Normal, Timestamp	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Alarm		Import
EventID	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: Minimal Automatically create indexes as needed Index Language: German			Events=Alarm	Import
info	Normal, Text	Auto-Enter: Allow editing Context table: Alarm Calculation: Alarm::sound & Alarm::emailAddress & Alarm::url // normally only one is set Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Events
timeTigger	Normal, Text	Auto-Enter: Allow editing Context table: Alarm Calculation: If(GetAsNumber(Alarm::relativeTrigger) ≠ 0; GetAsText (Alarm::relativeTrigger) & " seconds"; GetAsText(Alarm::absoluteTrigger)) Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Events

Relationship: Events=Alarm

Table Occurrence	Events		Alarm
Field	uid	=	EventID
Source Table	Events		Alarm
Source File	Calendar Events.fmp12		Calendar Events.fmp12
Allow creation of records via this relationship	Off		On
Delete related records in this table when a record is deleted in the other table	Off		On
Sort records	Off		Off

Layout Hierarchy

Save record changes automatically

Show field frames when record is active

Show field frames only on current record

Show current record indicator in List View

17 Regular Fields
1 Group Buttons
2 Portals

Events

3 Regular Fields

6 Regular Fields

Alarm

Off

[File Default]

Layout Objects: Events

Regular Fields

Field Name: Events::isAllDay

Layout Name:

Events

Top: 192 pt
Left: 138 pt
Bottom: 206 pt
Right: 391 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: System Default
Go to next field using: Tab key

Yes

Field Name: Events::location

Layout Name:

Events

Top: 84 pt
Left: 138 pt
Bottom: 98 pt
Right: 391 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: System Default
Go to next field using: Tab key

Yes

Field Name: Events::startDate

Layout Name:

Events

Top: 102 pt
Left: 138 pt
Bottom: 116 pt
Right: 391 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: System Default
Go to next field using: Tab key

Yes

Field Name: Events::endDate

Layout Name:

Events

Top: 120 pt
Left: 138 pt
Bottom: 134 pt
Right: 391 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: System Default
Go to next field using: Tab key

Yes

Field Name: Events::isDetached

Layout Name:

Events

Top: 138 pt
Left: 138 pt
Bottom: 152 pt
Right: 391 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: System Default
Go to next field using: Tab key

Yes

Field Name: Events::occurrence

Layout Name:

Events

Top: 156 pt
Left: 138 pt
Bottom: 170 pt
Right: 391 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: System Default
Go to next field using: Tab key

Yes

Field Name: Events::calendar

Layout Name:

Events

Top: 174 pt
Left: 138 pt
Bottom: 188 pt
Right: 391 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: System Default
Go to next field using: Tab key

Yes

Field Name: Events::notes

Layout Name:

Events

Top: 210 pt
Left: 138 pt
Bottom: 266 pt
Right: 391 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: System Default
Go to next field using: Tab key

Yes

Field Name: Events::url

Layout Name:

Events

Top: 270 pt
Left: 138 pt
Bottom: 284 pt
Right: 391 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: System Default
Go to next field using: Tab key

Yes

Field Name: Events::title

Layout Name:

Events

Top: 66 pt
Left: 138 pt
Bottom: 80 pt
Right: 391 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: System Default
Go to next field using: Tab key

Yes

Field Name: Events::dateStamp

Layout Name:

Events

Top: 288 pt
Left: 138 pt
Bottom: 302 pt
Right: 391 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: System Default
Go to next field using: Tab key

Yes

Field Name: Alarm::action

Layout Name:

Events

Top: 67 pt
Left: 409 pt
Bottom: 82 pt
Right: 473 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: System Default
Go to next field using: Tab key

Yes

Field Name: Alarm::info

Layout Name:

Events

Top: 67 pt
Left: 474 pt
Bottom: 82 pt
Right: 604 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: System Default
Go to next field using: Tab key

Yes

Field Name: Alarm::timeTigger

Layout Name:

Events

Top: 67 pt
Left: 605 pt
Bottom: 82 pt
Right: 723 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: System Default
Go to next field using: Tab key

Yes

Field Name: Attendee::address

Layout Name:

Events

Top: 67 pt
Left: 733 pt
Bottom: 82 pt
Right: 842 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: System Default
Go to next field using: Tab key

Yes

Field Name: Attendee::commonName

Layout Name:

Events

Top: 67 pt
Left: 843 pt
Bottom: 82 pt
Right: 951 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: System Default
Go to next field using: Tab key

Yes

Field Name: Attendee::status

Layout Name:

Events

Top: 67 pt
Left: 952 pt
Bottom: 82 pt
Right: 1061 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: System Default
Go to next field using: Tab key

Type:

Text: Import events

Layout Name:

Events

Additional Properties:

Change to hand cursor over button
Rectangular

Top: 12 pt
Left: 18 pt
Bottom: 37 pt
Right: 163 pt

Anchoring: Left, Top

Perform Script [ “Import” ]

Scripts:

Import

Table:

Alarm

Layout Name:

Events

Top: 66 pt
Left: 408 pt
Bottom: 293 pt
Right: 727 pt

Anchoring: Left, Top

Field Objects

Alarm::action at (67, 409, 82, 473)
Alarm::info at (67, 474, 82, 604)
Alarm::timeTigger at (67, 605, 82, 723)

Sort records: Off
Filter calculation: None
Initial Row: 1
Number of Rows: 13

Table:

Attendee

Layout Name:

Events

Top: 66 pt
Left: 732 pt
Bottom: 293 pt
Right: 1063 pt

Anchoring: Left, Top

Field Objects

Attendee::address at (67, 733, 82, 842)
Attendee::commonName at (67, 843, 82, 951)
Attendee::status at (67, 952, 82, 1061)

Sort records: Off
Filter calculation: None
Initial Row: 1
Number of Rows: 13

Layout Objects: Attendee

Regular Fields

Field Name: Attendee::address

Layout Name:

Attendee

Top: 24 pt
Left: 138 pt
Bottom: 38 pt
Right: 391 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: System Default
Go to next field using: Tab key

Yes

Field Name: Attendee::commonName

Layout Name:

Attendee

Top: 42 pt
Left: 138 pt
Bottom: 56 pt
Right: 391 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: System Default
Go to next field using: Tab key

Yes

Field Name: Attendee::status

Layout Name:

Attendee

Top: 60 pt
Left: 138 pt
Bottom: 74 pt
Right: 391 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: System Default
Go to next field using: Tab key

Yes

Layout Objects: Alarm

Regular Fields

Field Name: Alarm::action

Layout Name:

Alarm

Top: 24 pt
Left: 138 pt
Bottom: 38 pt
Right: 391 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: System Default
Go to next field using: Tab key

Yes

Field Name: Alarm::sound

Layout Name:

Alarm

Top: 42 pt
Left: 138 pt
Bottom: 56 pt
Right: 391 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: System Default
Go to next field using: Tab key

Yes

Field Name: Alarm::emailAddress

Layout Name:

Alarm

Top: 60 pt
Left: 138 pt
Bottom: 74 pt
Right: 391 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: System Default
Go to next field using: Tab key

Yes

Field Name: Alarm::url

Layout Name:

Alarm

Top: 78 pt
Left: 138 pt
Bottom: 92 pt
Right: 391 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: System Default
Go to next field using: Tab key

Yes

Field Name: Alarm::relativeTrigger

Layout Name:

Alarm

Top: 96 pt
Left: 138 pt
Bottom: 110 pt
Right: 217 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: System Default
Go to next field using: Tab key

Yes

Field Name: Alarm::absoluteTrigger

Layout Name:

Alarm

Top: 114 pt
Left: 138 pt
Bottom: 128 pt
Right: 259 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: System Default
Go to next field using: Tab key

Yes

Script Hierarchy

Import

Script Name	Import
Run script with full access privileges	Off
Include In Menu	Yes
Layouts that use this script	Events
Scripts that use this script
Script Definition
Script Steps	#Clear Tables Delete All Records [ No dialog ] #Find Time Stamps for beginning of current month and next month Set Variable [ $currentTimeStamp; Value:Get ( CurrentHostTimestamp ) ] Set Variable [ $startDate; Value:Date( Month($currentTimeStamp); 1; Year($currentTimeStamp)) ] Set Variable [ $endDate; Value:Date(Month($currentTimeStamp)+1; 1; Year($currentTimeStamp)) ] #get events between Set Variable [ $Events; Value:MBS( "Calendar.Events"; $StartDate;$EndDate ) ] If [ MBS("IsError") or Length($Events) < 1 ] Exit Script [ ] End If #Now loop over all items Set Variable [ $count; Value:ValueCount ( $events ) ] If [ $count > 0 ] Set Variable [ $index; Value:0 ] Loop #get this item Set Variable [ $id; Value:GetValue ( $Events ; $index+1 ) ] New Record/Request Set Field [ Events::isAllDay; YesNo(MBS( "Calendar.Item.GetAllDay"; $id )) ] Set Field [ Events::location; MBS( "Calendar.Item.GetLocation"; $id ) ] Set Field [ Events::startDate; MBS( "Calendar.Item.GetStartDate"; $id ) ] Set Field [ Events::endDate; MBS( "Calendar.Item.GetEndDate"; $id ) ] Set Field [ Events::isDetached; YesNo(MBS( "Calendar.Item.IsDetached"; $id )) ] Set Field [ Events::occurrence; MBS( "Calendar.Item.Occurrence"; $id ) ] Set Variable [ $calendar; Value:MBS( "Calendar.Item.GetCalendar"; $id ) ] Set Field [ Events::calendar; MBS( "Calendar.Calendar.GetTitle"; $Calendar ) ] Set Field [ Events::notes; MBS( "Calendar.Item.GetNotes"; $id ) ] Set Field [ Events::url; MBS( "Calendar.Item.GetURL"; $id ) ] Set Field [ Events::title; MBS( "Calendar.Item.GetTitle"; $id ) ] Set Variable [ $uid; Value:MBS( "Calendar.Item.GetUID"; $id ) ] Set Field [ Events::uid; $uid ] Set Field [ Events::dateStamp; MBS( "Calendar.Item.GetDateStamp"; $id ) ] Commit Records/Requests [ No dialog ] #Now Alarms Set Variable [ $alarms; Value:MBS( "Calendar.Item.GetAlarms"; $id ) ] Set Variable [ $alarmCount; Value:ValueCount ( $alarms ) ] If [ $alarmCount > 0 ] Set Variable [ $alarmIndex; Value:0 ] Loop #get this alarm Set Variable [ $alarm; Value:GetValue ( $Alarms ; $alarmindex+1 ) ] Set Variable [ $action; Value:MBS( "Calendar.Alarm.GetAction"; $alarm ) ] If [ $action ≠ "NONE" ] Set Field [ Alarm::action; $action ] Set Field [ Alarm::sound; MBS( "Calendar.Alarm.GetSound"; $alarm ) ] Set Field [ Alarm::emailAddress; MBS( "Calendar.Alarm.GetEmailaddress"; $alarm ) ] Set Field [ Alarm::url; MBS( "Calendar.Alarm.GetURL"; $alarm ) ] Set Field [ Alarm::relativeTrigger; MBS( "Calendar.Alarm.GetRelativeTrigger"; $alarm ) ] Set Field [ Alarm::absoluteTrigger; MBS( "Calendar.Alarm.GetAbsoluteTrigger"; $alarm ) ] Set Field [ Alarm::EventID; $uid ] Commit Records/Requests [ No dialog ] End If #next item Set Variable [ $alarmIndex; Value:$alarmIndex + 1 ] Exit Loop If [ $alarmIndex = $alarmCount ] End Loop End If #Now Attendees Set Variable [ $attendees; Value:MBS( "Calendar.Item.GetAttendees"; $id ) ] Set Variable [ $attendeeCount; Value:ValueCount ( $attendees ) ] If [ $attendeeCount > 0 ] Set Variable [ $attendeeIndex; Value:0 ] Loop #get this alarm Set Variable [ $attendee; Value:GetValue ( $attendees ; $attendeeindex+1 ) ] Set Field [ Attendee::address; MBS( "Calendar.Attendee.GetAddress"; $attendee ) ] Set Field [ Attendee::commonName; MBS( "Calendar.Attendee.GetCommonName"; $attendee ) ] Set Field [ Attendee::status; MBS( "Calendar.Attendee.GetStatus"; $attendee ) ] Set Field [ Attendee::EventID; $uid ] Commit Records/Requests [ No dialog ] #next item Set Variable [ $attendeeIndex; Value:$attendeeIndex + 1 ] Exit Loop If [ $attendeeIndex = $attendeeCount ] End Loop End If #next item Set Variable [ $index; Value:$index + 1 ] Exit Loop If [ $index = $count ] End Loop End If
Fields used in this script	Events::isAllDay Events::location Events::startDate Events::endDate Events::isDetached Events::occurrence Events::calendar Events::notes Events::url Events::title Events::uid Events::dateStamp Alarm::action Alarm::sound Alarm::emailAddress Alarm::url Alarm::relativeTrigger Alarm::absoluteTrigger Alarm::EventID Attendee::address Attendee::commonName Attendee::status Attendee::EventID
Scripts used in this script
Layouts used in this script
Tables used in this script	Alarm Attendee Events
Table occurrences used by this script	Alarm Attendee Events
Custom Functions used by this script	YesNo
Custom menu set used by this script

Custom Functions

Function Name	Parameters	Availability	Definition	In Field Definitions	In Scripts
YesNo	value	All accounts	If ( value = 1 ; "yes" ; If ( value = 0 ; "no" ; value ) )		Import

Custom Menu Sets

Menu Sets	Menus	In Scripts	In Layouts	Comments
[Standard FileMaker Menus]	All Standard Menus
Angepasstes Menüset 1	FileMaker Pro Kopie Ablage Kopie Bearbeiten Kopie Ansicht Kopie Einfügen Kopie [Format] Abfragen Kopie Datensätze Kopie [Scripts] [Fenster] Hilfe Kopie

Download example: Calendar Events

Used functions: