Monkeybread Software - MBS FileMaker Plugin: Search Scripts

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

MBS FileMaker Plugin Example Databases

Search Scripts

All examples are included with download of MBS FileMaker Plugin.

Search Scripts.fmp12

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

Tables

Table Name	Statistics	Occurrences in Relationship Graph
Search Scripts	8 fields defined, 0 record	Search Scripts

Fields

Table Name: Search Scripts - 8 Fields
Field Name	Type	Options	Comments	On Layouts	In Relationships	In Scripts	In Value Lists
PrimaryKey	Normal, Text	Auto-Enter: Context table: Search Scripts 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
XML	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: All Index Language: German		Search Scripts		Search Script Run Search
Row	Normal, Number	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Search Scripts		Search Script
Text	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: All Index Language: German		Search Scripts		Search Script Run Search
SearchText	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Global Repetitions: 1 Index Language: German		Search Scripts		Install Hotkey Search Script Run Search Clear
Enabled	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Search Scripts		Search Script
DebugXML	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Global Repetitions: 1 Index Language: German		Search Scripts		Install Hotkey Search Script Clear
TypeID	Normal, Number	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Search Scripts		Search Script

Layout Objects: Search Scripts

Regular Fields

Field Name: Search Scripts::Row

Layout Name:

Search Scripts

Top: 113 pt
Left: 2 pt
Bottom: 145 pt
Right: 81 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Touch keyboard type: Default for Data Type
Go to next field using: Tab key

Yes

Field Name: Search Scripts::Text

Layout Name:

Search Scripts

Top: 113 pt
Left: 92 pt
Bottom: 145 pt
Right: 939 pt

Anchoring: Left and Right, 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

Conditional Formatting	Condition	Format
1.	Formula: Search Scripts::TypeID = 89	self:normal .self { color: rgba(24.7059%,41.1765%,11.7647%,1); } self:normal .icon { -fm-icon-color: rgba(0%,0%,0%,0); }
2.	Formula: Search Scripts::Enabled = "false"	self:normal .self { color: rgba(40.3922%,40.3922%,40.3922%,1); }
3.	Formula: Search Scripts::TypeID = 125 or (Search Scripts::TypeID ≥ 68 and Search Scripts::TypeID ≤ 73)	self:normal .self { color: rgba(52.1569%,0%,68.6275%,1); }

Field Name: Search Scripts::SearchText

Layout Name:

Search Scripts

OnObjectKeystroke

Script: Search via Return Key
Modes: Browse

Top: 66 pt
Left: 151 pt
Bottom: 98 pt
Right: 450 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

Field Name: Search Scripts::DebugXML

Layout Name:

Search Scripts

Top: 133 pt
Left: 845 pt
Bottom: 485 pt
Right: 1114 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

Field Name: Search Scripts::XML

Layout Name:

Search Scripts

Top: 39 pt
Left: 649 pt
Bottom: 394 pt
Right: 916 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

Type:

Layout Name:

Search Scripts

Top: 2 pt
Left: 946 pt
Bottom: 66 pt
Right: 1010 pt

Anchoring: Right, Top

Open URL [ "https://www.monkeybreadsoftware.com/filemaker/" ] [ No dialog ]

Type:

Text: Find

Layout Name:

Search Scripts

Top: 67 pt
Left: 474 pt
Bottom: 97 pt
Right: 604 pt

Anchoring: Left, Top

Perform Script [ “Run Search” ]

Scripts:

Run Search

Popover Buttons

Popover Button Properties		Coordinates
Type: Text: Debug Layout Name: Search Scripts		Top: 66 pt Left: 939 pt Bottom: 96 pt Right: 1018 pt Anchoring: Right, Top
Popover Properties		Coordinates
Show Title Bar: Yes Title: "XML" Position: Top		Top: 100 pt Left: 834 pt Bottom: 500 pt Right: 1124 pt Anchoring: Left, Top
Popover Content
Tab Controls	Slide Controls	Fields	Buttons	Portals	Web Viewer Controls	Charts
		Field Objects Search Scripts::DebugXML at (133, 845, 485, 1114)

Popover Button Properties		Coordinates
Type: Text: XML Layout Name: Search Scripts		Top: 116 pt Left: 939 pt Bottom: 145 pt Right: 1018 pt Anchoring: Right, Top
Popover Properties		Coordinates
Show Title Bar: Yes Title: "XML" Position: Left		Top: 5 pt Left: 638 pt Bottom: 405 pt Right: 928 pt Anchoring: Left, Top
Popover Content
Tab Controls	Slide Controls	Fields	Buttons	Portals	Web Viewer Controls	Charts
		Field Objects Search Scripts::XML at (39, 649, 394, 916)

Search via Return Key

Run Search

Release All Hotkeys

Clear

Next Script: [Cleanup]

Script Name	Install Hotkey
Run script with full access privileges	Off
Siri Shortcut Visible	Off
Include In Menu	Yes
Layouts that use this script
Scripts that use this script
Script Definition
Script Steps	#Register hotkey to search with F8 #cleanup old one If [ $$hotkeyF8 ] Set Variable [ $r; Value:MBS("HotKey.Unregister"; $$HotkeyF8) ] Set Variable [ $$hotkeyF8; Value:"" ] End If #now register Set Variable [ $hotkey; Value:MBS("HotKey.Register"; "F8"; "") ] If [ MBS("IsError") ] Show Custom Dialog [ Title: "Failed to register hotkey!"; Message: $hotkey; Default Button: “OK”, Commit: “Yes” ] Exit Script [ ] Else #and set magic expression to run the search If [ MBS("IsWindows") ] Set Variable [ $r; Value:MBS( "HotKey.SetEvaluate"; $hotkey; "Let ([ r = MBS( \"RemoteControl.PressControlKey\"; 1 ); r = MBS( \"RemoteControl.PressKey\"; \"a\"); r = MBS( \"Time.Wait\"; 50 ); r = MBS( \"RemoteControl.PressKey\"; \"c\"); r = MBS( \"RemoteControl.PressControlKey\"; 0 ); r = MBS( \"Time.Wait\"; 50 ); xml = MBS( \"Clipboard.GetFileMakerData\"; \"ScriptStep\" ); e = MBS(\"FM.RunScript\"; \"" & Get(FileName) & "\"; \"Search Script\"; xml); r = If(MBS(\"IsError\"); MBS(\"Msgbox\"; \"Failed to run: \" & e & Char(13) & \"Check fmplugin permissions to run scripts.\" ); \"\") ]; 1 )"; 0 ) ] Else Set Variable [ $r; Value:MBS( "HotKey.SetEvaluate"; $hotkey; "Let ([ r = MBS( \"Menubar.RunMenuCommand\"; 57642 /* select all / ); r = MBS( \"Time.Wait\"; 50 ); r = MBS( \"Menubar.RunMenuCommand\"; 57634 / copy */ ); r = MBS( \"Time.Wait\"; 50 ); xml = MBS( \"Clipboard.GetFileMakerData\"; \"ScriptStep\" ); e = MBS(\"FM.RunScript\"; \"" & Get(FileName) & "\"; \"Search Script\"; xml); r = If(MBS(\"IsError\"); MBS(\"Msgbox\"; \"Failed to run: \" & e & Char(13) & \"Check fmplugin permissions to run scripts.\" ); \"\") ]; 1 )"; 0 ) ] End If Set Variable [ $$hotkeyF8; Value:$hotkey ] Truncate Table [ No dialog; Table: “Search Scripts” ] Set Field [ Search Scripts::DebugXML; "" ] Set Field [ Search Scripts::SearchText; "" ] End If
Fields used in this script	Search Scripts::DebugXML Search Scripts::SearchText
Scripts used in this script
Layouts used in this script
Tables used in this script	Search Scripts
Table occurrences used by this script	Search Scripts
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [Install Hotkey]

Next Script: [Search Script]

Script Name	Cleanup
Run script with full access privileges	Off
Siri Shortcut Visible	Off
Include In Menu	Yes
Layouts that use this script
Scripts that use this script
Script Definition
Script Steps	#Cleanup our hotkey, when file is closed If [ $$hotkeyF8 ] Set Variable [ $r; Value:MBS("HotKey.Unregister"; $$HotkeyF8) ] Set Variable [ $$hotkeyF8; 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: [Cleanup]

Next Script: [Search via Return Key]

Script Name	Search Script
Run script with full access privileges	Off
Siri Shortcut Visible	Off
Include In Menu	No
Layouts that use this script
Scripts that use this script
Script Definition
Script Steps	#Peform the search. This script is triggered via our Hotkey Set Variable [ $xml; Value:Get(ScriptParameter) ] #nothing to search? If [ Length ( $xml ) = 0 ] Beep Exit Script [ ] End If Select Window [ Name: "Search Scripts"; Current file ] Go to Layout [ “Search Scripts” ] Show All Records Delete All Records [ No dialog ] Set Field [ Search Scripts::DebugXML; MBS("XML.Colorize"; MBS("XML.Format"; $xml)) ] Set Variable [ $xmlRef; Value:MBS("XML.Parse"; $xml) ] If [ MBS("IsError") = 0 ] Set Variable [ $count; Value:MBS("XML.Query"; $xmlRef; "count(//Step)") ] If [ MBS("IsError") ] Else If [ $count > 0 ] Set Variable [ $index; Value:1 ] Loop [ Flush: Always ] Set Variable [ $x; Value:MBS("XML.Query"; $xmlRef; "//Step[" & ($index) & "]") ] Set Variable [ $name; Value:MBS("XML.Query"; $xmlRef; "//Step[" & $index & "]/@name"; ""; 2) ] Set Variable [ $enabled; Value:MBS("XML.Query"; $xmlRef; "//Step[" & $index & "]/@enable"; ""; 2) ] Set Variable [ $TypeID; Value:MBS("XML.Query"; $xmlRef; "//Step[" & $index & "]/@id"; ""; 2) ] Set Variable [ $text; Value:MBS( "XML.ExtractText"; $x) ] #handle some types to better show details If [ $typeID = 89 // comment ] Set Variable [ $name; Value:"# " ] Else If [ $typeID = 6 // go to layout ] Set Variable [ $layout; Value:MBS("XML.Query"; $xmlRef; "//Step[" & $index & "]/Layout/@name"; ""; 2) ] Set Variable [ $name; Value:$name & " " & $layout ] Else If [ $typeID = 141 ] Set Variable [ $VariableName; Value:MBS("XML.Query"; $xmlRef; "//Step[" & $index & "]/Name"; ""; 2) ] Set Variable [ $name; Value:$name & " " & $VariableName ] End If #Save script step as record New Record/Request Set Field [ Search Scripts::Row; $index ] Set Field [ Search Scripts::XML; MBS("XML.Colorize"; $X) ] Set Field [ Search Scripts::Text; $name & " " & $text ] Set Field [ Search Scripts::Enabled; $enabled ] Set Field [ Search Scripts::TypeID; $typeID ] Commit Records/Requests Set Variable [ $index; Value:$index + 1 ] Exit Loop If [ $count < $index ] End Loop End If Set Variable [ $r; Value:MBS("XML.Release"; $xmlRef) ] Go to Field [ Search Scripts::SearchText ] End If
Fields used in this script	Search Scripts::DebugXML Search Scripts::Row Search Scripts::XML Search Scripts::Text Search Scripts::Enabled Search Scripts::TypeID Search Scripts::SearchText
Scripts used in this script
Layouts used in this script	Search Scripts
Tables used in this script	Search Scripts
Table occurrences used by this script	Search Scripts
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [Search Script]

Next Script: [Run Search]

Script Name	Search via Return Key
Run script with full access privileges	Off
Siri Shortcut Visible	Off
Include In Menu	No
Layouts that use this script
Scripts that use this script
Script Definition
Script Steps	If [ Code ( Get ( TriggerKeystroke ) ) = 13 ] Perform Script [ “Run Search” ] Exit Script [ Result: False ] Else Exit Script [ Result: True ] End If
Fields used in this script
Scripts used in this script	Run Search
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: [Search via Return Key]

Next Script: [Release All Hotkeys]

Script Name	Run Search
Run script with full access privileges	Off
Siri Shortcut Visible	Off
Include In Menu	No
Layouts that use this script	Search Scripts
Scripts that use this script	Search via Return Key
Script Definition
Script Steps	#perform the search when user clicks find button or pressed return key Show All Records If [ Length ( Search Scripts::SearchText ) > 0 ] Enter Find Mode [ ] #We search box XML and Text Set Field [ Search Scripts::Text; Search Scripts::SearchText ] New Record/Request Set Field [ Search Scripts::XML; Search Scripts::SearchText ] Perform Find [ ] End If
Fields used in this script	Search Scripts::SearchText Search Scripts::Text Search Scripts::XML
Scripts used in this script
Layouts used in this script
Tables used in this script	Search Scripts
Table occurrences used by this script	Search Scripts
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [Run Search]

Next Script: [Clear]

Script Name	Release All Hotkeys
Run script with full access privileges	Off
Siri Shortcut Visible	Off
Include In Menu	No
Layouts that use this script
Scripts that use this script
Script Definition
Script Steps	Set Variable [ $r; Value:MBS("HotKey.UnregisterAll") ]
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: [Release All Hotkeys]

Script Name	Clear
Run script with full access privileges	Off
Siri Shortcut Visible	Off
Include In Menu	Yes
Layouts that use this script
Scripts that use this script
Script Definition
Script Steps	#Clear all records Set Error Capture [ On ] Truncate Table [ No dialog; Table: “Search Scripts” ] Set Field [ Search Scripts::DebugXML; "" ] Set Field [ Search Scripts::SearchText; "" ]
Fields used in this script	Search Scripts::DebugXML Search Scripts::SearchText
Scripts used in this script
Layouts used in this script
Tables used in this script	Search Scripts
Table occurrences used by this script	Search Scripts
Custom Functions used by this script
Custom menu set used by this script

Download example: Search Scripts

Used functions: