Monkeybread Software - MBS FileMaker Plugin: Install Plugin Update if needed

MBS FileMaker Plugin Example Databases

Install Plugin Update if needed

All examples are included with download of MBS FileMaker Plugin.

Overview
Tables	1
Relationships	0
Layouts	1
Scripts	8
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
Install Plugin Update if needed	9 fields defined, 1 record	Install Plugin Update if needed

Fields

Table Name: Install Plugin Update if needed - 9 Fields
Field Name	Type	Options	Comments	On Layouts	In Relationships	In Scripts	In Value Lists
Plugin File Mac	Normal, Binary	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1		Install Plugin Update if needed		Install MBS Plugin Query version for macOS Load Plugin from Server
Plugin File Win 32bit	Normal, Binary	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1		Install Plugin Update if needed		Install MBS Plugin Load Plugin from Server
Version Display	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Install Plugin Update if needed		Install MBS Plugin Check If Update is Needed Copy Version Numbers Clear Load Plugin from Server
Plugin File Win 64bit	Normal, Binary	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1		Install Plugin Update if needed		Install MBS Plugin Query version for Windows Load Plugin from Server
Version Number	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Install Plugin Update if needed		Install MBS Plugin Check If Update is Needed Copy Version Numbers Clear Load Plugin from Server
MBS Installed	Calculated, Number	Calculation: Context table: Install Plugin Update if needed GetAsText(MBS("Version")) ≠ "?" Auto-Enter: Always evaluate Storage: Repetitions: 1 Do not store calculation results Index Language: German		Install Plugin Update if needed		Check If Update is Needed
MBS Installed Version	Calculated, Number	Calculation: Context table: Install Plugin Update if needed GetAsText(MBS("Version")) Auto-Enter: Always evaluate Storage: Repetitions: 1 Do not store calculation results Index Language: German		Install Plugin Update if needed		Check If Update is Needed Copy Version Numbers
MBS Installed Version Number	Calculated, Number	Calculation: Context table: Install Plugin Update if needed GetAsText(MBS("VersionAutoUpdate")) Auto-Enter: Always evaluate Storage: Repetitions: 1 Do not store calculation results Index Language: German		Install Plugin Update if needed		Check If Update is Needed Copy Version Numbers
Plugin File Linux	Normal, Binary	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1		Install Plugin Update if needed		Install MBS Plugin Query version for Linux Load Plugin from Server

Layout Objects: Install Plugin Update if needed

Regular Fields

Field Name: Install Plugin Update if needed::Plugin File Mac

Layout Name:

Install Plugin Update if needed

Top: 65 pt
Left: 138 pt
Bottom: 190 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: Install Plugin Update if needed::Plugin File Win 32bit

Layout Name:

Install Plugin Update if needed

Top: 192 pt
Left: 138 pt
Bottom: 317 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: Install Plugin Update if needed::Version Display

Layout Name:

Install Plugin Update if needed

Top: 576 pt
Left: 137 pt
Bottom: 598 pt
Right: 390 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: Install Plugin Update if needed::Plugin File Win 64bit

Layout Name:

Install Plugin Update if needed

Top: 320 pt
Left: 138 pt
Bottom: 445 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: Install Plugin Update if needed::Version Number

Layout Name:

Install Plugin Update if needed

Top: 601 pt
Left: 137 pt
Bottom: 623 pt
Right: 390 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: Install Plugin Update if needed::MBS Installed

Layout Name:

Install Plugin Update if needed

Top: 6 pt
Left: 138 pt
Bottom: 28 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: Install Plugin Update if needed::MBS Installed Version

Layout Name:

Install Plugin Update if needed

Top: 31 pt
Left: 138 pt
Bottom: 53 pt
Right: 256 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: Install Plugin Update if needed::MBS Installed Version Number

Layout Name:

Install Plugin Update if needed

Top: 31 pt
Left: 267 pt
Bottom: 53 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: Install Plugin Update if needed::Plugin File Linux

Layout Name:

Install Plugin Update if needed

Top: 448 pt
Left: 138 pt
Bottom: 573 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: Default for Data Type
Go to next field using: Tab key

Type:

Text: Check MBS Version

Layout Name:

Install Plugin Update if needed

Top: 84 pt
Left: 412 pt
Bottom: 118 pt
Right: 536 pt

Anchoring: Left, Top

Perform Script [ “Check If Update is Needed” ]

Scripts:

Check If Update is Needed

Button Properties

Coordinates

Script/Script Step

Type:

Text: Copy Version

Layout Name:

Install Plugin Update if needed

Top: 578 pt
Left: 524 pt
Bottom: 614 pt
Right: 603 pt

Anchoring: Left, Top

Perform Script [ “Copy Version Numbers” ]

Scripts:

Copy Version Numbers

Script Hierarchy

Install MBS Plugin

Check If Update is Needed

Copy Version Numbers

Clear

Query version for Windows

Query version for Linux

Query version for macOS

Load Plugin from Server

Next Script: [Check If Update is Needed]

Script Name	Install MBS Plugin
Run script with full access privileges	Off
Include In Menu	Yes
Layouts that use this script
Scripts that use this script	Check If Update is Needed
Script Definition
Script Steps	# Check Architecture # will be ? for older 32-bit FileMaker Pro Set Variable [ $Arch; Value:GetAsText( Get (ApplicationArchitecture)) ] # Check Platform Set Variable [ $Plat; Value:Get ( SystemPlatform ) ] If [ $Plat = 1 ] Set Variable [ $Test; Value:MBS( "Plugin.PrepareForUpdate" ) ] # Mac Install Plug-In File [ Install Plugin Update if needed::Plugin File Mac ] Else If [ $Plat = 3 ] # iOS Exit Script [ ] Else If [ $Plat = 4 ] # Web Direct If [ MBS( "IsWindows" ) = 1 ] # Win Server Install Plug-In File [ Install Plugin Update if needed::Plugin File Win 64bit ] Else # Mac Server Install Plug-In File [ Install Plugin Update if needed::Plugin File Mac ] End If Else If [ $Plat = 5 or $Plat = 8 ] # FileMaker Cloud Install Plug-In File [ Install Plugin Update if needed::Plugin File Linux ] Else If [ $Plat = -2 ] # Win If [ $Arch = "x86_64" ] # Win 64-bit Install Plug-In File [ Install Plugin Update if needed::Plugin File Win 64bit ] Else # Win 32-bit Install Plug-In File [ Install Plugin Update if needed::Plugin File Win 32bit ] End If Else # something new or old? Exit Script [ ] End If Set Variable [ $LastError; Value:Get(LastError) ] Set Variable [ $LastErrorMessage; Value:Get(LastExternalErrorDetail) ] Pause/Resume Script [ Duration (seconds): ,2 ] If [ $LastError = 0 ] If [ MBS("VersionAutoUpdate") = Install Plugin Update if needed::Version Number ] Show Custom Dialog [ Title: "Success"; Message: "Installed MBS Plugin: " & MBS("Version"); Default Button: “OK”, Commit: “Yes” ] Else Show Custom Dialog [ Title: "Success"; Message: "Installed MBS Plugin: " & Install Plugin Update if needed::Version Display & ¶ & "Please restart FileMaker."; Default Button: “OK”, Commit: “Yes” ] End If Else Show Custom Dialog [ Title: "Failed"; Message: "Failed to install plugin due to error " & $LastError & ¶ & $LastErrorMessage; Default Button: “OK”, Commit: “Yes” ] End If
Fields used in this script	Install Plugin Update if needed::Plugin File Mac Install Plugin Update if needed::Plugin File Win 64bit Install Plugin Update if needed::Plugin File Linux Install Plugin Update if needed::Plugin File Win 32bit Install Plugin Update if needed::Version Number Install Plugin Update if needed::Version Display
Scripts used in this script
Layouts used in this script
Tables used in this script	Install Plugin Update if needed
Table occurrences used by this script	Install Plugin Update if needed
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [Install MBS Plugin]

Next Script: [Copy Version Numbers]

Script Name	Check If Update is Needed
Run script with full access privileges	Off
Include In Menu	Yes
Layouts that use this script	Install Plugin Update if needed
Scripts that use this script
Script Definition
Script Steps	#Check what plugin version we have here in the database: Go to Layout [ “Install Plugin Update if needed” ] Go to Record/Request/Page [ First ] Set Variable [ $DatabaseVersion; Value:GetAsNumber(Install Plugin Update if needed::Version Number) ] Set Variable [ $InstalledVersion; Value:GetAsNumber(MBS("VersionAutoUpdate")) ] Set Variable [ $InstalledVersionText; Value:GetAsText(MBS("Version")) ] If [ GetAsNumber($InstalledVersion) = "?" ] #not installed Show Custom Dialog [ Message: "MBS Plugin is not installed. Can we install version " & Install Plugin Update if needed::Version Display & " is of MBS plugin now?"; Default Button: “Install”, Commit: “Yes”; Button 2: “Later”, Commit: “Yes” ] If [ Get ( LastMessageChoice ) = 1 ] Perform Script [ “Install MBS Plugin” ] End If Else If [ $InstalledVersion = $DatabaseVersion ] #current version Show Custom Dialog [ Message: "Already up to date"; Default Button: “OK”, Commit: “Yes”; Button 2: “Abbrechen”, Commit: “No” ] Else If [ $InstalledVersion > $DatabaseVersion ] #newer version Show Custom Dialog [ Message: "Already up to date. Installed version " & $InstalledVersionText & " is newer than version " & Install Plugin Update if needed::Version Display & " in database."; Default Button: “OK”, Commit: “Yes”; Button 2: “Abbrechen”, Commit: “No” ] Else #found update Show Custom Dialog [ Message: "Newer Version " & Install Plugin Update if needed::Version Display & " is available. Install now?" & ¶ & "You have version " & $InstalledVersionText; Default Button: “Install”, Commit: “Yes”; Button 2: “Later”, Commit: “Yes” ] If [ Get ( LastMessageChoice ) = 1 ] Perform Script [ “Install MBS Plugin” ] End If End If #go to fields to update them Go to Field [ Install Plugin Update if needed::MBS Installed ] Go to Field [ Install Plugin Update if needed::MBS Installed Version ] Go to Field [ Install Plugin Update if needed::MBS Installed Version Number ] Commit Records/Requests [ Skip data entry validation; No dialog ]
Fields used in this script	Install Plugin Update if needed::Version Number Install Plugin Update if needed::Version Display Install Plugin Update if needed::MBS Installed Install Plugin Update if needed::MBS Installed Version Install Plugin Update if needed::MBS Installed Version Number
Scripts used in this script	Install MBS Plugin
Layouts used in this script	Install Plugin Update if needed
Tables used in this script	Install Plugin Update if needed
Table occurrences used by this script	Install Plugin Update if needed
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [Check If Update is Needed]

Next Script: [Clear]

Script Name	Copy Version Numbers
Run script with full access privileges	Off
Include In Menu	Yes
Layouts that use this script	Install Plugin Update if needed
Scripts that use this script
Script Definition
Script Steps	Set Field [ Install Plugin Update if needed::Version Number; Install Plugin Update if needed::MBS Installed Version Number ] Set Field [ Install Plugin Update if needed::Version Display; Install Plugin Update if needed::MBS Installed Version ]
Fields used in this script	Install Plugin Update if needed::MBS Installed Version Number Install Plugin Update if needed::Version Number Install Plugin Update if needed::MBS Installed Version Install Plugin Update if needed::Version Display
Scripts used in this script
Layouts used in this script
Tables used in this script	Install Plugin Update if needed
Table occurrences used by this script	Install Plugin Update if needed
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [Copy Version Numbers]

Next Script: [Query version for Windows]

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	Set Field [ Install Plugin Update if needed::Version Display; "" ] Set Field [ Install Plugin Update if needed::Version Number; "" ]
Fields used in this script	Install Plugin Update if needed::Version Display Install Plugin Update if needed::Version Number
Scripts used in this script
Layouts used in this script
Tables used in this script	Install Plugin Update if needed
Table occurrences used by this script	Install Plugin Update if needed
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [Clear]

Next Script: [Query version for Linux]

Script Name	Query version for Windows
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	#get it as text Set Variable [ $InfoText; Value:MBS( "Container.GetText"; Install Plugin Update if needed::Plugin File Win 64bit; "FILE"; "Windows") ] #text like this: MBS FileMaker Plugin, version 11.2.0.03, built Apr 16 2021 Set Variable [ $version; Value:MBS( "RegEx.Extract"; $infoText; "MBS FileMaker Plugin (\d+.\d+.\d+.\d+)"; "\1"; "greedy, caseless" ) ] Show Custom Dialog [ Title: "MBS Version"; Message: $version; Default Button: “OK”, Commit: “Yes”; Button 2: “Cancel”, Commit: “No” ]
Fields used in this script	Install Plugin Update if needed::Plugin File Win 64bit
Scripts used in this script
Layouts used in this script
Tables used in this script	Install Plugin Update if needed
Table occurrences used by this script	Install Plugin Update if needed
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [Query version for Windows]

Next Script: [Query version for macOS]

Script Name	Query version for Linux
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 [ $InfoText; Value:MBS( "Container.GetText"; Install Plugin Update if needed::Plugin File Linux; "FILE") ] #text like this: MBS FileMaker Plugin, version 11.2.0.03, built Apr 16 2021 Set Variable [ $version; Value:MBS( "RegEx.Extract"; $infoText; "MBS FileMaker Plugin, version (\d+.\d+.\d+.\d+),"; "\1"; "greedy, caseless" ) ] Show Custom Dialog [ Title: "MBS Version"; Message: $version; Default Button: “OK”, Commit: “Yes”; Button 2: “Cancel”, Commit: “No” ]
Fields used in this script	Install Plugin Update if needed::Plugin File Linux
Scripts used in this script
Layouts used in this script
Tables used in this script	Install Plugin Update if needed
Table occurrences used by this script	Install Plugin Update if needed
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [Query version for Linux]

Next Script: [Load Plugin from Server]

Script Name	Query version for macOS
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	#extract info file with metadata Set Variable [ $InfoFile; Value:MBS( "Archive.ExtractFile"; Install Plugin Update if needed::Plugin File Mac; "MBS.fmplugin/Contents/Info.plist" ) ] #get it as text Set Variable [ $InfoText; Value:MBS( "Container.GetText"; $InfoFile; "FILE") ] #query version entry in XML Set Variable [ $version; Value:MBS( "RegEx.Extract"; $infoText; "<key>CFBundleVersion</key>\s<string>(.)</string>"; "\1"; "greedy, caseless" ) ] Show Custom Dialog [ Title: "Version of MBS Plugin"; Message: $version; Default Button: “OK”, Commit: “Yes”; Button 2: “Cancel”, Commit: “No” ]
Fields used in this script	Install Plugin Update if needed::Plugin File Mac
Scripts used in this script
Layouts used in this script
Tables used in this script	Install Plugin Update if needed
Table occurrences used by this script	Install Plugin Update if needed
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [Query version for macOS]

Script Name	Load Plugin from Server
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	#normal release here Set Variable [ $URL; Value:"https://www.monkeybreadsoftware.com/filemaker/files/gzip/version.json" ] Set Variable [ $JSON; Value:"" ] Insert from URL [ $JSON; $URL; cURL options: "--FM-text-encoding utf-8 --location --max-time 10 " ] [ Do not automatically encode URL; Select; No dialog ] If [ Get(LastError) ≠ 0 ] Show Custom Dialog [ Title: "Failed to query MBS server."; Message: Get(LastExternalErrorDetail); Default Button: “OK”, Commit: “Yes” ] Exit Script [ Result: "Failed to query server." ] End If Set Variable [ $date; Value:JSONGetElement ( $json ; "date" ) ] Set Variable [ $versionNumber; Value:JSONGetElement ( $json ; "versionNumber" ) ] Set Variable [ $versionText; Value:JSONGetElement ( $json ; "versionText" ) ] Set Variable [ $URLMac; Value:JSONGetElement ( $json ; "download.mac" ) ] Set Variable [ $URLWin32; Value:JSONGetElement ( $json ; "download.win32" ) ] Set Variable [ $URLWin64; Value:JSONGetElement ( $json ; "download.win64" ) ] Set Variable [ $URLLinux; Value:JSONGetElement ( $json ; "download.linux" ) ] Set Variable [ $LoadedCount; Value:0 ] #Load Windows 32-bit Set Variable [ $Result; Value:"" ] Insert from URL [ $result; $URLWin32; cURL options: "--FM-return-container-variable --location " ] [ Do not automatically encode URL; Select; No dialog ] If [ Get(LastError ) = 0 and Length($Result) > 1000000 ] Set Field [ Install Plugin Update if needed::Plugin File Win 32bit; $result ] Commit Records/Requests [ No dialog ] Set Variable [ $LoadedCount; Value:$LoadedCount + 1 ] End If #Load Windows 64-bit Set Variable [ $Result; Value:"" ] Insert from URL [ $Result; $URLWin64; cURL options: "--FM-return-container-variable --location " ] [ Do not automatically encode URL; Select; No dialog ] If [ Get(LastError ) = 0 and Length($Result) > 1000000 ] Set Field [ Install Plugin Update if needed::Plugin File Win 64bit; $result ] Commit Records/Requests [ No dialog ] Set Variable [ $LoadedCount; Value:$LoadedCount + 1 ] End If #Load macOS Set Variable [ $Result; Value:"" ] Insert from URL [ $Result; $URLMac; cURL options: "--FM-return-container-variable --location " ] [ Do not automatically encode URL; Select; No dialog ] If [ Get(LastError ) = 0 and Length($Result) > 1000000 ] Set Field [ Install Plugin Update if needed::Plugin File Mac; $result ] Commit Records/Requests [ No dialog ] Set Variable [ $LoadedCount; Value:$LoadedCount + 1 ] End If #Load Linux Set Variable [ $Result; Value:"" ] Insert from URL [ $Result; $URLLinux; cURL options: "--FM-return-container-variable --location " ] [ Do not automatically encode URL; Select; No dialog ] If [ Get(LastError ) = 0 and Length($Result) > 1000000 ] Set Field [ Install Plugin Update if needed::Plugin File Linux; $result ] Commit Records/Requests [ No dialog ] Set Variable [ $LoadedCount; Value:$LoadedCount + 1 ] End If #all done If [ $LoadedCount > 0 ] Set Field [ Install Plugin Update if needed::Version Display; $versionText ] Set Field [ Install Plugin Update if needed::Version Number; $versionNumber ] Commit Records/Requests [ No dialog ] End If Show Custom Dialog [ Title: "Plugins loaded"; Message: "Loaded " & $LoadedCount & " of 4 plugin files."; Default Button: “OK”, Commit: “Yes” ]
Fields used in this script	Install Plugin Update if needed::Plugin File Win 32bit Install Plugin Update if needed::Plugin File Win 64bit Install Plugin Update if needed::Plugin File Mac Install Plugin Update if needed::Plugin File Linux Install Plugin Update if needed::Version Display Install Plugin Update if needed::Version Number
Scripts used in this script
Layouts used in this script
Tables used in this script	Install Plugin Update if needed
Table occurrences used by this script	Install Plugin Update if needed
Custom Functions used by this script
Custom menu set used by this script

Download example: Install Plugin Update if needed

Used functions: