MBS FileMaker Plugin Example Databases

Events Create Reminder

All examples are included with download of MBS FileMaker Plugin.

Events Create Reminder.fmp12

Overview
Tables1
Relationships0
Layouts1
Scripts3
Value Lists0
Custom Functions0
Custom Menus0
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 Create Reminder
15 fields defined, 1 record
Events Create Reminder

Fields

Table Name: Events Create Reminder - 15 Fields
Field NameTypeOptionsCommentsOn LayoutsIn RelationshipsIn ScriptsIn Value Lists
CalendarNormal, TextAuto-Enter:
  • Allow editing
Validation:
  • Only during data entry
Storage:
  • Repetitions: 1
  • Indexing: None
  • Automatically create indexes as needed
  • Index Language: German
      PriorityNormal, 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
              DueDateNormal, TimestampAuto-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
                      TimeZoneNormal, 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
                              URLNormal, TextAuto-Enter:
                              • Allow editing
                              Validation:
                              • Only during data entry
                              Storage:
                              • Repetitions: 1
                              • Indexing: None
                              • Automatically create indexes as needed
                              • Index Language: German
                                  AlarmSoundNormal, TextAuto-Enter:
                                  • Allow editing
                                  Validation:
                                  • Only during data entry
                                  Storage:
                                  • Repetitions: 1
                                  • Indexing: None
                                  • Automatically create indexes as needed
                                  • Index Language: German
                                      AlarmProximityNormal, TextAuto-Enter:
                                      • Allow editing
                                      Validation:
                                      • Only during data entry
                                      Storage:
                                      • Repetitions: 1
                                      • Indexing: None
                                      • Automatically create indexes as needed
                                      • Index Language: German
                                          AlarmLocationTitleNormal, TextAuto-Enter:
                                          • Allow editing
                                          Validation:
                                          • Only during data entry
                                          Storage:
                                          • Repetitions: 1
                                          • Indexing: None
                                          • Automatically create indexes as needed
                                          • Index Language: German
                                              AlarmLocationGeoLatNormal, TextAuto-Enter:
                                              • Allow editing
                                              Validation:
                                              • Only during data entry
                                              Storage:
                                              • Repetitions: 1
                                              • Indexing: None
                                              • Automatically create indexes as needed
                                              • Index Language: German
                                                  AlarmLocationGeoLongNormal, 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
                                                          AlarmLocationRadiusNormal, TextAuto-Enter:
                                                          • Allow editing
                                                          Validation:
                                                          • Only during data entry
                                                          Storage:
                                                          • Repetitions: 1
                                                          • Indexing: None
                                                          • Automatically create indexes as needed
                                                          • Index Language: German

                                                              Layout Objects: Events Create Reminder

                                                              Regular Fields

                                                              Field Name: Events Create Reminder::Calendar
                                                              Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                              • Top: 60 pt
                                                              • Left: 160 pt
                                                              • Bottom: 81 pt
                                                              • Right: 413 pt
                                                              • Anchoring: Left, Top
                                                              Field Format:
                                                              • Edit Box
                                                              Field Behavior:
                                                              • Allow field to be entered: In Find mode, In Browse mode
                                                              • Touch keyboard type: Default for Data Type
                                                              • Go to next field using: Tab key
                                                              Yes

                                                              Field Name: Events Create Reminder::Priority
                                                              Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                              • Top: 83 pt
                                                              • Left: 160 pt
                                                              • Bottom: 104 pt
                                                              • Right: 413 pt
                                                              • Anchoring: Left, Top
                                                              Field Format:
                                                              • Edit Box
                                                              Field Behavior:
                                                              • Allow field to be entered: In Find mode, In Browse mode
                                                              • Touch keyboard type: Default for Data Type
                                                              • Go to next field using: Tab key
                                                              Yes

                                                              Field Name: Events Create Reminder::StartDate
                                                              Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                              • Top: 106 pt
                                                              • Left: 160 pt
                                                              • Bottom: 127 pt
                                                              • Right: 401 pt
                                                              • Anchoring: Left, Top
                                                              Field Format:
                                                              • Edit Box
                                                              Field Behavior:
                                                              • Allow field to be entered: In Find mode, In Browse mode
                                                              • Touch keyboard type: Default for Data Type
                                                              • Go to next field using: Tab key
                                                              Yes

                                                              Field Name: Events Create Reminder::DueDate
                                                              Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                              • Top: 129 pt
                                                              • Left: 160 pt
                                                              • Bottom: 150 pt
                                                              • Right: 401 pt
                                                              • Anchoring: Left, Top
                                                              Field Format:
                                                              • Edit Box
                                                              Field Behavior:
                                                              • Allow field to be entered: In Find mode, In Browse mode
                                                              • Touch keyboard type: Default for Data Type
                                                              • Go to next field using: Tab key
                                                              Yes

                                                              Field Name: Events Create Reminder::Notes
                                                              Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                              • Top: 152 pt
                                                              • Left: 160 pt
                                                              • Bottom: 173 pt
                                                              • Right: 413 pt
                                                              • Anchoring: Left, Top
                                                              Field Format:
                                                              • Edit Box
                                                              Field Behavior:
                                                              • Allow field to be entered: In Find mode, In Browse mode
                                                              • Touch keyboard type: Default for Data Type
                                                              • Go to next field using: Tab key
                                                              Yes

                                                              Field Name: Events Create Reminder::TimeZone
                                                              Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                              • Top: 175 pt
                                                              • Left: 160 pt
                                                              • Bottom: 196 pt
                                                              • Right: 413 pt
                                                              • Anchoring: Left, Top
                                                              Field Format:
                                                              • Edit Box
                                                              Field Behavior:
                                                              • Allow field to be entered: In Find mode, In Browse mode
                                                              • Touch keyboard type: Default for Data Type
                                                              • Go to next field using: Tab key
                                                              Yes

                                                              Field Name: Events Create Reminder::Title
                                                              Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                              • Top: 198 pt
                                                              • Left: 160 pt
                                                              • Bottom: 219 pt
                                                              • Right: 413 pt
                                                              • Anchoring: Left, Top
                                                              Field Format:
                                                              • Edit Box
                                                              Field Behavior:
                                                              • Allow field to be entered: In Find mode, In Browse mode
                                                              • Touch keyboard type: Default for Data Type
                                                              • Go to next field using: Tab key
                                                              Yes

                                                              Field Name: Events Create Reminder::URL
                                                              Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                              • Top: 221 pt
                                                              • Left: 160 pt
                                                              • Bottom: 242 pt
                                                              • Right: 413 pt
                                                              • Anchoring: Left, Top
                                                              Field Format:
                                                              • Edit Box
                                                              Field Behavior:
                                                              • Allow field to be entered: In Find mode, In Browse mode
                                                              • Touch keyboard type: Default for Data Type
                                                              • Go to next field using: Tab key
                                                              Yes

                                                              Field Name: Events Create Reminder::AlarmSound
                                                              Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                              • Top: 278 pt
                                                              • Left: 160 pt
                                                              • Bottom: 299 pt
                                                              • Right: 413 pt
                                                              • Anchoring: Left, Top
                                                              Field Format:
                                                              • Edit Box
                                                              Field Behavior:
                                                              • Allow field to be entered: In Find mode, In Browse mode
                                                              • Touch keyboard type: Default for Data Type
                                                              • Go to next field using: Tab key
                                                              Yes

                                                              Field Name: Events Create Reminder::AlarmProximity
                                                              Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                              • Top: 301 pt
                                                              • Left: 160 pt
                                                              • Bottom: 322 pt
                                                              • Right: 413 pt
                                                              • Anchoring: Left, Top
                                                              Field Format:
                                                              • Edit Box
                                                              Field Behavior:
                                                              • Allow field to be entered: In Find mode, In Browse mode
                                                              • Touch keyboard type: Default for Data Type
                                                              • Go to next field using: Tab key
                                                              Yes

                                                              Field Name: Events Create Reminder::AlarmLocationTitle
                                                              Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                              • Top: 324 pt
                                                              • Left: 160 pt
                                                              • Bottom: 345 pt
                                                              • Right: 413 pt
                                                              • Anchoring: Left, Top
                                                              Field Format:
                                                              • Edit Box
                                                              Field Behavior:
                                                              • Allow field to be entered: In Find mode, In Browse mode
                                                              • Touch keyboard type: Default for Data Type
                                                              • Go to next field using: Tab key
                                                              Yes

                                                              Field Name: Events Create Reminder::AlarmLocationGeoLat
                                                              Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                              • Top: 347 pt
                                                              • Left: 160 pt
                                                              • Bottom: 368 pt
                                                              • Right: 413 pt
                                                              • Anchoring: Left, Top
                                                              Field Format:
                                                              • Edit Box
                                                              Field Behavior:
                                                              • Allow field to be entered: In Find mode, In Browse mode
                                                              • Touch keyboard type: Default for Data Type
                                                              • Go to next field using: Tab key
                                                              Yes

                                                              Field Name: Events Create Reminder::AlarmLocationGeoLong
                                                              Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                              • Top: 370 pt
                                                              • Left: 160 pt
                                                              • Bottom: 391 pt
                                                              • Right: 413 pt
                                                              • Anchoring: Left, Top
                                                              Field Format:
                                                              • Edit Box
                                                              Field Behavior:
                                                              • Allow field to be entered: In Find mode, In Browse mode
                                                              • Touch keyboard type: Default for Data Type
                                                              • Go to next field using: Tab key
                                                              Yes

                                                              Field Name: Events Create Reminder::Location
                                                              Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                              • Top: 244 pt
                                                              • Left: 160 pt
                                                              • Bottom: 265 pt
                                                              • Right: 413 pt
                                                              • Anchoring: Left, Top
                                                              Field Format:
                                                              • Edit Box
                                                              Field Behavior:
                                                              • Allow field to be entered: In Find mode, In Browse mode
                                                              • Touch keyboard type: Default for Data Type
                                                              • Go to next field using: Tab key
                                                              Yes

                                                              Field Name: Events Create Reminder::AlarmLocationRadius
                                                              Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                              • Top: 393 pt
                                                              • Left: 160 pt
                                                              • Bottom: 414 pt
                                                              • Right: 413 pt
                                                              • Anchoring: Left, Top
                                                              Field Format:
                                                              • Edit Box
                                                              Field Behavior:
                                                              • Allow field to be entered: In Find mode, In Browse mode
                                                              • Touch keyboard type: Default for Data Type
                                                              • Go to next field using: Tab key
                                                              Yes

                                                              Buttons

                                                              Button PropertiesCoordinatesScript/Script Step
                                                                Type:
                                                              • Text: Create Reminder
                                                              • Top: 496 pt
                                                              • Left: 443 pt
                                                              • Bottom: 522 pt
                                                              • Right: 560 pt
                                                              • Anchoring: Left, Top
                                                              Perform Script [ “Create Reminder” ]

                                                              Scripts:


                                                              Button PropertiesCoordinatesScript/Script Step
                                                                Type:
                                                              • Text: Authorize
                                                              • Top: 496 pt
                                                              • Left: 310 pt
                                                              • Bottom: 522 pt
                                                              • Right: 427 pt
                                                              • Anchoring: Left, Top
                                                              Perform Script [ “Authorize” ]

                                                              Scripts:


                                                              Button PropertiesCoordinatesScript/Script Step
                                                                Type:
                                                              • Text: Set Dates
                                                              • Top: 497 pt
                                                              • Left: 177 pt
                                                              • Bottom: 523 pt
                                                              • Right: 294 pt
                                                              • Anchoring: Left, Top
                                                              Perform Script [ “SetDates” ]

                                                              Scripts:


                                                              Script Hierarchy

                                                              Create Reminder
                                                              SetDates
                                                              Authorize

                                                              Next Script: [SetDates]
                                                              Script NameCreate Reminder
                                                              Run script with full access privilegesOff
                                                              Include In MenuYes
                                                              Layouts that use this script
                                                              Scripts that use this script
                                                                Script Definition
                                                                Script Steps
                                                                • Set Variable [ $reminder; Value:MBS( "Events.NewReminder" ) ]
                                                                • Set Variable [ $calendar; Value:Events Create Reminder::Calendar ]
                                                                • If [ IsEmpty(Events Create Reminder::Calendar) ]
                                                                • Set Variable [ $calendar; Value:MBS( "Events.defaultCalendarForNewReminders" ) ]
                                                                • End If
                                                                • Set Variable [ $r; Value:MBS( "Events.Item.SetCalendar"; $reminder; $calendar ) ]
                                                                • Set Variable [ $r; Value:MBS( "Events.Item.SetLocation"; $reminder; Events Create Reminder::Location ) ]
                                                                • Set Variable [ $r; Value:MBS( "Events.Item.SetTitle"; $reminder; Events Create Reminder::Title ) ]
                                                                • Set Variable [ $r; Value:MBS( "Events.Item.SetURL"; $reminder; Events Create Reminder::URL ) ]
                                                                • Set Variable [ $r; Value:MBS( "Events.Item.SetNotes"; $reminder; Events Create Reminder::Notes ) ]
                                                                • If [ IsEmpty(Events Create Reminder::TimeZone) ]
                                                                • #we don't set it
                                                                • Else
                                                                • Set Variable [ $r; Value:MBS( "Events.Item.SetTimezone"; $reminder; Events Create Reminder::TimeZone ) ]
                                                                • End If
                                                                • Set Variable [ $r; Value:MBS( "Events.Reminder.SetPriority"; $reminder; Events Create Reminder::Priority ) ]
                                                                • If [ not IsEmpty(Events Create Reminder::StartDate) ]
                                                                • Set Variable [ $r; Value:MBS( "Events.Reminder.SetStartDate"; $reminder; Events Create Reminder::StartDate ) ]
                                                                • End If
                                                                • If [ not IsEmpty(Events Create Reminder::DueDate) ]
                                                                • Set Variable [ $r; Value:MBS( "Events.Reminder.SetDueDate"; $reminder; Events Create Reminder::DueDate ) ]
                                                                • End If
                                                                • If [ not IsEmpty(Events Create Reminder::AlarmSound) or not IsEmpty(Events Create Reminder::AlarmLocationTitle) or not IsEmpty(Events Create Reminder::AlarmLocationGeoLat) ]
                                                                • Set Variable [ $alarm; Value:MBS( "Events.NewAlarm" ) ]
                                                                • If [ not IsEmpty(Events Create Reminder::AlarmSound) ]
                                                                • Set Variable [ $r; Value:MBS( "Events.Alarm.SetSound"; $alarm; Events Create Reminder::AlarmSound ) ]
                                                                • End If
                                                                • If [ not IsEmpty(Events Create Reminder::AlarmLocationTitle) ]
                                                                • Set Variable [ $l; Value:MBS( "Events.StructuredLocation.NewLocationWithTitle"; Events Create Reminder::AlarmLocationTitle ) ]
                                                                • Set Variable [ $r; Value:MBS( "Events.StructuredLocation.SetRadius"; $l; Events Create Reminder::AlarmLocationRadius ) ]
                                                                • Set Variable [ $r; Value:MBS( "Events.StructuredLocation.SetGeoLocation"; $l; Events Create Reminder::AlarmLocationGeoLat; Events Create Reminder::AlarmLocationGeoLong ) ]
                                                                • Set Variable [ $r; Value:MBS( "Events.Alarm.SetStructuredLocation"; $alarm; $l) ]
                                                                • Set Variable [ $r; Value:MBS( "Events.Alarm.SetProximity"; $alarm; Events Create Reminder::AlarmProximity ) ]
                                                                • End If
                                                                • Set Variable [ $r; Value:MBS( "Events.Item.AddAlarm"; $reminder; $alarm ) ]
                                                                • End If
                                                                • Set Variable [ $r; Value:MBS( "Events.SaveReminder"; $reminder ;1 ) ]
                                                                • Show Custom Dialog [ Title: "Saved Reminder"; Message: $r; Default Button: “OK”, Commit: “Yes” ]
                                                                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

                                                                        Previous Script: [Create Reminder]Next Script: [Authorize]
                                                                        Script NameSetDates
                                                                        Run script with full access privilegesOff
                                                                        Include In MenuYes
                                                                        Layouts that use this script
                                                                        Scripts that use this script
                                                                          Script Definition
                                                                          Script Steps
                                                                          • Set Variable [ $now; Value:Get(CurrentHostTimestamp) ]
                                                                          • Set Field [ Events Create Reminder::StartDate; $now + 10 * 60 ]
                                                                          • Set Field [ Events Create Reminder::DueDate; $now + 30 * 60 ]
                                                                          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

                                                                                  Previous Script: [SetDates]
                                                                                  Script NameAuthorize
                                                                                  Run script with full access privilegesOff
                                                                                  Include In MenuYes
                                                                                  Layouts that use this script
                                                                                  Scripts that use this script
                                                                                    Script Definition
                                                                                    Script Steps
                                                                                    • Set Variable [ $r; Value:MBS("Events.AuthorizationStatusForEntityType"; "Reminder") ]
                                                                                    • If [ MBS("IsError") ]
                                                                                    • Show Custom Dialog [ Title: "We have a problem"; Message: MBS("Text.RemovePrefix"; $r; "[MBS] "); Default Button: “OK”, Commit: “Yes”; Button 2: “Abbrechen”, Commit: “No” ]
                                                                                    • Else If [ $r = "NotDetermined" ]
                                                                                    • Set Variable [ $r; Value:MBS( "Events.requestAccessToEntityType"; "Reminder" ) ]
                                                                                    • If [ $r = "Wait" ]
                                                                                    • #dialog is showing.
                                                                                    • Else If [ $r = "OK" ]
                                                                                    • Show Custom Dialog [ Title: "Success"; Message: "We are authorized and ready to go."; Default Button: “OK”, Commit: “Yes”; Button 2: “Abbrechen”, Commit: “No” ]
                                                                                    • Else
                                                                                    • Show Custom Dialog [ Title: "We have a problem"; Message: $r; Default Button: “OK”, Commit: “Yes”; Button 2: “Abbrechen”, Commit: “No” ]
                                                                                    • End If
                                                                                    • Else If [ $r = "Restricted" ]
                                                                                    • Show Custom Dialog [ Title: "Success"; Message: "We are authorized for a restricted access and ready to go."; Default Button: “OK”, Commit: “Yes”; Button 2: “Abbrechen”, Commit: “No” ]
                                                                                    • Else If [ $r = "Denied" ]
                                                                                    • Show Custom Dialog [ Title: "Problem"; Message: "We are denied for calendar access. Please go to system preferences and enable us."; Default Button: “OK”, Commit: “Yes”; Button 2: “Abbrechen”, Commit: “No” ]
                                                                                    • Else If [ $r = "Authorized" ]
                                                                                    • Show Custom Dialog [ Title: "Success"; Message: "We are authorized and ready to go."; Default Button: “OK”, Commit: “Yes”; Button 2: “Abbrechen”, Commit: “No” ]
                                                                                    • Else
                                                                                    • Show Custom Dialog [ Title: "We have a problem"; Message: $r; Default Button: “OK”, Commit: “Yes”; Button 2: “Abbrechen”, Commit: “No” ]
                                                                                    • 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

                                                                                                  Download example: Events Create Reminder

                                                                                                  Used functions:




                                                                                                  Links
                                                                                                  MBS FileMaker tutorial videos