Monkeybread Software - MBS FileMaker Plugin: Reminders

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

MBS FileMaker Plugin Example Databases

Reminders

All examples are included with download of MBS FileMaker Plugin.

Reminders.fmp12

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

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

Tables

Table Name	Statistics	Occurrences in Relationship Graph
Reminders	12 fields defined, 0 record	Reminders

Fields

Table Name: Reminders - 12 Fields
Field Name	Type	Options	Comments	On Layouts	In Relationships	In Scripts	In Value Lists
ID	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Reminders		ListReminders
priority	Normal, Number	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Reminders		ListReminders
isCompleted	Normal, Number	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Reminders		ListReminders
completedDate	Normal, Timestamp	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Reminders		ListReminders
dueDate	Normal, Timestamp	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Reminders		ListReminders
calendar	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Reminders		ListReminders
notes	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Reminders		ListReminders
url	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Reminders		ListReminders
title	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Reminders		ListReminders
dateStamp	Normal, Timestamp	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Reminders
ReminderID	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Global Repetitions: 1 Index Language: German		Reminders		CreateReminder DeleteReminder EditReminder
CalendarName	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Global Repetitions: 1 Index Language: German		Reminders		CreateReminder

Layout Objects: Reminders

Regular Fields

Field Name: Reminders::ID

Layout Name:

Reminders

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: Reminders::priority

Layout Name:

Reminders

Top: 84 pt
Left: 138 pt
Bottom: 98 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: Reminders::isCompleted

Layout Name:

Reminders

Top: 102 pt
Left: 138 pt
Bottom: 116 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: Reminders::completedDate

Layout Name:

Reminders

Top: 120 pt
Left: 138 pt
Bottom: 134 pt
Right: 379 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: Reminders::dueDate

Layout Name:

Reminders

Top: 138 pt
Left: 138 pt
Bottom: 152 pt
Right: 379 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: Reminders::calendar

Layout Name:

Reminders

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: Reminders::notes

Layout Name:

Reminders

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: Reminders::url

Layout Name:

Reminders

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: Reminders::title

Layout Name:

Reminders

Top: 210 pt
Left: 138 pt
Bottom: 224 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: Reminders::dateStamp

Layout Name:

Reminders

Top: 228 pt
Left: 138 pt
Bottom: 242 pt
Right: 379 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: Reminders::ReminderID

Layout Name:

Reminders

Top: 289 pt
Left: 138 pt
Bottom: 303 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

Field Name: Reminders::CalendarName

Layout Name:

Reminders

Top: 306 pt
Left: 138 pt
Bottom: 320 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

Type:

Text: All Tasks (Reminders)

Layout Name:

Reminders

Additional Properties:

Change to hand cursor over button
Rectangular

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

Anchoring: Left, Top

Perform Script [ “ListReminders”; Parameter: "all" ]

Scripts:

ListReminders

Button Properties

Coordinates

Script/Script Step

Type:

Text: Create Reminder

Layout Name:

Reminders

Additional Properties:

Change to hand cursor over button
Rectangular

Top: 260 pt
Left: 12 pt
Bottom: 285 pt
Right: 139 pt

Anchoring: Left, Top

Perform Script [ “CreateReminder” ]

Scripts:

CreateReminder

Button Properties

Coordinates

Script/Script Step

Type:

Text: List uncompleted tasks

Layout Name:

Reminders

Additional Properties:

Change to hand cursor over button
Rectangular

Top: 12 pt
Left: 174 pt
Bottom: 37 pt
Right: 325 pt

Anchoring: Left, Top

Perform Script [ “ListReminders”; Parameter: "uncompleted" ]

Scripts:

ListReminders

Button Properties

Coordinates

Script/Script Step

Type:

Text: List tasks due till today

Layout Name:

Reminders

Additional Properties:

Change to hand cursor over button
Rectangular

Top: 12 pt
Left: 336 pt
Bottom: 37 pt
Right: 487 pt

Anchoring: Left, Top

Perform Script [ “ListReminders”; Parameter: "due today" ]

Scripts:

ListReminders

Button Properties

Coordinates

Script/Script Step

Type:

Text: Lists tasks completed today

Layout Name:

Reminders

Additional Properties:

Change to hand cursor over button
Rectangular

Top: 12 pt
Left: 498 pt
Bottom: 37 pt
Right: 661 pt

Anchoring: Left, Top

Perform Script [ “ListReminders”; Parameter: "completed today" ]

Scripts:

ListReminders

Button Properties

Coordinates

Script/Script Step

Type:

Text: Mark Completed

Layout Name:

Reminders

Additional Properties:

Change to hand cursor over button
Rectangular

Top: 260 pt
Left: 156 pt
Bottom: 285 pt
Right: 283 pt

Anchoring: Left, Top

Perform Script [ “EditReminder” ]

Scripts:

EditReminder

Button Properties

Coordinates

Script/Script Step

Type:

Text: Delete Reminder

Layout Name:

Reminders

Additional Properties:

Change to hand cursor over button
Rectangular

Top: 260 pt
Left: 300 pt
Bottom: 285 pt
Right: 427 pt

Anchoring: Left, Top

Perform Script [ “DeleteReminder” ]

Scripts:

DeleteReminder

Script Name	ListReminders
Run script with full access privileges	Off
Include In Menu	Yes
Layouts that use this script	Reminders
Scripts that use this script
Script Definition
Script Steps	Delete All Records [ No dialog ] If [ Get(ScriptParameter) = "all" ] Set Variable [ $Events; Value:MBS("Calendar.Tasks") ] Else If [ Get(ScriptParameter) = "uncompleted" ] Set Variable [ $Events; Value:MBS("Calendar.UncompletedTasks") ] Else If [ Get(ScriptParameter) = "due today" ] Set Variable [ $Events; Value:MBS("Calendar.UncompletedTasksDueBefore"; Get(CurrentTimestamp)) ] Else If [ Get(ScriptParameter) = "completed today" ] Set Variable [ $Events; Value:MBS("Calendar.TasksCompletedSince"; Date(Month(Get(CurrentTimestamp)); Day(Get(CurrentTimestamp)); Year(Get(CurrentTimestamp)))) ] Else Show Custom Dialog [ Title: "unknown parameter"; Message: Get(ScriptParameter); Default Button: “OK”, Commit: “Yes”; Button 2: “Cancel”, Commit: “No” ] End If If [ MBS("Iserror") = 0 ] Set Variable [ $Count; Value:ValueCount ( $events ) ] If [ $count > 0 ] Set Variable [ $index; Value:1 ] Loop Set Variable [ $id; Value:GetValue ( $events ; $index ) ] New Record/Request Set Field [ Reminders::title; MBS("Calendar.Item.GetTitle"; $id) ] Set Field [ Reminders::url; MBS("Calendar.Item.GetURL"; $id) ] Set Field [ Reminders::ID; MBS("Calendar.Item.GetUID"; $id) ] Set Field [ Reminders::priority; MBS("Calendar.Item.GetPriority"; $id) ] Set Field [ Reminders::dueDate; MBS("Calendar.Item.GetDueDate"; $id) ] Set Field [ Reminders::completedDate; MBS("Calendar.Item.GetCompletionDate"; $id) ] Set Field [ Reminders::isCompleted; MBS("Calendar.Item.GetCompleted"; $id) ] Set Field [ Reminders::notes; MBS("Calendar.Item.GetNotes"; $id) ] Set Field [ Reminders::calendar; MBS( "Calendar.Calendar.GetTitle"; MBS("Calendar.Item.GetCalendar"; $id)) ] Commit Records/Requests [ No dialog ] Set Variable [ $index; Value:$index + 1 ] Exit Loop If [ $index > $count ] End Loop End If End If
Fields used in this script	Reminders::title Reminders::url Reminders::ID Reminders::priority Reminders::dueDate Reminders::completedDate Reminders::isCompleted Reminders::notes Reminders::calendar
Scripts used in this script
Layouts used in this script
Tables used in this script	Reminders
Table occurrences used by this script	Reminders
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [ListReminders]

Next Script: [CreateReminder]

Script Name	Trace
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	Set Variable [ $r; Value:MBS("Trace") ]
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: [Trace]

Next Script: [DeleteReminder]

Script Name	CreateReminder
Run script with full access privileges	Off
Include In Menu	Yes
Layouts that use this script	Reminders
Scripts that use this script
Script Definition
Script Steps	Set Variable [ $c; Value:MBS("Calendar.NewReminder") ] Set Variable [ $r; Value:MBS("Calendar.Item.SetTitle"; $c; "Hello World") ] Set Variable [ $r; Value:MBS("Calendar.Item.SetNotes"; $c; "Just a test") ] Set Variable [ $r; Value:MBS("Calendar.Item.SetCalendar"; $c; Reminders::CalendarName) ] Set Variable [ $r; Value:MBS("Calendar.Item.SetDueDate"; $c; Get ( CurrentTimestamp ) ) ] Set Variable [ $r; Value:MBS("Calendar.SaveReminder"; $c ) ] Show Custom Dialog [ Title: "Saved?"; Message: $r; Default Button: “OK”, Commit: “Yes”; Button 2: “Cancel”, Commit: “No” ] Set Field [ Reminders::ReminderID; MBS("Calendar.Item.GetUID"; $c) ]
Fields used in this script	Reminders::CalendarName Reminders::ReminderID
Scripts used in this script
Layouts used in this script
Tables used in this script	Reminders
Table occurrences used by this script	Reminders
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [CreateReminder]

Next Script: [EditReminder]

Script Name	DeleteReminder
Run script with full access privileges	Off
Include In Menu	Yes
Layouts that use this script	Reminders
Scripts that use this script
Script Definition
Script Steps	Set Variable [ $r; Value:MBS("Calendar.RemoveReminder"; Reminders::ReminderID ) ] Set Field [ Reminders::ReminderID; "" ]
Fields used in this script	Reminders::ReminderID
Scripts used in this script
Layouts used in this script
Tables used in this script	Reminders
Table occurrences used by this script	Reminders
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [DeleteReminder]

Next Script: [Clear]

Script Name	EditReminder
Run script with full access privileges	Off
Include In Menu	Yes
Layouts that use this script	Reminders
Scripts that use this script
Script Definition
Script Steps	Set Variable [ $r; Value:MBS("Calendar.Item.SetCompleted"; Reminders::ReminderID; 1) ] Set Variable [ $r; Value:MBS("Calendar.SaveReminder"; Reminders::ReminderID ) ]
Fields used in this script	Reminders::ReminderID
Scripts used in this script
Layouts used in this script
Tables used in this script	Reminders
Table occurrences used by this script	Reminders
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [EditReminder]

Script Name	Clear
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	Delete All Records [ No dialog ]
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: Reminders

Used functions: