MBS FileMaker Plugin Example Databases

Calendar Events

All examples are included with download of MBS FileMaker Plugin.

Calendar Events.fmp12

Overview
Tables3
Relationships2
Layouts3
Scripts1
Value Lists0
Custom Functions1
Custom Menus33
File Options
Default custom menu set[Standard FileMaker Menus]
When opening file
Minimum allowed version12.0
Login usingAccount Name; Account= Admin
Allow user to save passwordOff
Require iOS passcodeOff
Switch to layoutOff
Hide all toolbarsOff
Script triggers
OnFirstWindowOpenOff
OnLastWindowCloseOff
OnWindowOpenOff
OnWindowCloseOff
OnFileAVPlayerChangeOff
Thumbnail Settings
Generate ThumbnailsOn; 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 NameTypeOptionsCommentsOn LayoutsIn RelationshipsIn ScriptsIn Value Lists
isAllDayNormal, TextAuto-Enter:
  • Allow editing
Validation:
  • Only during data entry
Storage:
  • Repetitions: 1
  • Indexing: None
  • Automatically create indexes as needed
  • Index Language: German
      locationNormal, TextAuto-Enter:
      • Allow editing
      Validation:
      • Only during data entry
      Storage:
      • Repetitions: 1
      • Indexing: None
      • Automatically create indexes as needed
      • Index Language: German
          startDateNormal, TimestampAuto-Enter:
          • Allow editing
          Validation:
          • Only during data entry
          Storage:
          • Repetitions: 1
          • Indexing: None
          • Automatically create indexes as needed
          • Index Language: German
              endDateNormal, TimestampAuto-Enter:
              • Allow editing
              Validation:
              • Only during data entry
              Storage:
              • Repetitions: 1
              • Indexing: None
              • Automatically create indexes as needed
              • Index Language: German
                  isDetachedNormal, TextAuto-Enter:
                  • Allow editing
                  Validation:
                  • Only during data entry
                  Storage:
                  • Repetitions: 1
                  • Indexing: None
                  • Automatically create indexes as needed
                  • Index Language: German
                      occurrenceNormal, TimestampAuto-Enter:
                      • Allow editing
                      Validation:
                      • Only during data entry
                      Storage:
                      • Repetitions: 1
                      • Indexing: None
                      • Automatically create indexes as needed
                      • Index Language: German
                          calendarNormal, TextAuto-Enter:
                          • Allow editing
                          Validation:
                          • Only during data entry
                          Storage:
                          • Repetitions: 1
                          • Indexing: None
                          • Automatically create indexes as needed
                          • Index Language: German
                              notesNormal, TextAuto-Enter:
                              • Allow editing
                              Validation:
                              • Only during data entry
                              Storage:
                              • Repetitions: 1
                              • Indexing: None
                              • Automatically create indexes as needed
                              • Index Language: German
                                  urlNormal, TextAuto-Enter:
                                  • Allow editing
                                  Validation:
                                  • Only during data entry
                                  Storage:
                                  • Repetitions: 1
                                  • Indexing: None
                                  • Automatically create indexes as needed
                                  • Index Language: German
                                      titleNormal, TextAuto-Enter:
                                      • Allow editing
                                      Validation:
                                      • Only during data entry
                                      Storage:
                                      • Repetitions: 1
                                      • Indexing: None
                                      • Automatically create indexes as needed
                                      • Index Language: German
                                          uidNormal, TextAuto-Enter:
                                          • Allow editing
                                          Validation:
                                          • Only during data entry
                                          Storage:
                                          • Repetitions: 1
                                          • Indexing: None
                                          • Automatically create indexes as needed
                                          • Index Language: German
                                              dateStampNormal, TimestampAuto-Enter:
                                              • Allow editing
                                              Validation:
                                              • Only during data entry
                                              Storage:
                                              • Repetitions: 1
                                              • Indexing: None
                                              • Automatically create indexes as needed
                                              • Index Language: German

                                                  Table Name: Attendee - 4 Fields
                                                  Field NameTypeOptionsCommentsOn LayoutsIn RelationshipsIn ScriptsIn Value Lists
                                                  addressNormal, TextAuto-Enter:
                                                  • Allow editing
                                                  Validation:
                                                  • Only during data entry
                                                  Storage:
                                                  • Repetitions: 1
                                                  • Indexing: None
                                                  • Automatically create indexes as needed
                                                  • Index Language: German
                                                      commonNameNormal, TextAuto-Enter:
                                                      • Allow editing
                                                      Validation:
                                                      • Only during data entry
                                                      Storage:
                                                      • Repetitions: 1
                                                      • Indexing: None
                                                      • Automatically create indexes as needed
                                                      • Index Language: German
                                                          statusNormal, TextAuto-Enter:
                                                          • Allow editing
                                                          Validation:
                                                          • Only during data entry
                                                          Storage:
                                                          • Repetitions: 1
                                                          • Indexing: None
                                                          • Automatically create indexes as needed
                                                          • Index Language: German
                                                              EventIDNormal, TextAuto-Enter:
                                                              • Allow editing
                                                              Validation:
                                                              • Only during data entry
                                                              Storage:
                                                              • Repetitions: 1
                                                              • Indexing: Minimal
                                                              • Automatically create indexes as needed
                                                              • Index Language: German

                                                                  Table Name: Alarm - 9 Fields
                                                                  Field NameTypeOptionsCommentsOn LayoutsIn RelationshipsIn ScriptsIn Value Lists
                                                                  actionNormal, TextAuto-Enter:
                                                                  • Allow editing
                                                                  Validation:
                                                                  • Only during data entry
                                                                  Storage:
                                                                  • Repetitions: 1
                                                                  • Indexing: None
                                                                  • Automatically create indexes as needed
                                                                  • Index Language: German
                                                                      soundNormal, TextAuto-Enter:
                                                                      • Allow editing
                                                                      Validation:
                                                                      • Only during data entry
                                                                      Storage:
                                                                      • Repetitions: 1
                                                                      • Indexing: None
                                                                      • Automatically create indexes as needed
                                                                      • Index Language: German
                                                                          emailAddressNormal, TextAuto-Enter:
                                                                          • Allow editing
                                                                          Validation:
                                                                          • Only during data entry
                                                                          Storage:
                                                                          • Repetitions: 1
                                                                          • Indexing: None
                                                                          • Automatically create indexes as needed
                                                                          • Index Language: German
                                                                              urlNormal, TextAuto-Enter:
                                                                              • Allow editing
                                                                              Validation:
                                                                              • Only during data entry
                                                                              Storage:
                                                                              • Repetitions: 1
                                                                              • Indexing: None
                                                                              • Automatically create indexes as needed
                                                                              • Index Language: German
                                                                                  relativeTriggerNormal, NumberAuto-Enter:
                                                                                  • Allow editing
                                                                                  Validation:
                                                                                  • Only during data entry
                                                                                  Storage:
                                                                                  • Repetitions: 1
                                                                                  • Indexing: None
                                                                                  • Automatically create indexes as needed
                                                                                  • Index Language: German
                                                                                      absoluteTriggerNormal, TimestampAuto-Enter:
                                                                                      • Allow editing
                                                                                      Validation:
                                                                                      • Only during data entry
                                                                                      Storage:
                                                                                      • Repetitions: 1
                                                                                      • Indexing: None
                                                                                      • Automatically create indexes as needed
                                                                                      • Index Language: German
                                                                                          EventIDNormal, TextAuto-Enter:
                                                                                          • Allow editing
                                                                                          Validation:
                                                                                          • Only during data entry
                                                                                          Storage:
                                                                                          • Repetitions: 1
                                                                                          • Indexing: Minimal
                                                                                          • Automatically create indexes as needed
                                                                                          • Index Language: German
                                                                                              infoNormal, TextAuto-Enter: Validation:
                                                                                              • Only during data entry
                                                                                              Storage:
                                                                                              • Repetitions: 1
                                                                                              • Indexing: None
                                                                                              • Automatically create indexes as needed
                                                                                              • Index Language: German
                                                                                                    timeTiggerNormal, TextAuto-Enter: Validation:
                                                                                                    • Only during data entry
                                                                                                    Storage:
                                                                                                    • Repetitions: 1
                                                                                                    • Indexing: None
                                                                                                    • Automatically create indexes as needed
                                                                                                    • Index Language: German

                                                                                                          Relationship: Events=Alarm

                                                                                                          Table OccurrenceEventsAlarm
                                                                                                          Fielduid=EventID
                                                                                                          Source TableEventsAlarm
                                                                                                          Source FileCalendar Events.fmp12Calendar Events.fmp12
                                                                                                          Allow creation of records via this relationshipOffOn
                                                                                                          Delete related records in this table when a record is deleted in the other tableOffOn
                                                                                                          Sort records

                                                                                                          Off

                                                                                                          Off

                                                                                                          Layouts

                                                                                                          Layout Hierarchy

                                                                                                          Events
                                                                                                          Attendee
                                                                                                          Alarm


                                                                                                          Layout NameInclude In MenuQuick Find# of ObjectsShow Records FromSave record changes automaticallyShow field frames when record is activeShow field frames only on current recordShow current record indicator in List ViewUsed in ScriptsCustom Menu SetScript TriggersTheme ID
                                                                                                          EventsYesYes EventsOnOnOffOn[File Default]01
                                                                                                          AttendeeYesYes AttendeeOnOnOffOn[File Default]01
                                                                                                          AlarmYesYes AlarmOnOnOffOn[File Default]01

                                                                                                          Layout Objects: Events

                                                                                                          Regular Fields

                                                                                                          Field Name: Events::isAllDay
                                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                          • 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
                                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                          • 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
                                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                          • 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
                                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                          • 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
                                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                          • 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
                                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                          • 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
                                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                          • 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
                                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                          • 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
                                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                          • 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
                                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                          • 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
                                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                          • 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
                                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                          • 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
                                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                          • 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
                                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                          • 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
                                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                          • 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
                                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                          • 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
                                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                          • 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
                                                                                                          Yes

                                                                                                          Group Buttons

                                                                                                          Button PropertiesCoordinatesScript/Script Step
                                                                                                            Type:
                                                                                                          • Text: Import 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:


                                                                                                          Portals

                                                                                                          Portal PropertiesCoordinatesFieldsOptions
                                                                                                          • Top: 66 pt
                                                                                                          • Left: 408 pt
                                                                                                          • Bottom: 293 pt
                                                                                                          • Right: 727 pt
                                                                                                          • Anchoring: Left, Top
                                                                                                          Field Objects
                                                                                                          • Sort records: Off
                                                                                                          • Filter calculation: None
                                                                                                          • Initial Row: 1
                                                                                                          • Number of Rows: 13

                                                                                                          Portal PropertiesCoordinatesFieldsOptions
                                                                                                          • Top: 66 pt
                                                                                                          • Left: 732 pt
                                                                                                          • Bottom: 293 pt
                                                                                                          • Right: 1063 pt
                                                                                                          • Anchoring: Left, Top
                                                                                                          Field Objects
                                                                                                          • Sort records: Off
                                                                                                          • Filter calculation: None
                                                                                                          • Initial Row: 1
                                                                                                          • Number of Rows: 13

                                                                                                          Layout Objects: Attendee

                                                                                                          Regular Fields

                                                                                                          Field Name: Attendee::address
                                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                          • 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
                                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                          • 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
                                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                          • 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
                                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                          • 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
                                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                          • 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
                                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                          • 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
                                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                          • 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
                                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                          • 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
                                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                          • 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 NameImport
                                                                                                          Run script with full access privilegesOff
                                                                                                          Include In MenuYes
                                                                                                          Layouts that use this script
                                                                                                          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
                                                                                                            Scripts used in this script
                                                                                                              Layouts used in this script
                                                                                                                Tables used in this script
                                                                                                                Table occurrences used by this script
                                                                                                                Custom Functions used by this script
                                                                                                                Custom menu set used by this script

                                                                                                                  Custom Functions

                                                                                                                  Function NameParametersAvailabilityDefinitionIn Field DefinitionsIn Scripts
                                                                                                                  YesNovalueAll accountsIf ( value = 1 ; "yes" ; If ( value = 0 ; "no" ; value ) )

                                                                                                                    Custom Menu Sets

                                                                                                                    Menu SetsMenusIn ScriptsIn LayoutsComments
                                                                                                                    [Standard FileMaker Menus]
                                                                                                                    • All Standard Menus
                                                                                                                    Angepasstes Menüset 1

                                                                                                                    Download example: Calendar Events

                                                                                                                    Used functions:




                                                                                                                    Links
                                                                                                                    MBS Xojo PDF Plugins