Sorting Scripts by Name in FileMaker

On every travel you learn something new. At a FileMaker developer meeting in Montreal, we discussed about what people miss in FileMaker and a plugin could add. And the wish several people mentioned is to sort scripts in the Script Workspace.

We got several challenges here to solve. First this is not like on the script, where we can just add a custom contextual menu. There is already a FileMaker contextual menu, so we have to intercept the menu and our own entries, which seems to work fine so far. Since the implementation depends on the things we made to show Script IDs, the two features are linked currently.

The next one is to actually do the sort operation. There is not much to leverage except that you can manually reorder them with the mouse. Our plugin can do that by telling you started a drag at one spot and then release it to another spot. You may see the entries moving as far as animations are happening.

Please try it out soon in 12.2pr1 in early April.

New in MBS FileMaker Plugin 12.1

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

WebHook

We already introduced the new WebHook component in the release 11.5. In the new release we provide a few new functions that should make your work with WebHooks easier. With the function WebHook.SetMaximumRequestSize we set the maximum allowed request size. This allows you to disconnect sockets, which send too much data. By default there is no limit, so people can send requests with several gigabytes of payload. Depending on your use can it may be worth to limit request size to a reasonable value. For example if you receive notifications from your phone system, you may set the maximum size to 10000 bytes and a timeout of 60 seconds for WebHook.SetTimeOut function. That is probably 10 times more than needed, but may avoid some malicious user from sending a ton of useless traffic. Matching to this there is the WebHook.GetMaximumRequestSize function which queries this set value if needed. We can also get the size of a certain web request. WebRequest.GetSize returns the total size of the request. The WebRequest.GetBodySize function then gives us the size of the body.

(more)

FileMaker Konferenz 2022 in Hamburg

Noch drei Monate: Vom 22. bis 24. Juni 2022 findet die elfte deutschsprachige FileMaker Konferenz in Hamburg, Deutschland statt. Das JUFA Hotel Hamburg HafenCity liegt direkt neben dem Ausgang der U-Bahn Station HafenCity Universität, nur drei Stationen vom Hauptbahnhof via U4, so dass sich die Anreise per Bahn empfiehlt. FileMaker Anwender und Entwickler können ihre Tickets buchen.

Anmeldung heute

Bitte melden Sie sich an, wenn Sie Interesse an der Konferenz haben. Bald entscheidet sich, ob die Konferenz statt finden kann. Diese Entscheidung hängt von den Anmeldungen und den aktuellen Corona Regeln ab, also bitte Anmelden. Hotel, Flug oder Bahnreise bitte erst später buchen.

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

MBS Empfang

Für den Vorabend am 21. Juni 2022 möchten wir alle Teilnehmer der Konferenz begrüßen. Treffen Sie andere Teilnehmer beim MBS Apero, gesponsert von Monkeybread Software.

Bei der Anmeldung zur Konferenz können Sie sich gleich mit dafür anmelden, da wir eine Teilnehmerzahl brauchen für das Hotel.

MBS Plugin Workshop

Wir planen einen Schulungstag für den 21. Juni 2022. Anmeldung bei uns.

Hier geben wir Ihnen einen Überblick über das MBS Plugin, schauen uns Beispiele an und erklären wie man bestimmte Aufgaben löst. Bitte bringen Sie ihre Fragen und Themenwünsche mit.

Die Teilnahme kostet 199 Euro inkl. Verpflegung und MWSt., 149 Euro bei Anmeldung bis zum 12. März. Falls die Konferenz abgesagt wird, fällt die Schulung automatisch aus.

FileMaker Schnittstellen Workshop – JSON und REST-API

Erobern Sie mit FileMaker das Internet! In einer zweitägigen Schulung zeigt Ihnen FileMaker Experte Bernhard Schulz am 20. und 21. Juni 2022, wie Sie mit FileMaker Bordmitteln über Server-Schnittstellen per REST/JSON mit Fremdsystemen kommunizieren und umfangreiche Daten austauschen. Der Workshop findet direkt vor der FileMaker Konferenz ebenfalls in der HafenCity Hamburg statt.

Mehr Informationen

Order troubleshooting

From time to time clients run into trouble with placing orders. Sorry for that, but let us take the time to explain a bit.

The order process goes into multiple steps with several parties. Each step may fail and then the customer is frustrated.

In the order process MBS website sends you to the store website. If that website loads, you can enter your details. Then you get directed to the payment processor website (adyen or PayPal for example). These pages need to load and then loads itself the bank website for the second factor. Most banks ask you some additional thing like a token sent via SMS, a code generated in an app or a transaction password. Once that step is done, the bank redirects back to the shop and once you completed there, we get redirected to our website.

On that way of redirects, all content filters in the browser may decide to block something. But bigger problems seem to be that older browsers are in use and the latest TLS v1.2 is not used or not used with stronger cryptography.

If you run into those problems, please switch to a different browser, e.g. try a recently updated copy of Safari, Google Chrome or Firefox. You may disable ad blockers and make sure they are up to date including your operation system.

Stefanie got the Claris FileMaker Certification

We are happy to inform you that Stefanie Juchmes mastered the certification for Claris FileMaker 19. Congratulations Stefanie!

A bit over three years ago Stefanie started her job at Monkeybread Software. We asked her to learn all about our plugins, Xojo and FileMaker. And to proof that she got the knowledge, we asked here to make her own projects, videos for conferences and of course also get certificated. And yes, this test is quite demanding. It requires that you know a lot of different things in the platform. Just like school you may not need those details in the future, but you never know what you need in advance.

If you like to do the test yourself, you may watch the courses at Productive Computing University and FMTrainingTV, the books The FileMaker Manual for Novices by Richard Carlton and Learn FileMaker Pro 19 by Mark Munro, the Claris Community FileMaker Certification pages and the related FAQ.

MBS FileMaker Plugin 12.1 - More than 6700 Functions In One Plugin

Nickenich, Germany - (March 15th, 2022) -- MonkeyBread Software today is pleased to announce MBS FileMaker Plugin 12.1 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 12.1 has been updated and now includes over 6700 different functions, and the versatile plugin has gained more new functions:

We extend the auto complete feature on macOS for variable names and added auto complete for MBS function names. Type a letter to see component list. When you have a pick in the menu, type a dot to complete and then type the next letter for the function. Column width saving for the Layout Picker dialog is now implemented. The SyntaxColoring.ColorizeScript function can colorize a script text for you.

For Windows we got WinPhotoAcquire functions to import photos from digital cameras (DLSR) on your Windows PC. We show the standard Windows dialogs for picking the device or what pictures to import.

The DynaPDF functions got new support for PDF/A 2u and 3u in DynaPDF.CheckConformance function. The DynaPDF.SetSpaceWidthFactor function allows you to control how the DyanPDF.ExtractText function adds spaces. If you like to produce invoices with ZUGFeRD standard, we got a new example database to show you have to create the XML and embed it into a PDF.

Doing math in FileMaker? We got a few new functions to work on lists as well as multiple parameters: Math.Average, Math.Max, Math.Median, Math.Min, Math.Multiply, Math.Reciprocal, Math.StandardDeviation, and Math.Sum.

If you use the FileMaker iOS SDK on a M1 Mac, you can now run the MBS FileMaker Plugin with Apple Silicon in the iOS simulator.

We tuned our WebHook functions to limit the maximum size of a request. Use WebRequest.GetBodySize and WebRequest.GetSize to query the size of the request later.

Our plugin knows the parameter names for functions and you can query them with Plugin.GetFunctionParameters function. We show a tooltip on macOS for the function parameters if you hover over the MBS function name with your mouse cursor. The trace logs show the parameter names for MBS calls, which should help debugging your scripts.

For macOS you can now change the alignment of text in a dialog with Dialog.SetTextAlignment function. You can use FM.QueryCustomFunctionsList and FM.CustomFunctionsList functions to query the list of custom functions in a file. And with CNContactStore.FetchContact you can fetch a contact again to refresh it if needed.

We got a Audit.Statistics function to help you check what Audit functions did, a Files.AudioCoverArt function to query cover art pictures for MP3, MP4 or FLAC music files, a Text.Reverse function with proper Emoji handling and a handy Dictionary.Lookup function to return a value or the default value. The XML.Colorize and JSON.Colorize functions now support dark mode.

Finally we updated CURL library to version 7.82.0, DynaPDF to 4.0.66.172, LCMS to 2.13.1, SQLAPI to 5.1.9, SQLite to 3.38.1, Xcode to 13.2.1.

See release notes for a complete list of changes.

Neues MBS FileMaker Plugin 12.1

15. März 2022 - Monkeybread Software veröffentlicht heute das MBS FileMaker Plugin für FileMaker in Version 12.1, mit inzwischen über 6700 Funktionen eines der größten FileMaker Plugins überhaupt. Hier einige der Neuerungen:


Wir erweitern die Autovervollständigung für macOS um die automatische Vervollständigung für MBS Funktionsnamen. Geben Sie einen Buchstaben ein, um die Komponentenliste zu sehen. Wenn Sie eine Auswahl im Menü haben, geben Sie einen Punkt ein. Damit wählen Sie den Eintrag und anschließend geben Sie den nächsten Buchstaben für die Funktion ein. Das Speichern der Spaltenbreite für den Layout Dialog ist nun implementiert. Die SyntaxColoring.ColorizeScript Funktion kann einen Skripttext einfärben.

Für Windows gibt es die WinPhotoAcquire Funktionen, mit der Sie Fotos von Digitalkameras (DLSR) auf Ihren Windows-PC importieren können. Wir zeigen die Standarddialoge von Windows für die Auswahl des Geräts oder der zu importierenden Bilder.

Die DynaPDF Funktionen haben neue Unterstützung für PDF/A 2u und 3u in der DynaPDF.CheckConformance Funktion. Mit der Funktion DynaPDF.SetSpaceWidthFactor können Sie steuern, wie die DynaPDF.ExtractText Funktion Leerzeichen hinzufügt. Wenn Sie Rechnungen mit dem ZUGFeRD-Standard erstellen möchten, haben wir eine neue Beispieldatenbank, die Ihnen zeigt, wie Sie das XML erstellen und in ein PDF einbetten müssen.

Rechnen Sie in FileMaker? Wir haben ein paar neue Funktionen, die mit Listen und mehreren Parametern arbeiten: Math.Average, Math.Max, Math.Median, Math.Min, Math.Multiply, Math.Reciprocal, Math.StandardDeviation, und Math.Sum.

Wenn Sie das FileMaker iOS SDK auf einem M1 Mac verwenden, können Sie das MBS FileMaker Plugin mit Apple Silicon im iOS Simulator nativ ausführen.

Wir haben unsere WebHook-Funktionen angepasst, um die maximale Größe einer Anfrage zu begrenzen. Mit WebRequest.GetBodySize und WebRequest.GetSize fragen Sie die Größe einer Anfrage ab.

Unser Plugin kennt die Parameternamen für Funktionen und Sie können sie mit der Funktion Plugin.GetFunctionParameters abfragen. Wir zeigen unter macOS einen Tooltip für die Funktionsparameter an, wenn Sie mit dem Mauszeiger über den MBS-Funktionsnamen fahren. Die Trace-Logs zeigen die Parameternamen für MBS-Aufrufe an, was bei der Fehlersuche in Ihren Skripten helfen sollte.

Unter macOS können Sie jetzt die Ausrichtung von Text in einem Dialog mit der Funktion Dialog.SetTextAlignment ändern. Sie können die Funktionen FM.QueryCustomFunctionsList und FM.CustomFunctionsList verwenden, um die Liste der benutzerdefinierten Funktionen in einer Datei abzufragen. Und mit CNContactStore.FetchContact können Sie einen Kontakt erneut abrufen, um ihn bei Bedarf zu aktualisieren.

Wir haben eine Audit.Statistics-Funktion, mit der Sie überprüfen können, was die Audit-Funktionen gemacht haben, eine Files.AudioCoverArt-Funktion, mit der Sie die Coverbilder für MP3-, MP4- oder FLAC-Musikdateien abfragen können, eine Text.Reverse-Funktion mit richtiger Emoji-Behandlung und eine praktische Dictionary.Lookup-Funktion, die einen Wert oder den Standardwert zurückgibt. Die Funktionen XML.Colorize und JSON.Colorize unterstützen jetzt den dunklen Modus.

Schließlich haben wir die CURL-Bibliothek auf Version 7.82.0, DynaPDF auf 4.0.66.172, LCMS auf 2.13.1, SQLAPI auf 5.1.9, SQLite auf 3.38.1 und Xcode auf 13.2.1 aktualisiert.


Alle Änderungen in den Release Notes.


Connect to an external database server in FileMaker

Your FileMaker solution may have a need to connect to another database. While you can do ESS, we offer an alternative way. You can connect via script to a database, run SQL statements and close the connection. That is a great way to move a few records in one direction or even implement a synchronization routine.

Alternatively you can have a script to open the connection when the solution opens. Then just have various calculations and scripts refer to the open connection and run queries as needed. Like have a formula field on a layout to query a number for a value from the foreign table and show it to the user. Like a solution to manage shows and query from the web shop how many tickets got sold.

So what do you need? (more)

MBS FileMaker Plugin, version 12.1pr7

New in this prerelease of version 12.1 of the MBS FileMaker Plugin:
  • Changed Archive functions to enable UTF-8 support by default, so asian characters work well.
  • Updated SQLAPI to version 5.1.9.
  • Fixed CURL.OpenInputFile to stream files over 1 GB again.
  • Fixed an issue in WebHook.Listen not working on Windows.
  • Fixed a memory leak on Windows for WebHook functions.
Download at monkeybreadsoftware.com/filemaker/files/Prerelease/, in DropBox folder or ask for being added to the DropBox shared folder.

MBS FileMaker Plugin, version 12.1pr6

New in this prerelease of version 12.1 of the MBS FileMaker Plugin:
  • Added Audit.Statistics function.
  • Added Dialog.SetTextAlignment and Dialog.GetTextAlignment functions to use left text alignment for dialogs on macOS.
  • Added proper error messages for sockets on Windows.
  • Fixed a problem with tunnel in SSH functions, where SSH.Tunnel.Cancel didn't end the tunnel quickly in some cases.
  • Fixed a problem with XML.Query, where the first only flag was not handled correctly.
  • Updated CURL to version 7.82.0.
  • Updated Method-Draw example to newer version, so it works in FileMaker 19.4 on Windows.
Download at monkeybreadsoftware.com/filemaker/files/Prerelease/, in DropBox folder or ask for being added to the DropBox shared folder.

Text alignment for alerts

Since Big Sur the text alignment for standard dialogs on macOS is centered, but we found a way to adjust that if needed:

For FileMaker, you can use the new Dialog.SetTextAlignment function to change alignment.

For Xojo, you can use the new SetTextAlignment method in NSAlertMBS class to configure this.

In both cases you can pass left, center and right as desired wish. You can also ask for natural alignment, which may do right or left depending on the locale. Also defined is the justified value, but not sure if the dialog honors it.
You can try those in pr6 of our plugins.

MBS @ FMTraining.TV

Check out the FMTraining.tv website. Richard Carlton and his team do a daily free live stream about FileMaker to watch. And they have a huge library of FileMaker training material to watch and learn all about the Claris FileMaker product family.

A few days ago Christian Schmitz from Monkeybread Software joined a live episode to talk a bit about the MBS FileMaker Plugin. Watch it on YouTube.

We show you how to use AVRecorder functions in MBS FileMaker Plugin to get pictures from a webcam.

(more)

MBS FileMaker Plugin, version 12.1pr5

New in this prerelease of version 12.1 of the MBS FileMaker Plugin:
  • Updated SQLite to version 3.38.0.
  • Fixed little bug in trace logs on Windows introduced in pr4.
  • Disabled debug logging for WordFile functions. Sorry for leaving that on.
  • Fixed an issue with JSON.GetDoubleValue and related functions not passing number back with comma (and used dot) where comma would be appropriated. Broken in 12.0.
  • Fixed an edge case for underscore variables conflicting in auto complete with field names using underscores.
  • Updated DynaPDF to version 4.0.66.172.
  • Added subscript and superscript to RichText functions.
  • Added SyntaxColoring.ColorizeScript function.
  • Changed script colors to make selected line black (white for Dark Mode) for better readability.
  • Changed trace to show license key in clear text if the license key is too short, so you may notice it.
Download at monkeybreadsoftware.com/filemaker/files/Prerelease/, in DropBox folder or ask for being added to the DropBox shared folder.

Archives

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