Monkeybread Software - MBS FileMaker Plugin: Schedules

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

MBS FileMaker Plugin Example Databases

Schedules

All examples are included with download of MBS FileMaker Plugin.

Schedules.fmp12

Overview
Tables	2
Relationships	0
Layouts	2
Scripts	5
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	Script: Startup
OnLastWindowClose	Off
OnWindowOpen	Off
OnWindowClose	Off
OnFileAVPlayerChange	Off
Thumbnail Settings
Generate Thumbnails	On; Temporary

Tables

Table Name	Statistics	Occurrences in Relationship Graph
Schedules	10 fields defined, 0 record	Schedules
Test	1 field defined, 0 record	Test

Fields

Table Name: Schedules - 10 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		Schedules		UpdateList unschedule
Type	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Schedules		UpdateList
FileName	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Schedules		UpdateList
ScriptName	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Schedules		UpdateList
ScriptParameter	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Schedules		UpdateList
SQL	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Schedules		UpdateList
Evaluate	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Schedules		UpdateList
repeatDelay	Normal, Number	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Schedules		UpdateList
idleDelay	Normal, Number	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Schedules		UpdateList
Counter	Normal, Number	Auto-Enter: Allow editing Validation: Only during data entry Storage: Global Repetitions: 1 Index Language: German		Schedules		countScript

Table Name: Test - 1 Fields

Auto-Enter:

Allow editing

Validation:

Only during data entry

Storage:

Repetitions: 1
Indexing: None
Automatically create indexes as needed
Index Language: German

Test

Layout Objects: Schedules

Regular Fields

Field Name: Schedules::Type

Layout Name:

Schedules

Top: 126 pt
Left: 96 pt
Bottom: 140 pt
Right: 169 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: Schedules::FileName

Layout Name:

Schedules

Top: 126 pt
Left: 174 pt
Bottom: 140 pt
Right: 265 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: Schedules::ScriptName

Layout Name:

Schedules

Top: 126 pt
Left: 270 pt
Bottom: 140 pt
Right: 373 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: Schedules::ScriptParameter

Layout Name:

Schedules

Top: 126 pt
Left: 378 pt
Bottom: 140 pt
Right: 463 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: Schedules::SQL

Layout Name:

Schedules

Top: 126 pt
Left: 468 pt
Bottom: 140 pt
Right: 631 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: Schedules::Evaluate

Layout Name:

Schedules

Top: 126 pt
Left: 636 pt
Bottom: 140 pt
Right: 799 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: Schedules::repeatDelay

Layout Name:

Schedules

Top: 126 pt
Left: 804 pt
Bottom: 140 pt
Right: 883 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: Schedules::idleDelay

Layout Name:

Schedules

Top: 126 pt
Left: 888 pt
Bottom: 140 pt
Right: 967 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: Schedules::ID

Layout Name:

Schedules

Top: 126 pt
Left: 6 pt
Bottom: 140 pt
Right: 91 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: Schedules::Counter

Layout Name:

Schedules

Top: 12 pt
Left: 618 pt
Bottom: 26 pt
Right: 697 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: Update List

Layout Name:

Schedules

Additional Properties:

Change to hand cursor over button
Rectangular

Top: 6 pt
Left: 6 pt
Bottom: 31 pt
Right: 109 pt

Anchoring: Left, Top

Perform Script [ “UpdateList” ]

Scripts:

UpdateList

Button Properties

Coordinates

Script/Script Step

Type:

Text: Remove This Schedule

Layout Name:

Schedules

Additional Properties:

Change to hand cursor over button
Rectangular

Top: 123 pt
Left: 984 pt
Bottom: 143 pt
Right: 1141 pt

Anchoring: Left, Top

Perform Script [ “unschedule” ]

Scripts:

unschedule

Button Properties

Coordinates

Script/Script Step

Type:

Text: Schedule Script Call in 10 Seconds

Layout Name:

Schedules

Additional Properties:

Change to hand cursor over button
Rectangular

Top: 6 pt
Left: 123 pt
Bottom: 31 pt
Right: 322 pt

Anchoring: Left, Top

Set Variable [ $r; Value:MBS( "Schedule.StartScriptAfterDelay"; 10; Get(FileName); "testScript"; "Hello World" ) & MBS( "FM.RunScript"; Get(FileName); "updateList") ]

Button Properties

Coordinates

Script/Script Step

Type:

Text: Schedule Script for Counting

Layout Name:

Schedules

Additional Properties:

Change to hand cursor over button
Rectangular

Top: 6 pt
Left: 333 pt
Bottom: 31 pt
Right: 514 pt

Anchoring: Left, Top

Set Variable [ $r; Value:MBS( "Schedule.StartScriptAfterDelay"; 2; Get(FileName); "countScript"; ""; 2 ) & MBS( "FM.RunScript"; Get(FileName); "updateList") ]

Button Properties

Coordinates

Script/Script Step

Type:

Text: Schedule SQL for Counting

Layout Name:

Schedules

Additional Properties:

Change to hand cursor over button
Rectangular

Top: 42 pt
Left: 333 pt
Bottom: 67 pt
Right: 514 pt

Anchoring: Left, Top

Set Variable [ $r; Value:MBS( "Schedule.ExecuteSQLAfterDelay"; 2; /* delay */ ""; /* file */ "UPDATE Schedules SET Counter = Counter + 1"; /* sql */ ""; /* fileName for script */ ""; /* scriptname */ ""; /* column separator */ ""; /* row separator */ 2 ) /* repeat after */ & MBS( "FM.RunScript"; Get(FileName); "updateList") ]

Button Properties

Coordinates

Script/Script Step

Type:

Text: Schedule Evaluate for Counting

Layout Name:

Schedules

Additional Properties:

Change to hand cursor over button
Rectangular

Top: 42 pt
Left: 123 pt
Bottom: 67 pt
Right: 304 pt

Anchoring: Left, Top

Set Variable [ $r; Value:MBS( "Schedule.EvaluateAfterDelay"; 2; /* delay */ "MBS(\"FM.ExecuteSQL\"; \"UPDATE Schedules SET Counter = Counter + 1\")"; /* delay */ ""; /* fileName */ ""; /* scriptName */ 2 ) /* repeatDelay */ & MBS( "FM.RunScript"; Get(FileName); "updateList") ]

Layout Objects: Test

Regular Fields

Field Name: Test::test

Layout Name:

Test

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

Next Script: [Startup]

Script Name	UpdateList
Run script with full access privileges	Off
Include In Menu	Yes
Layouts that use this script	Schedules
Scripts that use this script
Script Definition
Script Steps	Delete All Records [ No dialog ] #get list of schedules Set Variable [ $list; Value:MBS("Schedule.List"; 0) ] #now walk over list Set Variable [ $count; Value:ValueCount($list) ] Set Variable [ $index; Value:0 ] Loop Set Variable [ $index; Value:$index + 1 ] Set Variable [ $line; Value:GetValue($list; $index) ] If [ Length($line) > 5 ] Set Variable [ $line; Value:Substitute($line; " "; ¶) ] #process line New Record/Request Set Field [ Schedules::ID; GetValue($line; 1) ] Set Field [ Schedules::Type; GetValue($line; 2) ] Set Field [ Schedules::FileName; GetValue($line; 3) ] Set Field [ Schedules::ScriptName; GetValue($line; 4) ] Set Field [ Schedules::ScriptParameter; GetValue($line; 5) ] Set Field [ Schedules::SQL; GetValue($line; 6) ] Set Field [ Schedules::Evaluate; GetValue($line; 7) ] Set Field [ Schedules::repeatDelay; GetValue($line; 8) ] Set Field [ Schedules::idleDelay; GetValue($line; 9) ] Commit Records/Requests [ Skip data entry validation; No dialog ] End If #next Exit Loop If [ $index >= $count ] End Loop
Fields used in this script	Schedules::ID Schedules::Type Schedules::FileName Schedules::ScriptName Schedules::ScriptParameter Schedules::SQL Schedules::Evaluate Schedules::repeatDelay Schedules::idleDelay
Scripts used in this script
Layouts used in this script
Tables used in this script	Schedules
Table occurrences used by this script	Schedules
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [UpdateList]

Next Script: [testScript]

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

Previous Script: [Startup]

Next Script: [countScript]

Script Name	testScript
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	Show Custom Dialog [ Title: "Script called"; Message: Get(ScriptParameter); Default Button: “OK”, Commit: “Yes”; Button 2: “Cancel”, Commit: “No” ]
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: [testScript]

Next Script: [unschedule]

Script Name	countScript
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 Field [ Schedules::Counter; Schedules::Counter + 1 ]
Fields used in this script	Schedules::Counter
Scripts used in this script
Layouts used in this script
Tables used in this script	Schedules
Table occurrences used by this script	Schedules
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [countScript]

Script Name	unschedule
Run script with full access privileges	Off
Include In Menu	Yes
Layouts that use this script	Schedules
Scripts that use this script
Script Definition
Script Steps	Set Variable [ $r; Value:MBS("schedule.release"; Schedules::ID) ] Delete Record/Request [ No dialog ]
Fields used in this script	Schedules::ID
Scripts used in this script
Layouts used in this script
Tables used in this script	Schedules
Table occurrences used by this script	Schedules
Custom Functions used by this script
Custom menu set used by this script

Download example: Schedules

Used functions: