JSON Query in FileMaker

Recently we got a request for JSONPath queries in FileMaker, so we looked into various ways on how to implement this. We found a way and got three new functions for you:

Please try them, e.g. run a query against them.


FileMaker 2023, second release

Claris released today FileMaker 2023 in version 20.2.1.

You get an integration to Claris Connect and Claris Studio. You can now place text with calculations directly on a layout. FileMaker is compatible to macOS Sonoma with some known issues and you may enjoy a few bug fixes. But please read details in the release notes:


FileMaker Pro 20.2.1 release notes
FileMaker Go 20.2.1 release notes
FileMaker Server 20.2.1 release notes

macOS Sonoma (14.0) and iOS 17 compatibility

You can download it on the ESD website. The link is in the license email from Claris.

For MBS Plugin, just make sure you have a 13.x version. We fixed a few minor things over the beta test period, so recommended version is 13.4.

MBS FileMaker Plugin, version 13.5pr1

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

News in MBS FileMaker Plugin 13.4

In this article we want to introduce you the new functions from the MBS FileMaker Plugin in version 13.4.


Let's start with the most comprehensive and coolest new feature of the release: Phidgets. Phidgets are small additional devices that you can connect to your computer and with which you can then input or output data. For example you can connect a small motor, a temperature sensor, a humidity sensor, a gyroscope or a small LED display and exchange data with these devices. Since a few years we already have a plugin for Xojo, which allows the interaction with these small devices and we are proud to offer the use of these small devices now also for FileMaker.

With Phidget.Load we first load the Phidget library we want to work with. With Phidget.Create we create an instance of a Phidget channel. Once created the channel may need to be configured to match the physical device and channel index you want to attach to, and then be opened by calling Phidget.Open. The Phidget channel handle must be released with Phidget.Release. With the functions Phidget.SetProperty and Phidget.GetProperty you can set and get properties of a specific Phidget. A function that is even more powerful is the Phidget.SetScriptTrigger function, which allows you to set a script to be started when a certain event occurs. This can be e.g. with a temperature sensor a detected change in the temperature. These and many more functions are waiting for you in the new component Phidget. We are excited what new projects you can implement with these little helpers.


The need for automated checks

When you do things in your business, it is very important to have automated checks. A process needs to check if the previous process did the right thing. Because whatever can go wrong, will eventually go wrong and then you add a new check.

Today we added a check to our newsletter sending to make sure the text file for the announcement is from the current month. This hopefully avoids us sending out over 1000 emails with the old text the next time. Sorry, if you got one of these announcement newsletters with the wrong announcement.

Recently we got a new check when packing the plugins to check if the version number in the plugin file is the current version. Because it happened before, that the build machine failed and didn't copy over a new version. We also check that plugin files have a minimum file size and the linker didn't abort for some reason. The same script checks if all the plugins are from the same day to avoid missing to build one of them. (more)

EngageU - FileMaker Conference in two months

Just two months until the EngageU conference. ClickWorks and Square Moon continue to organize a pan-european conference for Claris FileMaker developers from all over the world. EngageU - FileMaker Conference 12th - 14th of November 2023, Antwerp, Belgium After the conference in Malmö last year, we see the second conference coming to Belgium. This may be the largest in-person European FileMaker conference this year with about 250 participants. Claris is expected to join and all presentations will be in English. Please don't miss this event and sign up for the conference soon: EngageU And it's great reason for people from all around the world to do a business trip to see Belgium. More events are listed on our events website.

MBS Plugin 13.4 for Claris FileMaker - More than 7100 Functions In One Plugin

Nickenich, Germany - (September 12th, 2023) -- MonkeyBread Software today is pleased to announce MBS FileMaker Plugin 13.4 for Claris FileMaker for macOS, iOS, Linux and Windows, the latest update to their product that is easily the most powerful plugin currently available for Claris FileMaker produce line. As the leading database management solution for Windows, macOS, iOS and the web, the Claris FileMaker Pro Integrated Development Environment supports a plugin architecture that can easily extend the feature set of the application. MBS FileMaker Plugin 13.4 has been updated and now includes over 7100 different functions, and the versatile plugin has gained more new functions:

Our new Phidget functions allow you to connect to devices from Phidgets Inc. directly from FileMaker, if you like to automate something with using phidget devices. This includes: analog or digital input or outputs, servo motors, touch sensors, RFID, GPS, gyroscope, magnetometer, spatial sensor, temperature sensor, frequency counter, IR, PH sensor, LCD, distance sensor, light sensor, pressure sensor, sound sensor, humidity sensor and more. Create a device object, set properties and connect. Then get and set properties and register script triggers.

We updated our SSL support for our MongoDB functions. We switched to using OpenSSL as the transport encryption library for the MongoDB library for macOS and iOS. The MongoDB.SSLLibrary function tells you which SSL library is in use. You can use MongoDB.SetSSLOptions function to specify SSL options in addition to putting them into the connection string. To check about possible reasons for connection problems, we got a new trace logging functionality with MongoDB.IsTracing and MongoDB.Trace functions. And by regularly calling MongoDB.Ping function you can check whether the connection is alive and keep it open.

For macOS we have a couple of functions to check the state of cloud hosted files, e.g. in iCloud or Dropbox. You can query the state with Files.UbiquitousItemStatus function. Then you can request a download with Files.StartDownloadingUbiquitousItem function or free local disk space with Files.EvictUbiquitousItem function. Calendars, events and sources can now be queried as JSON objects.

DynaPDF can now delete DPart nodes and skip DPart data on importing. The DynaPDF.RenderPage function can take the ForceInterpolation flag and DynaPDF.SaveAndSignFileExt1 got updated with a new useDetached parameter.

We updated WebDownloadDelegate functions to work with WebKit 2.0 on macOS and iOS. For iOS we got new triggers for orientation change with iOSApp.SetOrientationDidChangeScript function.

The XML.InsertRecords function can insert records with data from XML, we got new Base32 encoding and decoding functions, the CURL.ProcessRelativeURL function can help to expand relative URLs and improved JSON.Import function to handle arrays in arrays. The SerialPort.OpenPath function can open paths to special devices like pipes.

Finally we updated curl to version 8.2.1, DynaPDF to, SQLAPI to 5.2.5 and SQLite to version 3.43.1.

See release notes for a complete list of changes.

Neues MBS Plugin 13.4 für Claris FileMaker

12. September 2023 - Monkeybread Software veröffentlicht heute das MBS FileMaker Plugin für Claris FileMaker in Version 13.4, mit inzwischen über 7100 Funktionen eines der größten FileMaker Plugins überhaupt. Hier einige der Neuerungen:

Unsere neuen Phidget-Funktionen ermöglichen es Ihnen, sich direkt von FileMaker aus mit Geräten von Phidgets Inc. zu verbinden, wenn Sie etwas mit Hilfe von Phidgets-Geräten automatisieren möchten. Dazu gehören: analoge oder digitale Ein- oder Ausgänge, Servomotoren, Berührungssensoren, RFID, GPS, Gyroskop, Magnetometer, Raumsensor, Temperatursensor, Frequenzzähler, IR, PH-Sensor, LCD, Abstandssensor, Lichtsensor, Drucksensor, Tonsensor, Feuchtigkeitssensor und mehr. Erstellen Sie ein Geräteobjekt, legen Sie Eigenschaften fest und stellen Sie eine Verbindung her. Holen und setzen Sie dann Eigenschaften und registrieren Sie Skriptauslöser.

Wir haben unsere SSL-Unterstützung für unsere MongoDB-Funktionen aktualisiert. Dabei wechseln wir auf OpenSSL als Transportverschlüsselung-Bibliothek für die MongoDB-Bibliothek für macOS und iOS. Die Funktion MongoDB.SSLLibrary teilt Ihnen mit, welche SSL-Bibliothek verwendet wird. Sie können die Funktion MongoDB.SetSSLOptions verwenden, um SSL-Optionen zusätzlich zur Eingabe in den Verbindungsstring anzugeben. Um mögliche Gründe für Verbindungsprobleme zu prüfen, gibt es mit den Funktionen MongoDB.IsTracing und MongoDB.Trace eine neue Trace-Logging-Funktion. Und durch den regelmäßigen Aufruf der Funktion MongoDB.Ping können Sie überprüfen, ob die Verbindung noch besteht und offen gehalten wird.

Für macOS gibt es eine Reihe von Funktionen, um den Status von in der Cloud gehosteten Dateien zu überprüfen, z. B. in iCloud oder Dropbox. Sie können den Status mit der Funktion Files.UbiquitousItemStatus abfragen. Anschließend können Sie mit der Funktion Files.StartDownloadingUbiquitousItem einen Download anfordern oder mit der Funktion Files.EvictUbiquitousItem lokalen Speicherplatz freigeben. Kalender, Ereignisse und Quellen können jetzt als JSON-Objekte abgefragt werden.

DynaPDF kann nun DPart-Knoten löschen und DPart-Daten beim Importieren überspringen. Die DynaPDF.RenderPage Funktion kann das ForceInterpolation Flag annehmen und DynaPDF.SaveAndSignFileExt1 wurde mit einem neuen useDetached Parameter versehen.

Wir haben die WebDownloadDelegate-Funktionen verbessert, damit sie mit WebKit 2.0 auf macOS und iOS funktionieren. Für iOS gibt es neue Trigger für Orientierungsänderungen mit der Funktion iOSApp.SetOrientationDidChangeScript.

Die Funktion XML.InsertRecords kann Datensätze mit Daten aus XML einfügen, es gibt neue Funktionen zur Base32-Kodierung und -Dekodierung, die Funktion CURL.ProcessRelativeURL hilft bei der Erweiterung relativer URLs und die verbesserte Funktion JSON.Import kann Arrays in Arrays verarbeiten. Die Funktion SerialPort.OpenPath kann Pfade zu speziellen Geräten wie Pipes öffnen.

Schließlich haben wir curl auf Version 8.2.1, DynaPDF auf, SQLAPI auf 5.2.5 und SQLite auf Version 3.43.1 aktualisiert.

Alle Änderungen in den Release Notes.

17 years since MBS FileMaker Plugin version 1.0

Today seventeen years ago we released the MBS FileMaker Plugin in Version 1.0.
Here the original announcement:

[ANN] MBS Plug-in For Filemaker

Make FileMaker Windows Semi Transparent!
Take Screenshots from FileMaker
Run an Applescript on field exit
and more...

Monkey Bread Software, maker of the popular MBS Plug-in for RealBasic and geist interactive have teamed up to bring the extensive MBS function library to FileMaker. The MBS RealBasic plug-in contains over 10000 functions, and this release represents the first step in a project to bring as many of those functions to FileMaker as make sense. Many many more features to com in the future.

The plug-in is available for FileMaker 8 and 8.5. It is available for Windows XP and as Universal Binary for Mac OS X There is a Developer Tool available to help you get started quickly with documentation and Calculation builder. Demos are available on the website

more info: geistinteractive.com
download: monkeybreadsoftware.de/filemaker/

Read also: 4000 functions in 10 years and 5000 Functions in MBS Plugin.

Thanks for the support over years.

Where are all the functions?

Recently a client asked me where all the MBS functions are. Looking in the calculation dialog, you see just MBS listed:

If you ask why we don't have over 7000 functions listed there, the answer is easy: It would be a nightmare for you to use.

Recently I made a special version of MBS Plugin to register all functions individually and show them in the calculation dialog right away:

You don't see the scrollbar on the screenshot, but all 7000 functions are there. The dialog takes about 12 seconds to open as FileMaker adds all the functions to the list. And it takes another 10 seconds to open the MBS section there. There is a significant time cost for having a lot of functions there and thus we don't do this normally.

Please pass the function name to MBS() as first parameter to pick the function. Take benefit from being able to pick a function name from a field or calculation.

MBS FileMaker Plugin, version 13.4pr7

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

One month until Rome FileMaker Week

Just one month until the FileMaker conference in Rome, Italy starts: from 3rd to 8th October 2023.

For the international traveler coming to the conference, please note, that there are extra days for sight seeing and/or training with your fellow developers.

Day Sight Seeing Training Conference
3rd Oct Tour Rome & FileMaker
Undergrounds of Rome and via dell'acqua
4th Oct Tour Rome & FileMaker
Industrial Rome
Course build your FileMaker app from scratch (in Italian)
Course build your FileMaker app from scratch (in English)
5th OctClaris Partner meeting (in English)
Conference start.
6th OctConference & Gala Dinner
7th OctConference
8th OctJavaScript & FileMaker Course
Design Masterclass (in Spanish)

More information on the website. Last year we had live translation between English and Italian and you could use head phones to hear all presentations in either language. This year FMGuru looks into adding Spanish and French translation.

If you sign up, please find below the €100 discount coupon on the event ticket: RFWMBS100

MBS FileMaker Plugin, version 13.4pr6

New in this prerelease of version 13.4 of the MBS FileMaker Plugin:
  • Fixed a problem with Dialog.SetTimeout closing a FileMaker custom dialog by accident on macOS.
  • Improved DynaPDF.FindField to better find a field in a group.
  • Added SerialPort.OpenPath function, so you can use SerialPort functions to open special files or pipes.
  • Fixed a problem with handling of Shift JIS text encoding.
  • Fixed a bug in setting numeric values in SQL functions with floating numbers, caused by a bug fix in version 13.3. Values showed up as zero incorrectly.
  • Updated DynaPDF to version
  • Added SkipDPartData option for DynaPDF.SetImportFlags2 function.
  • Added DynaPDF.DeleteDPartNode function.
Download at monkeybreadsoftware.com/filemaker/files/Prerelease/, in DropBox folder or ask for being added to the DropBox shared folder.


Jun 2024
May 2024
Apr 2024
Mar 2024
Feb 2024
Jan 2024
Dec 2023
Nov 2023
Oct 2023
Sep 2023
Aug 2023
Jul 2023
Jun 2023
May 2023
Apr 2023
Mar 2023
Feb 2023
Jan 2023
Dec 2022
Nov 2022
Oct 2022
Sep 2022
Aug 2022
Jul 2022
Jun 2022
May 2022
Apr 2022
Mar 2022
Feb 2022
Jan 2022
Dec 2021
Nov 2021
Oct 2021
Sep 2021
Aug 2021
Jul 2021
Jun 2021
May 2021
Apr 2021
Mar 2021
Feb 2021
Jan 2021
Dec 2020
Nov 2020
Oct 2020
Sep 2020
Aug 2020
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