Monkeybread Software - MBS FileMaker Plugin: Schedule Moved Trigger

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

MBS FileMaker Plugin Example Databases

Schedule Moved Trigger

All examples are included with download of MBS FileMaker Plugin.

Schedule Moved Trigger.fmp12

Overview
Tables	1
Relationships	0
Layouts	1
Scripts	3
Value Lists	0
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

Tables

Table Name	Statistics	Occurrences in Relationship Graph
Schedule Moved Trigger	7 fields defined, 1 record	Schedule Moved Trigger

Fields

Table Name: Schedule Moved Trigger - 7 Fields
Field Name	Type	Options	Comments	On Layouts	In Relationships	In Scripts	In Value Lists
Primärschlüssel	Normal, Text	Auto-Enter: Context table: Schedule Moved Trigger Calculation: Get( UUID ) Validation: Only during data entry Not empty Unique Strict validation Storage: Repetitions: 1 Indexing: Minimal Automatically create indexes as needed Index Language: Unicode Raw	Eindeutige ID für jeden Datensatz in dieser Tabelle
Erstellungszeitstempel	Normal, Timestamp	Auto-Enter: Creation timestamp Validation: Only during data entry Strict data type: 4 digit year Not empty Strict validation Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German	Datum und Uhrzeit der Erstellung der einzelnen Datensätze
ErstelltVon	Normal, Text	Auto-Enter: Creation account name Validation: Only during data entry Not empty Strict validation Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German	Kontoname des Benutzers, der die einzelnen Datensätze erstellt hat
Änderungszeitstempel	Normal, Timestamp	Auto-Enter: Modification timestamp Validation: Only during data entry Strict data type: 4 digit year Not empty Strict validation Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German	Datum und Uhrzeit der letzten Änderung der einzelnen Datensätze
GeändertVon	Normal, Text	Auto-Enter: Modification account name Validation: Only during data entry Not empty Strict validation Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German	Kontoname des Benutzers, der die einzelnen Datensätze zuletzt geändert hat
Last Move	Normal, Timestamp	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Schedule Moved Trigger		Moved
Last Move Milliseconds	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Schedule Moved Trigger		Moved

Layout Objects: Schedule Moved Trigger

Regular Fields

Field Name: Schedule Moved Trigger::Last Move

Layout Name:

Schedule Moved Trigger

Top: 122 pt
Left: 212 pt
Bottom: 153 pt
Right: 521 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: Schedule Moved Trigger::Last Move Milliseconds

Layout Name:

Schedule Moved Trigger

Top: 157 pt
Left: 212 pt
Bottom: 188 pt
Right: 521 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

Next Script: [Stop Moved]

Script Name	Start Moved Trigger
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	#remove it if you called script before If [ Length ( $$MovedSchedule ) > 0 ] Set Variable [ $r; Value:MBS("Schedule.Release"; $$MovedSchedule) ] Set Variable [ $$MovedSchedule; Value:"" ] End If #our settings Set Variable [ $ScriptParameter; Value:"" ] Set Variable [ $ScriptName; Value:"Moved" ] Set Variable [ $FileName; Value:Get(FileName) ] #now build it Set Variable [ $currentWindow; Value:MBS( "Window.Current" ) ] Set Variable [ $WindowPos; Value:MBS( "Window.GetLeft"; $currentWindow ) & "/" & MBS( "Window.GetTop"; $currentWindow ) ] #we store the position in the window tag right with the plugin Set Variable [ $r; Value:MBS( "Window.SetTag"; $currentWindow; $WindowPos ) ] #init schedule Set Variable [ $ScheduleRef; Value:MBS( "Schedule.EvaluateAfterDelay"; 1 /* every second /; "1" / dummy expression /; ""; ""; 1 / repeat after every second */ ) ] Set Variable [ $expression; Value:"Let ( [ currentWindow = $$$currentWindow; scheduleRef = $$$scheduleRef; FileName = $$$FileName; ScriptName = $$$ScriptName; ScriptParameter = $$$ScriptParameter; oldWindowPos = MBS( \"Window.GetTag\"; currentWindow ); closed = MBS(\"IsError\"); newWindowPos = MBS( \"Window.GetLeft\"; currentWindow ) & \"/\" & MBS( \"Window.GetTop\"; currentWindow ); r = If(oldWindowPos ≠ newWindowPos; MBS( \"Window.SetTag\"; currentWindow; newWindowPos ) & MBS( \"FM.RunScript\"; FileName; ScriptName; ScriptParameter ); 0); r = If(closed; MBS( \"Schedule.Release\"; scheduleRef ); 0) ]; \"\")" ] Set Variable [ $expression; Value:Substitute($expression; "$$$ScriptParameter"; Quote($ScriptParameter)) ] Set Variable [ $expression; Value:Substitute($expression; "$$$FileName"; Quote($FileName)) ] Set Variable [ $expression; Value:Substitute($expression; "$$$ScriptName"; Quote($ScriptName)) ] Set Variable [ $expression; Value:Substitute($expression; "$$$scheduleRef"; $scheduleRef) ] Set Variable [ $expression; Value:Substitute($expression; "$$$currentWindow"; $currentWindow) ] Set Variable [ $r; Value:MBS( "Schedule.SetEvaluate"; $ScheduleRef; $Expression ) ] Set Variable [ $$MovedSchedule; Value:$ScheduleRef ]
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: [Start Moved Trigger]

Next Script: [Moved]

Script Name	Stop Moved
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	If [ Length ( $$MovedSchedule ) > 0 ] Set Variable [ $r; Value:MBS("Schedule.Release"; $$MovedSchedule) ] Set Variable [ $$MovedSchedule; Value:"" ] 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

Previous Script: [Stop Moved]

Script Name	Moved
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 [ Schedule Moved Trigger::Last Move Milliseconds; Get(CurrentTimeUTCMilliseconds) ] Set Field [ Schedule Moved Trigger::Last Move; Get(CurrentTimestamp) ] Commit Records/Requests [ No dialog ]
Fields used in this script	Schedule Moved Trigger::Last Move Milliseconds Schedule Moved Trigger::Last Move
Scripts used in this script
Layouts used in this script
Tables used in this script	Schedule Moved Trigger
Table occurrences used by this script	Schedule Moved Trigger
Custom Functions used by this script
Custom menu set used by this script

Download example: Schedule Moved Trigger

Used functions: