Components | All | New | MacOS | Windows | Linux | iOS | ||||
Examples | Mac & Win | Server | Client | Guides | Statistic | FMM | Blog | Deprecated | Old |
MBS FileMaker Plugin Example Databases
Events Sync
All examples are included with download of MBS FileMaker Plugin.
Overview | |
Tables | 2 |
Relationships | 0 |
Layouts | 2 |
Scripts | 10 |
Value Lists | 2 |
Custom Functions | 0 |
Custom Menus | 24 |
File Options | |
Default custom menu set | [Standard FileMaker Menus] |
When opening file | |
Minimum allowed version | 12.0 |
Login using | Account Name; Account= Admin |
Allow user to save password | Off |
Require iOS passcode | Off |
Switch to layout | Off |
Hide all toolbars | Off |
Script triggers | |
OnFirstWindowOpen | Off |
OnLastWindowClose | Off |
OnWindowOpen | Off |
OnWindowClose | Off |
OnFileAVPlayerChange | Off |
Thumbnail Settings | |
Generate Thumbnails | On; Temporary |
Table Name |
Statistics
| Occurrences in Relationship Graph |
Events |
14 fields defined, 0 record
| Events |
Calendars |
4 fields defined, 0 record
| Calendars |
Table Name: Events - 14 Fields | ||||||||
Field Name | Type | Options | Comments | On Layouts | In Relationships | In Scripts | In Value Lists | |
CalendarID | Normal, Text | Auto-Enter:
|
|
|
|
|||
CalendarName | Normal, Text | Auto-Enter:
|
|
|
||||
Title | Normal, Text | Auto-Enter:
|
|
|
||||
URL | Normal, Text | Auto-Enter:
|
|
|
||||
Note | Normal, Text | Auto-Enter:
|
|
|
||||
Location | Normal, Text | Auto-Enter:
|
|
|
||||
CalendarItemIdentifier | Normal, Text | Auto-Enter:
|
|
|
||||
CalendarItemExternalIdentifier | Normal, Text | Auto-Enter:
|
|
|
||||
AllDay | Normal, Text | Auto-Enter:
|
|
|
||||
Availability | Normal, Text | Auto-Enter:
|
|
|
||||
Start Date | Normal, Timestamp | Auto-Enter:
|
|
|
||||
End Date | Normal, Timestamp | Auto-Enter:
|
|
|
||||
UUID | Normal, Number | Auto-Enter:
|
|
|
|
|||
Last Modification Date | Normal, Timestamp | Auto-Enter:
|
|
|
Layout Objects: Events
Field Name: Events::CalendarName | |||||
Field Properties | Coordinates | Field Format | Field Behavior | Quick Find | |
|
| Field Format:
| Field Behavior:
| No |
Field Name: Events::Title | |||||
Field Properties | Coordinates | Field Format | Field Behavior | Quick Find | |
|
| Field Format:
| Field Behavior:
| Yes |
Field Name: Events::URL | |||||
Field Properties | Coordinates | Field Format | Field Behavior | Quick Find | |
|
| Field Format:
| Field Behavior:
| Yes |
Field Name: Events::Note | |||||
Field Properties | Coordinates | Field Format | Field Behavior | Quick Find | |
|
| Field Format:
| Field Behavior:
| Yes |
Field Name: Events::Location | |||||
Field Properties | Coordinates | Field Format | Field Behavior | Quick Find | |
|
| Field Format:
| Field Behavior:
| Yes |
Field Name: Events::CalendarItemIdentifier | |||||
Field Properties | Coordinates | Field Format | Field Behavior | Quick Find | |
|
| Field Format:
| Field Behavior:
| Yes |
Field Name: Events::CalendarItemExternalIdentifier | |||||
Field Properties | Coordinates | Field Format | Field Behavior | Quick Find | |
|
| Field Format:
| Field Behavior:
| Yes |
Field Name: Events::AllDay | |||||
Field Properties | Coordinates | Field Format | Field Behavior | Quick Find | |
|
| Field Format:
| Field Behavior:
| Yes |
Field Name: Events::Availability | |||||
Field Properties | Coordinates | Field Format | Field Behavior | Quick Find | |
|
| Field Format:
| Field Behavior:
| Yes |
Field Name: Events::Start Date | |||||
Field Properties | Coordinates | Field Format | Field Behavior | Quick Find | |
|
| Field Format:
| Field Behavior:
| Yes |
Field Name: Events::End Date | |||||
Field Properties | Coordinates | Field Format | Field Behavior | Quick Find | |
|
| Field Format:
| Field Behavior:
| Yes |
Field Name: Events::UUID | |||||
Field Properties | Coordinates | Field Format | Field Behavior | Quick Find | |
|
| Field Format:
| Field Behavior:
| Yes |
Field Name: Events::Last Modification Date | |||||
Field Properties | Coordinates | Field Format | Field Behavior | Quick Find | |
|
| Field Format:
| Field Behavior:
| Yes |
Button Properties | Coordinates | Script/Script Step | ||||
|
| Perform Script [ “Select Calendar via card” ] Scripts: |
Button Properties | Coordinates | Script/Script Step | ||||
|
| Perform Script [ “Authorize” ] Scripts: |
Button Properties | Coordinates | Script/Script Step | ||||
|
| Set Field [ Events::Start Date; Get(CurrentHostTimestamp) ] Fields: |
Button Properties | Coordinates | Script/Script Step | ||||
|
| Set Field [ Events::End Date; Get(CurrentHostTimestamp) ] Fields: |
Button Properties | Coordinates | Script/Script Step | ||||
|
| Perform Script [ “Sync” ] Scripts: |
Button Properties | Coordinates | Script/Script Step | ||||
|
| Perform Script [ “DeleteEvent” ] Scripts: |
Layout Objects: Calendars
Field Name: Calendars::Title | |||||
Field Properties | Coordinates | Field Format | Field Behavior | Quick Find | |
|
| Field Format:
| Field Behavior:
| Yes |
Field Name: Calendars::Type | |||||
Field Properties | Coordinates | Field Format | Field Behavior | Quick Find | |
|
| Field Format:
| Field Behavior:
| Yes |
Field Name: Calendars::Source | |||||
Field Properties | Coordinates | Field Format | Field Behavior | Quick Find | |
|
| Field Format:
| Field Behavior:
| Yes |
Button Properties | Coordinates | Script/Script Step | ||||
|
| Perform Script [ “Pick Calendar” ] Scripts: |
Value List Name | Source | Values | On Layouts |
Availability | Custom |
| |
All Day | Custom |
|
Next Script: [Pick Calendar] |
Script Name | Select Calendar via card |
Run script with full access privileges | Off |
Include In Menu | No |
Layouts that use this script | |
Scripts that use this script |
|
Script Definition | |
Script Steps |
|
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: [Select Calendar via card] | Next Script: [Authorize] |
Script Name | Pick Calendar |
Run script with full access privileges | Off |
Include In Menu | No |
Layouts that use this script | |
Scripts that use this script |
|
Script Definition | |
Script Steps |
|
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: [Pick Calendar] | Next Script: [Sync] |
Script Name | Authorize |
Run script with full access privileges | Off |
Include In Menu | Yes |
Layouts that use this script | |
Scripts that use this script |
|
Script Definition | |
Script Steps |
|
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: [Authorize] | Next Script: [Sync Events] |
Script Name | Sync |
Run script with full access privileges | Off |
Include In Menu | Yes |
Layouts that use this script | |
Scripts that use this script |
|
Script Definition | |
Script Steps |
|
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: [Sync] | Next Script: [Sync new Event in FileMaker to Calendar] |
Script Name | Sync Events |
Run script with full access privileges | Off |
Include In Menu | No |
Layouts that use this script |
|
Scripts that use this script | |
Script Definition | |
Script Steps |
|
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: [Sync Events] | Next Script: [Sync new Events from Calendar to FileMaker] |
Script Name | Sync new Event in FileMaker to Calendar |
Run script with full access privileges | Off |
Include In Menu | No |
Layouts that use this script |
|
Scripts that use this script | |
Script Definition | |
Script Steps |
|
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: [Sync new Event in FileMaker to Calendar] | Next Script: [Sync event from Calendar to FileMaker] |
Script Name | Sync new Events from Calendar to FileMaker |
Run script with full access privileges | Off |
Include In Menu | Yes |
Layouts that use this script |
|
Scripts that use this script | |
Script Definition | |
Script Steps |
|
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: [Sync new Events from Calendar to FileMaker] | Next Script: [Sync event from FileMaker to Calendar] |
Script Name | Sync event from Calendar to FileMaker |
Run script with full access privileges | Off |
Include In Menu | Yes |
Layouts that use this script |
|
Scripts that use this script | |
Script Definition | |
Script Steps |
|
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: [Sync event from Calendar to FileMaker] | Next Script: [DeleteEvent] |
Script Name | Sync event from FileMaker to Calendar |
Run script with full access privileges | Off |
Include In Menu | Yes |
Layouts that use this script |
|
Scripts that use this script | |
Script Definition | |
Script Steps |
|
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: [Sync event from FileMaker to Calendar] |
Script Name | DeleteEvent |
Run script with full access privileges | Off |
Include In Menu | Yes |
Layouts that use this script | |
Scripts that use this script |
|
Script Definition | |
Script Steps |
|
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 Sync
Used functions:- Events.AuthorizationStatusForEntityType
- Events.Calendar.GetSource
- Events.Calendar.GetTitle
- Events.Calendar.GetType
- Events.CalendarItemsWithExternalIdentifier
- Events.Calendars
- Events.Event.GetAllDay
- Events.Event.GetAvailability
- Events.Event.GetEndDate
- Events.Event.GetStartDate
- Events.Event.SetAllDay
- Events.Event.SetAvailability
- Events.Event.SetEndDate
- Events.Event.SetStartDate
- Events.Events
- Events.Item.CalendarItemExternalIdentifier
- Events.Item.CalendarItemIdentifier
- Events.Item.GetLocation
- Events.Item.GetNotes
- Events.Item.GetTitle
- Events.Item.GetURL
- Events.Item.lastModifiedDate
- Events.Item.SetCalendar
- Events.Item.SetLocation
- Events.Item.SetNotes
- Events.Item.SetTitle
- Events.Item.SetURL
- Events.NewEvent
- Events.RemoveEvent
- Events.Reset
- Events.SaveEvent
- Events.Source.Title
- FM.ExecuteFileSQL
- Text.RemovePrefix
