Our Blog, FileMaker only, Xojo only, Archive (older)     Follow us on Twitter, Xing, LinkedIn or Facebook.

MBS FileMaker Plugin, version 10.3pr8

New in this prerelease of version 10.3 of the MBS FileMaker Plugin: Download at monkeybreadsoftware.com/filemaker/files/Prerelease/ or ask for being added to the dropbox shared folder.

Using DebugBar in FileMaker for IE WebViewer

We heard the cries for an inspector for Windows and looked around for help. Recently we found Firebug, but that only works if you install it on the same domain. Our search continued and we found DebugBar, an extension for Internet Explorer and it still works in Windows 10, so we worked on an integration into FileMaker as DebugBar doesn't do that as is.

For MBS FileMaker Plugin 10.3 we add the new WebView.ShowDebugBar function. Our plugin will look for the web view in the FileMaker window, then create a new window and host there the DebugBar component. Looks like this:

We have four tabs there. The first one allows you to inspect the DOM and you can use the green picker to select an element on the web site. If you move the mouse over one of the elements in the DOM tree, the element highlights on the website. You can also inspect styles and modify all in the text field below.

The HTTPs tab currently doesn't work, so check the Script tab, where you can see all JavaScripts, adjust them and execute some JavaScript right in the window. See screenshot below:

There are a few issues and we'll see if we can resolve a few with the developers from DebugBar to make this as useful as possible for you. And they certainly appreciate if you buy a DebugBar license.

See   DebugBar website   Download   Features   Order

Please don't hesitate to contact us with your questions.


Vorübergehend bis zum Jahresende wurde in Deutschland die MWSt. von 19% auf 16% gesenkt.

Wenn Sie eine MBS Plugin Lizenz kaufen und aus Deutschland kommen, aber nicht vorsteuerabzugsberechtigt sind, können Sie ca. 2.5% sparen beim Einkaufspreis.

Für alle Geschäftskunden ändert sich effektiv nichts, weil Sie die Steuer ja verrechnet bekommen beim Vorsteuerabzug.

[English] VAT rate in Germany changed temporarily from 19% to 16%. While we appreciate a tax reduction, it's a hassle to implement for everyone with a shop, doesn't save much money for tax payers, but creates a big hole in the budget for the government.

FileMaker records to XML or JSON

Sometimes you need to query FileMaker records as XML or JSON data and include related records. This can be tricky to do in pure FileMaker scripts and calculations, but via MBS FileMaker Plugin we can provide help. Our FM.SQL.Execute function can use SQL to fetch records. The FM.SQL.CSV, FM.SQL.JSONRecord and FM.SQL.JSONRecords functions can help to pack those in comma/tab separated text or JSON. New for next plugin version are FM.SQL.XMLRecord and FM.SQL.XMLRecords functions to do for XML what we had for JSON already. 

Below we have a sample script to use FM.SQL.XMLRecords to get records from two tables and insert the related records in the right position in the XML with our XML.SetPathXML function.

# SQL XML in file Contacts

# Run query to fetch some records

Set Variable [ $sql1 ; Value: MBS( "FM.SQL.Execute"; ""; "SELECT \"PrimaryKey\", \"First Name\", \"Last Name\", \"Company\", \"Title\" FROM Contacts") ] 

# get them as XML

Set Variable [ $xml ; Value: MBS( "FM.SQL.XMLRecords"; $sql1; "people"; "person"; "ID¶First¶Last¶Company¶Title"; 2+1) ] 


# loop over records to look for related record

Set Variable [ $count ; Value: MBS( "FM.SQL.RowCount"; $sql1 ) ] 

Set Variable [ $index ; Value: 0 ] 

If [ $index ≤ $count ] 


# get primary key from result

Set Variable [ $key ; Value: MBS( "FM.SQL.Field"; $sql1; $index; 0 ) ] 

# Run query for related records

Set Variable [ $sql2 ; Value: MBS( "FM.SQL.Execute"; ""; "SELECT Type, Number FROM \"Phone Numbers\" WHERE ForeignKey = ?"; $key) ] 

# get them as XML

Set Variable [ $xml2 ; Value: MBS( "FM.SQL.XMLRecords"; $sql2; "phones"; "phone"; "Type¶Number"; 2+1) ] 

# Now insert them in the person node as new child phones

Set Variable [ $xml ; Value: MBS( "XML.SetPathXML"; $xml; "people.person[" & $index &"].phones"; 0; $xml2 ) ] 

# don't forget to release memory

Set Variable [ $r ; Value: MBS( "FM.SQL.Release"; $sql2) ] 


# next

Set Variable [ $index ; Value: $index + 1 ] 

Exit Loop If [ $index ≥ $count ] 

End Loop

End If


# don't forget to release memory

Set Variable [ $r ; Value: MBS( "FM.SQL.Release"; $sql1) ] 

# Output the XML with format & color

Set Field [ Contacts::XML ; MBS("XML.Colorize"; MBS("XML.Format"; $xml)) ] 

We hope this helps people interested in XML exports. Same technique can be used with our JSON functions to build similar JSON structures.

PS: Script text copied with color using our copy button in Script Workspace.

Using WolfSSL and custom CURL functions

The fine people at WolfSSL have a few impressive products around SSL, Encryption and SSH with an emphasis on the performance and on a small footprint. Since CURL already offers multiple SSL backends, we could build our plugins using wolfSSL.

CURL is doing well and we are using it now for over 10 years in our plugins for various tasks including HTTP, FTP, SFTP and email via IMAP or SMTP protocols. See the state of CURL video where Daniel explains the progress.

Compared to the OpenSSL library we use currently for most things, wolfSSL has a lot to offer:
  • If you are concerned about memory usage, check wolfSSL as it uses less memory.
  • When you need a cross platform SSL library, it offers latest TLS 1.3 with DTLS 1.2.
  • They include hardware support for encryption, so if you have acceleration hardware in your computer, they can use it.
  • While wolfSSL has its own interface, they also have a compatibility interface matching OpenSSL, so a transition would be easy.
  • You may benefit from additional progressive ciphers such as ChaCha20, Curve25519, NTRU, and Blake2b.
  • wolfSSL can be used for free with the GPL license option or used with commercial license and they offer paid support.
If you have a need for use of wolfSSL, please let us know. We can offer to use CURL functions using wolfSSL as SLL backend for your projects in Xojo and FileMaker.

Together with wolfSSL, we can offer customization to CURL library itself. We corodinate with Daniel Stenberg from wolfSSL to get changes made for you in CURL and then integrate those into our plugin functionality to get you the features you need the most.

See also wolfSSL vs. OpenSSL and CURL at wolfSSL.

Please contact us if you are interested in some special CURL modifications or use of wolfSSL and related products in FileMaker or Xojo.

Using Sharing Services in MacOS with FileMaker

With next MBS FileMaker Plugin (already in 10.3pr7 to try), you are able to trigger the sharing services in macOS from FileMaker. You can pass images, URLs, styled text and native file paths to various services. Not just one value, but several, e.g.

  • Send text and image to Messages
  • Send files, text, images, URLs, subject and recipients to Apple Mail
  • Send pictures to Photos application
  • Send text and URLs to reminders or notes applications
  • Send files via AirDrop to other users
  • Send URLs to reader list in Safari
  • Send PDF to Books application
  • Send picture to make it the desktop background

More services are available, for example when you install other applications.


Firebug as Web Inspector for FileMaker on Windows

Did you know the old Firebug (ceased in 2017) can still be used in a web viewer in FileMaker on Windows?

We got it to work here for some development:

Allows to open a console, do some inspection in DOM tree and CSS rules. It even allows you to select object in the html page with mouse to inspect. And can optionally run in a separate window.

But sadly it is long outdated, so may not know latest JavaScript tricks or have some bugs. And doesn't work with more than 1x resolution of screen as far as I see. But otherwise may be a help here to debug JavaScript with IE 11 within FileMaker's web viewer. For installation in FileMaker, you can run the JavaScript to initialize via WebView.RunJavaScript via our plugin.

Vier Monate bis zur Deutschen FileMaker Konferenz 2020 in Malbun

Noch vier Monate bis zur FileMaker Konferenz 2020 in Malbun (Liechtenstein).

Vom 28. bis 31. Oktober findet die elfte deutschsprachige FileMaker Konferenz im JUFA Hotel in Malbun, Liechtenstein statt. Ursprünglich geplant für Juni muss die Veranstaltung leider in den Oktober verschoben werden. Wir hoffen dennoch auf tolles Wetter, viele Interessante Teilnehmer und Gespräche. Eventuell könnte das die einzige Konferenz rund um FileMaker in diesem Jahr werden, die vor Ort stattfindet.

Ein MBS Schulungstag ist für den Mittwoch vorher geplant. Bei Interesse kann man sich gerne bei uns anmelden. Die Ankündigung liegt hier: MBS Workshop

Die Veranstalter vom Verein FM Konferenz erwarten auch 2020 rund 120 Entwickler, Anwender, IT-Fachleute und Entscheidungsträger aus Wirtschaft, Bildung und Verwaltung. Rund um über 20 Fachvorträge und Workshops wird es viel Zeit zum Vernetzen in den gemeinsamen Pausen und beim Abendprogramm geben.

Für den Deutschsprachigen Raum ist diese Konferenz das Treffen des Jahres. Hier finden Sie vom Anfänger bis zum Profi Kontakte zu anderen Entwicklern. Lernen Sie was es neues gibt, nehmen Sie Impulse mit für die eigene Arbeit und erfahren Sie mehr zu FileMaker von deutschsprachigen Experten!
Bitte planen Sie wenigstens einen extra Tag ein für ihren Besuch in Liechtenstein, damit Sie die Natur in dem schönen Tal geniessen können. Den Aufstieg auf den Sareis können Sie bequem zu Fuß vom Hotel aus starten und die Turnastraße hinauf spazieren bis zum Restaurant am Gipfel. Oder alternativ die Seilbahn nehmen.

MBS FileMaker Plugin, version 10.3pr7

New in this prerelease of version 10.3 of the MBS FileMaker Plugin:
  • MBS FileMaker Plugin compiles for Apple Silicon, so we are ready.
  • Added Hex and Base64 as text encodings, so lots of functions can take those and decode/encode automatically.
  • Rewrote Font.Activate and Font.Deactivate for newer macOS versions.
  • Changed stored license handling for iOS to now show expired dialog when an old license is stored in preferences file.
  • Added script name comment to copied scripts.
Download at monkeybreadsoftware.com/filemaker/files/Prerelease/ or ask for being added to the dropbox shared folder.

FileMaker Magazin - MBS Artikel

Wir haben die Artikel zum MBS Plugin aus dem FileMaker Magazin gesammelt hier online gestellt: FileMaker Magazin Artikel.

Wir empfehlen allen FileMaker Anwender ein Abo vom Magazin und den Kauf der alten Ausgaben.
Das FileMaker Magazin ist eine exzellente Quelle von Informationen, Anleitungen und Profitips.

MBS Workshop in Malbun bei der FileMaker Konferenz

In Zusammenarbeit mit dem Verein FM Konferenz bieten wir eine Schulung zum MBS Plugin an. Am 28. Oktober 2020 können Sie in Malbun, Liechtenstein an einer eintägigen Schulung teilnehmen. Lernen Sie die über 6000 Funktionen einmal näher kennen und wie Sie sie effektiv einsetzen. Sammeln Sie Ideen und verbessern Sie ihre FileMaker Lösungen durch den Einsatz unseres Plugins.

Das Monkeybread Software Plugin für FileMaker stellt eine vielseitige Erweiterung der eigenen Datenbank dar. Der Kurs bietet nicht nur einen tiefgreifenden Überblick in die Benutzung und Entwicklung, sondern bietet auch die Chance das Plugin günstiger zu erstehen.
  • Einführung in das MBS Plugin
  • Überblick über die Funktionsbereiche
  • Neues im MBS Plugin dieses Jahr und in der dann aktuellen Version
  • Rundgang durch ausgewählte Beispiele
  • Gemeinsames Implementieren von Plugin Funktionen in eine Datenbank.
    • Upload/Download mit CURL auf einen HTTP/FTP Server
    • Ausfüllen eines Formulars auf einer Webseite
    • Bilder bearbeiten
    • PDF Verarbeitung
    • Druckerfunktionen
    • Barcodes und Zahlungsscheine
    • Einbinden von Webservices with JSON/XML für REST/SOAP.
    • Senden und Empfangen von Emails.
  • Fragen und Antworten
Die Teilnahme kostet 200 CHF inkl. Verpflegung und MWSt.. Trainer ist der Plugin Entwickler und Monkeybread Software Geschäftsführer Christian Schmitz persönlich. Beginn gegen 9 Uhr und Ende gegen 16 Uhr.

Anmeldung bei Monkeybread Software.

Am Abend vorher treffen wir uns zum gemütlichen Beisammensein im Restaurant vom Konferenzhotel. Im Anschluss an die Schulung können Sie gleich rüber zum Apero gehen und die anderen Teilnehmer kennen lernen. Wegen Covid-19 besteht die Möglichkeit, dass Veranstaltungen ausfallen müssen. Das wird sich eventuell erst kurzfristig entscheiden. Aktuell ist Liechtenstein Covid-19 frei und die Grenzen sind offen. Wir bitten um baldige Anmeldung und können für unsere Schulungen eine kostenlose Stornierung anbieten.

Bei Fragen und Themenwünschen melden Sie sich bitte direkt bei uns.

MBS FileMaker Plugin, version 10.3pr6

New in this prerelease of version 10.3 of the MBS FileMaker Plugin: Download at monkeybreadsoftware.com/filemaker/files/Prerelease/ or ask for being added to the dropbox shared folder.

Apple Silicon

We watched the Apple WWDC keynote. From all the announcements Apple made, the one causing the most work for us, will be the transition to Apple Silicon, their own CPUs based on the ARM 64-bit design.

As the rumors were around, we expected that to come and look forward to see what they can do. We started already and got Xcode 12 beta and built our plugins for ARM. It works mostly and a few little adjustments are needed. Currently it doesn't link yet as libraries are still in need to be rebuild. We started to build various libraries and I can say zlib, openssl, curl, sqlite, png and others build just fine.

Building them doesn't mean everything will work, so we have to wait for a test device to show up here. But that may happen in the next weeks.

We will be ready when the first devices go to public and Claris or Xojo ship their updated applications to use with our plugins.

But such a change reiterates how important it is to work with supported applications, where some developer takes care and provides regularly updates. In the last 5 years, a lot of clients came back to ask for 64-bit versions for MacOS, Windows and Linux as all operation systems moved to 64-bit. Now quite a few will come back to ask for ARM versions later this year.

Update: It's Friday, 26th June and I am done. All plugins for Xojo and FileMaker build for Apple Silicon. Once the test Mac arrives, we can try them.

Search shortcut for Script Workspace

For MBS FileMaker Plugin 10.3 we added a new shortcut with Command-Shift-F to jump focus in the search field for the script list in the Claris FileMaker Pro Script Workspace.

In Script Workspace:
⌘ ⇧ F to set focus to script list search.
⌘ Fto set focus to search field for current script.
⌘ + zooms in.
⌘ -zooms out.
⌘ =zooms to 100%.

In text areas like custom function editor:
⌘ Rshows rulers.
⌘ Ishows invisible characters
⌘ Fshows find bar.
⌘ Ggoes to next found text.
⌘ ⌥ Ccopies styled text.

In a list showing in the FileMaker, e.g. list of fields:
⌘ Ccopies content.
⌘ Fshows find bar.
⌘ Ggoes to next found text.
⌘ + zooms in.
⌘ -zooms out.
⌘ =zooms to 100%.

In relationship dialog:
⌘ Fsets focus to search field.

Please enjoy and if you have questions, please don't hesitate to contact us.

MBS FileMaker Plugin, version 10.3pr5

New in this prerelease of version 10.3 of the MBS FileMaker Plugin: Download at monkeybreadsoftware.com/filemaker/files/Prerelease/ or ask for being added to the dropbox shared folder.

Moved to macOS Catalina

Finally we moved to macOS Catalina just before the next version is announced on Monday at WWDC. On the way there a few apps stopped working like the older Real Studio and FileMaker versions. DragThing didn't make to the new OS and for some old buddies like Fetch, we got updates.

The old Xcode 9.4 doesn't work any more, so that may be the end of the 32-bit Mac plugin for FileMaker here. You can still get version 10.2 from us in 32-bit if needed, e.g. you still have FileMaker 13 and need to use the plugin to push data as JSON e.g. to the DATA API in newer FileMaker servers.

For Xojo the 32-bit Mac compilation via command line still works, so we can keep that a bit longer, but can't test anymore here without a VM. We now build 32-bit and 64-bit MacOS plugin via command line using Xcode 11.5.

One thing we had to adjust a lot of file paths is that, we can't put a folder any more on root folder of the start volume. The disk now has internally two partitions with a read only one for the system and a writable with my data. Great to protect me against applications trying to hack into the system. But inconvenient as I had to move my build system to move a folder in my user folder.

As the new MacOS version is upcoming, we will mark a couple of classes/functions as deprecated, e.g. Addressbook functions. Please move to newer Contacts functions as we are not sure whether Apple will keep the older APIs around in case they change something like the CPU architecture.

Set initial file for FileMaker 19 by script

Did you see the new feature in FileMaker Pro version 19 about setting an initial file to open when you launch FileMaker?

You can set this by script with MBS FileMaker Plugin by using Preferences.SetValue or Registry.SetValue functions as you see below.


For MacOS you can use our Preferences.SetValue function to set the preferences value for "Preferences:UseInitialfile" to 1 to enable or 0 to disable. The preference value "Preferences:Initialfile" uses a Mac specific FileMaker path to the file to open. Here are the two MBS calls to setup a new path:

MBS( "Preferences.SetValue"; "com.filemaker.client.pro12"; "Preferences:UseInitialfile"; 1; "integer") &
MBS( "Preferences.SetValue"; "com.filemaker.client.pro12"; "Preferences:Initialfile"; "filemac:/Mac/Users/cs/Documents/Test.fmp12"; "text")


For Windows the preferences are stored in the registry, so you need to know the right key. There we set UseInitialfile with 1 or 0 to enable or disable with data type DWORD. The file path to the file is provided as a FileMaker path with filewin: prefix. Here is a sample call:

MBS( "Registry.SetValue"; "HKEY_CURRENT_USER\SOFTWARE\FileMaker\FileMaker Pro\19.0\Preferences"; "UseInitialfile"; 1; "DWORD") &
MBS( "Registry.SetValue"; "HKEY_CURRENT_USER\SOFTWARE\FileMaker\FileMaker Pro\19.0\Preferences"; "Initialfile"; "filewin:/C:/Users/Christian/Desktop/JavaScript.fmp12"; "text")


To automate installation on dozens of computers, you could do this by script when solution launches to define the file to open for next start. e.g. automatically install FileMaker, send user a welcome email and have them click fmp:// URL. That URL can trigger FileMaker to launch, open a remote database on the server as guest and show a welcome layout. And in a script to setup, you could define what file to open next time. And of course that file could be written to documents folder by script via an Export Field Contents script step. Please only do those steps with user consent!

To remove, you could set UseInitialfile flag to zero. To clear the path, you can use Preferences.DeleteValue and Registry.DeleteValue functions if needed.

Update: This works in FileMaker 18 even as there is no preferences. But it seems to work for us if you set the path.

If you have questions, please do not hesitate to contact us.

MBS FileMaker Plugin, version 10.3pr4

New in this prerelease of version 10.3 of the MBS FileMaker Plugin: Download at monkeybreadsoftware.com/filemaker/files/Prerelease/ or ask for being added to the dropbox shared folder.

Claris Partner Connect

Our company Monkeybread Software, legally Christian Schmitz Software GmbH, has been named a Claris Partner Connect: Find a Claris Partner.

Earlier this year Claris Inc. introduced their Claris Connect service and made a series of webinars to learn inform all partners about it. In one of the webinars they defined the challenge that interested partners can be come a Connect partner by fulfilling a few things. For us my co-worker Stefanie Juchmes made this for us.

Congratulations to Stefanie for doing this. And doing this in English is even more difficult for a non-native English speaker.

We look forward for Claris Connect starting in Europe with local servers and to get the details on how to integrate other services there, so maybe we can create a few for our clients.

PS: Looks like we are the first to do this in Germany.

MBS FileMaker Plugin Presentation

Stefanie made a German version for the English MBS Plugin FileMaker presentation I made earlier this month:

Watch on Youtube   All our movies   Watch on Youtube in English.

We uploaded presentation slides to our website, too.

Please do not hesitate to contact us if you have questions.

Older blog entries:

2020-06-12 Swiss QR-Codes for invoices as vector graphics
2020-06-12 MBS FileMaker Plugin, version 10.3pr3
2020-06-10 FileMaker 19 improves layering of controls
2020-06-08 MBS FileMaker Plugin, version 10.3pr2
2020-06-07 How FileMaker.PerformScript triggers scripts
2020-06-05 Working with Webkit Message Handlers in FileMaker
2020-06-04 Dash help archives for FileMaker 19
2020-06-04 FileMaker 19 - Exklusives Online Launch Event bei der Denkform
2020-06-02 MBS FileMaker Plugin Presentation
2020-06-02 Sponsoring DotFMP 2020
2020-06-01 MBS FileMaker Plugin, version 10.3pr1
2020-05-30 SQLite turned 20
2020-05-28 JWT RS256 authentication in FileMaker
2020-05-28 5 Monate bis zur Deutschen FileMaker Konferenz 2020 in Malbun
2020-05-26 More customization for Claris FileMaker Web Direct
2020-05-23 The FileMaker.PerformScript function in FileMaker 19
2020-05-22 Disable Dark Mode for FileMaker 19 application
2020-05-22 Checkout Machine Learning features in FileMaker
2020-05-21 Check out options for FileMaker JavaScript Integration
2020-05-20 Welcome FileMaker 19


Jul 2020
Jun 2020
May 2020
Apr 2020
Mar 2020
Feb 2020
Jan 2020
Dec 2019
Nov 2019
Oct 2019
Sep 2019
Aug 2019
Jul 2019
Jun 2019
May 2019
Apr 2019
Mar 2019
Feb 2019
Jan 2019
Dec 2018
Nov 2018
Oct 2018
Sep 2018
Aug 2018
Jul 2018
Jun 2018
May 2018
Apr 2018
Mar 2018
Feb 2018
Jan 2018
Dec 2017
Nov 2017
Oct 2017
Sep 2017
Aug 2017
Jul 2017
Jun 2017
May 2017
Apr 2017
Mar 2017
Feb 2017
Jan 2017
Dec 2016
Nov 2016
Oct 2016
Sep 2016
Aug 2016
Jul 2016
Jun 2016
May 2016
Apr 2016
Mar 2016
Feb 2016
Jan 2016
Dec 2015
Nov 2015
Oct 2015
Sep 2015
Aug 2015
Jul 2015
Jun 2015
May 2015
Apr 2015
Mar 2015
Feb 2015
Jan 2015
Dec 2014
Nov 2014
Oct 2014
Sep 2014
Aug 2014
Jul 2014
Jun 2014
May 2014
Apr 2014
Mar 2014
Feb 2014
Jan 2014
Dec 2013
Nov 2013
Oct 2013
Sep 2013
Aug 2013
Jul 2013
Jun 2013
May 2013
Apr 2013
Mar 2013
Feb 2013
Jan 2013
Dec 2012
Nov 2012
Oct 2012
Sep 2012
Aug 2012
Jul 2012
Jun 2012
May 2012
Apr 2012
Mar 2012
Feb 2012
Jan 2012
Dec 2011
Nov 2011
Oct 2011
Sep 2011
Aug 2011
Jul 2011
Jun 2011
May 2011
Apr 2011
Mar 2011
Feb 2011
Jan 2011
Dec 2010
Nov 2010
Oct 2010
Sep 2010
Aug 2010
Jul 2010
Jun 2010
May 2010
Apr 2010
Mar 2010
Feb 2010
Jan 2010
Dec 2009
Nov 2009
Oct 2009
Sep 2009
Aug 2009
Jul 2009
Apr 2009
Mar 2009
Feb 2009
Dec 2008
Nov 2008
Oct 2008
Aug 2008
May 2008
Apr 2008
Mar 2008
Feb 2008
XML: RSS Feed XML: Atom Feed