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

New error log functions for FileMaker

For last version, we got the functions ClearErrors and HadErrors to track whether a script had errors. You can think here like a try catch, where you can run a script later check in the script whether something failed and log that failure. At the MBS FileMaker Plugin workshop this week, we got a few new ideas to catch errors better. We got the idea to collect error logs and provide them as JSON to the developer.

 

Let us show you a test script:

 

# start error logging

Set Variable [ $r ; Value: MBS("ClearErrors") ] 

# cause some errors

Set Variable [ $r ; Value: MBS("test"; 1; "Hello") ] 

Set Variable [ $r ; Value: MBS("DynaPDF.Print"; 1; "Hello") ] 

# now query error log

Set Variable [ $r ; Value: MBS("ErrorLog") ] 

Set Field [ Kontakte::Nachname ; $r ] 

Show Custom Dialog [ "Error Log" ; $r ] 

 

As you see we call ClearErrors function early to clear the list (if needed). Then we cause two MBS errors here and don't check result right away. 

(more)

Add page links for FileMaker

Recently a client asked how to make existing index pages clickable in a PDF document. They have existing documents in FileMaker and like to customize them with our DynaPDF functions.

One part of the customization is to make some texts clickable. I recently proposed them to use DynaPDF.ExtractText to read the page number and then use DynaPDF.PageLink function to make the page. To know the distance, the layout has fields to enter where to find the numbers on the right side of the index page. Our loop runs from bottom to top of the page, checks every box for text and if there is a text, we make a link for that page.

 

Here is the script:

 

# Initialize DynaPDF if needed

If [ MBS("DynaPDF.IsInitialized") ≠ 1 ] 

Perform Script [ Specified: From list ; “InitDynaPDF” ; Parameter:    ]

End If

# Clear current PDF document

Set Variable [ $pdf ; Value: MBS("DynaPDF.New") ] 

# optionally we can merge to external file

If [ False ] 

Set Variable [ $destPath ; Value: MBS("Folders.UserDesktop") & "/test.pdf" ] 

Set Variable [ $r ; Value: MBS("DynaPDF.OpenOutputFile"; $pdf; $destPath) ] 

If [ MBS("IsError") ] 

Show Custom Dialog [ "Failed to create PDF file." ; $r ] 

Exit Script [ Text Result:    ] 

End If

End If

(more)

MBS FileMaker Plugin, version 12.3pr4

New in this prerelease of version 12.3 of the MBS FileMaker Plugin:
  • Added PDF support for Vision.RecognizeText function, so you can get live text from PDF documents.
  • Added ' to list of allowed characters for variables or function names in syntax highlighting.
  • Updated to DynaPDF 4.0.68.186.
  • Added DynaPDF.SetTemplBBox function.
  • Updated to LibXL 4.0.4.
Download at monkeybreadsoftware.com/filemaker/files/Prerelease/, in DropBox folder or ask for being added to the DropBox shared folder.

Claris FileMaker 19.5 available

Today Claris released the new version 19.5 update for their FileMaker platform. A lot of new features are included and a lot of bug fixes are appreciated.

See announcement in the Claris Community:

Claris FileMaker 19.5 now available.

Release notes:

FileMaker Pro 19.5.1 Release Notes
Claris FileMaker Server 19.5.1 Release Notes

And documentation:

New features in FileMaker Pro 19
New features in FileMaker Server 19

We recommend the current 12.2 version for MBS Plugin for use with FileMaker 19.5. Older plugins may work, but you will miss out various bug fixes and improvements we made for 19.4 and 19.5.

As you may notice the LiveText feature is already available in MBS FileMaker Plugin for years with the Vision.RecognizeText function. And we are curious to see how the QRCode function in FileMaker relates to our Barcode.Detect and Barcode.Scan functions.

MBS FileMaker Plugin, version 12.3pr3

New in this prerelease of version 12.3 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.

Configure Audit functions in MBS Plugin

If you use Audit functions in MBS FileMaker Plugin, you can configure them with a couple of options, so let's check the options.

Date and time as numbers

For years we had the problem, that two people working on a database may have different locale. So one opens a records and saves it with "12.05.2022" as date (12th May). Then another user looks on the record and FileMaker formats it in different locale as 05/12/2022 and saves that. The Audit log would record that as a change and cause a lot of extra log entries.

To avoid this trouble, we added an option for 12.3 to store the time, date and timestamp values as numbers. Once turned on with Audit.SetDateAndTimeAsNumbers function, you see them stored numerical. Of course if you have old entries, those will now be logged again with their numeric value. So better start using this when you start with a fresh AuditLog. (more)

MBS FileMaker Plugin 12.2

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

Error Count for MBS functions

For years we already have the isError function in the MBS FileMaker Plugin. We can call this after a MBS function to see if the previous MBS function returned an error. If you use many MBS functions in a script this can get confusing and it might be enough for you, e.g. if you are testing a script, to know if a plugin function in the whole script throws an error at all. For this we have developed two new functions. With the HadErrors function you get back the number that is currently in the error counter. This will be incremented by one whenever a MBS function returns an error. If you want to log the errors of a script, you first have to call the ClearErrors function to set the Error Count to 0. At the end of the script you can then call the HadErrors function.

(more)

Multi Year Updates

If you have a license for our plugins, you can renew it at any time and add additional years at current pricing.

While our updates are already discounted at 50%, you can take multiple years and get an additional discount:
  • 2nd year with 10% reduction
  • 3rd year with 20% reduction
  • 4th year with 20% reduction
  • 5th year with 20% reduction
For example a $99 update for 5 years would be factor 4.3 instead of 5, so $425.70 instead of $495 with a $69.3 discount.

Please contact us to let us know you like to order with discount, so we can raise a custom invoice for your purchase.

If you order a multi year update via our web shop for full price, we can extend the MBS Plugin licenses (not DynaPDF or LibXL) with extra months instead of a discount:
  • 2 years -> 1 month extra
  • 3 years -> 3 months extra
  • 4 years -> 6 months extra
  • 5 years -> 9 months extra
This should be about the same level of discount. In any case, please let us know in advance. With ordering now in advance, you can secure current pricing.

And of course we appreciate the trust that customers put into us when they update for several years.

Please note that you may need to depreciate the value of the purchase over multiple years in most countries.

Comment Links in FileMaker ScriptWorkspace

At the dotfmp conference we got a nice idea for a feature: MBS FileMaker Plugin already scans script lines to find missing variables and show a little warning for undeclared variables. We added the feature to scan for comments containing URLs. If we find an URL, we add a little button to the end of the line, which currently shows an arrow and a globe:



You may click on the line to select it and then click on the control we add. Maybe double click may also work directly. But only if the list of script steps doesn't consume the click, it will come to our control.

You can configure this via our preferences dialog or the new SyntaxColoring.CommentLinks.SetEnabled function, so you can turn it on and off via script if needed.

Available in 12.3pr2 on our website for FileMaker Pro on macOS.

MBS FileMaker Plugin, version 12.3pr2

New in this prerelease of version 12.3 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.

OnRecordEdit Trigger in FileMaker

At dotfmp conference someone mentioned that he is missing a trigger in FileMaker Pro for when the user starts editing the record and thus locks it. While FileMaker has trigger for record load, commit and revert, there is no edit one. You may do something with a Layout Keystroke, but not all editing is by keyboard usage.

 

We can implement such a trigger with MBS FileMaker Plugin, our schedule functions and FM.RunScript. When record loads, we start a timer to evaluate an expression every second. This calculation checks whether RecordOpenState changes to 2 for editing and then runs the script to trigger. 

 

Our example uses a Status field in a Status table to show the status. This must be a field in another table to avoid our current record get state changed by our Set Field call. We start with the OnRecordLoad script to set our status and start the timer with Schedule.EvaluateAfterDelay. Delay is 1 second and repeat each second. The expression checks Get(RecordOpenState) and if it is 2, first stops the schedule and then runs a script in the current file named OnRecordEdit:


(more)

More Context Menu Commands for FileMaker

For next plugin version we added contextual menu entries for lists in the FileMaker user interface with expandable folders:
You can expand or collapse all with a context menu command.

And once we had that, we got another idea:
We can look on the names and find duplicates. If you ever use "Go To Layout" with name, you may have run into a problem with duplicate layout names. Our plugin selects all duplicate entries, so you can see which are belonging together.

And of course our contextual menu allows you to open the find tools, do copy and paste like the edit menu and show you how many entries are selected.

You can try next week in the version 12.3pr2 for macOS.

MBS FileMaker Plugin, version 12.3pr1

New in this prerelease of version 12.3 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.

MBS FileMaker Plugin English 2022 Update

Let us show you what is new in MBS FileMaker Plugin for 2021/2022.

All movies   Watch on YouTube.   MBSFileMaker2022en.m4v   In Deutsch

(more)

MBS FileMaker Plugin Deutsch 2022 Update

Lassen Sie uns Ihnen zeigen, was es 2021/2022 neues im MBS FileMaker Plugin gibt.

All movies   Watch on YouTube.   MBSFileMaker2022de.m4v   In English

(more)

Beta for upcoming Froodware Plugins

We work on an update for the Froodware plugins for our existing customers using them. Primarily this is to make sure the plugin will continue to work with FileMaker:

  • Updated to newer Xcode
  • Fixed a couple of smaller memory leaks.
  • Changed license check to work without licensing server.
  • Signed and notarized
  • New version 2.0.2 for calendar and 3.0.7 for Contacts
  • Splash and preferences screens removed as they are no longer needed.
  • Updated example databases.
  • Includes Apple Silicon support for M1 Macs.

As an existing customer you can choose:

  • Get a matching MBS Plugin license with 50% off the license price as an upgrade, so you can switch to MBS functions.
  • Or order a renewal for your FWCalendar or FWContacts plugin from MBS to use the newer plugin version.
  • Or keep using the old FWCalendar or FWContacts plugin with your existing license for the time being and as long as the old activation server still runs.

If you like to try the new plugin or you like to get the upgrade to MBS, pease contact us. We may ask for the existing license key to verify you purchased the plugins before.

See also Froodware plugins handed over to MonkeyBread Software


MBS Plugin 12.2 for Claris FileMaker

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

You may know we have on macOS an option in preferences dialog to turn on links in calculations. When you enter a MBS function call, we change the function name a link to our documentation. With this version we make Get() function calls in FileMaker a link to the documentation, so you can directly lookup what the return values are.

Have you tried custom functions in JavaScript? Beside our cross platform solution, we can do the same using WebKit's JavaScript engine to do the same. Check JavaScript.CF function to call custom functions on macOS and iOS. Use JavaScript.SetPropertyJSON and JavaScript.GetPropertyJSON to transfer JSON data directly and call functions with JavaScript.CallFunction.

The WordFile functions can be used to replace place holders (tags) in a Word document. You can query a list of all tags for this using the WordFile.Tags function.

The DynaPDF library has been updated and tested to work with ZUGFeRD 2.2 / Factur-X 1.0.06. The DynaPDF.ReplacePattern function can now handle different font styles for fallback fonts. To put PDF on the clipboard, check the new Clipboard.SetPDF function.

On MacOS you can now use context menu on the script list in Script Workspace to sort scripts by name. Our plugin extends FileMaker's context menu to add the commands. If clicked, we swap script positions as needed, so FileMaker gets the new order.

To better track errors returned by a plugin, you can call ClearErrors early in a script. Later you can use HadErrors function to check if you got an error in the script. That may be easier than calling IsError after each function call.

For iOS you can now use DialogModifications functions. This allows you to change error messages shown by FileMaker and customize the text.

The Clipboard.DetectFileMakerDataType function can now detect menus and menu sets, JSON.Import has a new RootTableName parameter,

Finally we updated CURL library to version 7.83.1, DukTape to version 2.7, DynaPDF to 4.0.66.181, openssl to 1.1.1n, SQLite to 3.38.5, and Xcode to 13.3.1.

See release notes for a complete list of changes.

Neues MBS Plugin 12.2 für Claris FileMaker

17. Mai 2022 - Monkeybread Software veröffentlicht heute das MBS FileMaker Plugin für Claris FileMaker in Version 12.2, mit inzwischen über 6700 Funktionen eines der größten FileMaker Plugins überhaupt. Hier einige der Neuerungen:

Sie wissen vielleicht, dass wir unter macOS eine Option in den Einstellungen haben, um Links in Berechnungen zu aktivieren. Wenn Sie einen MBS-Funktionsaufruf eingeben, ändern wir den Funktionsnamen zu einem Link zu unserer Dokumentation. Mit dieser Version machen wir Get()-Funktionsaufrufe in FileMaker zu einem Link zur Dokumentation, so dass Sie direkt nachschlagen können, was die Rückgabewerte sind.

Haben Sie eigene Funktionen in JavaScript ausprobiert? Neben unserer plattformübergreifenden Lösung können wir auch die JavaScript-Engine von WebKit verwenden, um das Gleiche zu tun. Probieren Sie die Funktion JavaScript.CF, um benutzerdefinierte Funktionen unter macOS und iOS aufzurufen. Verwenden Sie JavaScript.SetPropertyJSON und JavaScript.GetPropertyJSON, um JSON-Daten direkt zu übertragen und rufen Sie Funktionen mit JavaScript.CallFunction auf.

Die WordFile-Funktionen können verwendet werden, um Platzhalter (Tags) in einem Word-Dokument zu ersetzen. Dazu können Sie mit der Funktion WordFile.Tags eine Liste aller Tags abfragen.

Die DynaPDF Bibliothek wurde aktualisiert und getestet und unterstützen ZUGFeRD 2.2 / Factur-X 1.0.06. Die Funktion DynaPDF.ReplacePattern kann nun mit verschiedenen Schriftarten für Fallback-Fonts umgehen. Um PDF in die Zwischenablage zu legen, gibt es die neue Funktion Clipboard.SetPDF.

Unter MacOS können Sie jetzt das Kontextmenü der Scriptliste im Scriptarbeitsbereich verwenden, um Scripts nach Namen zu sortieren. Unser Plugin erweitert das Kontextmenü von FileMaker um diese Befehle. Wenn es angeklickt wird, tauschen wir die Scriptpositionen nach Bedarf aus, damit FileMaker die neuen Reihenfolge erhält.

Um Fehler, die von einem Plugin zurückgegeben werden, besser zu verfolgen, können Sie ClearErrors am Anfang eines Scriptes aufrufen. Später können Sie die Funktion HadErrors verwenden, um zu prüfen, ob ein Fehler im Script aufgetreten ist. Das kann einfacher sein als der Aufruf von IsError nach jedem Funktionsaufruf.

Für iOS können Sie jetzt DialogModifications-Funktionen verwenden. Damit können Sie die von FileMaker angezeigten Fehlermeldungen ändern und den Text anpassen.

Die Funktion Clipboard.DetectFileMakerDataType kann nun Menüs und Menüsets erkennen, JSON.Import hat einen neuen Parameter RootTableName,

Schließlich haben wir die CURL-Bibliothek auf Version 7.83.1, DukTape auf Version 2.7, DynaPDF auf 4.0.66.181, openssl auf 1.1.1n, SQLite auf 3.38.5 und Xcode auf 13.3.1 aktualisiert.

Alle Änderungen in den Release Notes.

MBS FileMaker Plugin, version 12.2pr7

New in this prerelease of version 12.2 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.

Froodware plugins handed over to MonkeyBread Software

We are happy to announce that we take over two plugins from Froodware:

After many years of developing our Contacts and Calendar plugin for FileMaker and MacOS we have reached an agreement with MonkeyBread Software (MBS) to take over our plugin business. For a small developer like we are, it became too much a challenge to keep up with Apple’s ever changing software policies, and we can now solemnly focus on developing great Filemaker solutions.

We are very happy that we reached an agreement with MBS, a company that has been well known for their smart utilities like the much used and award winning ‘MBS FileMaker plugin’ which contains a ton of functions that can be used within Claris FileMaker Pro. Exchanging data between Apple’s Contacts and Calendar is also part of this plugin.

We have given them all plugin code and they are looking into to two options:

  • offer existing users a special crossgrade offer to their MBS FileMaker plugin.
  • continue with development of our Contacts and Calendar plugin, or integrate the functionality into their MBS FileMaker plugin.

Existing users
Nothing changes for existing users: the plugin will keep on working, you can still de-authorise and reauthorise it or download it from our website.
We only stop selling plugins or developing new versions.
All registered users have received an email with addiotonal information about what this means for them.
If you are a registered user and did not receive this email, then please send an email to daniel-at-froodware.com.

Because we want to make this transition as smooth as possible, we will keep our serial number registration server running, and will keep on answering support mails that deal with authorisation issues.

More info about MBS: https://www.monkeybreadsoftware.com/FileMaker/

Below information and download of the latest and in our case last versions of the plugin.

We look forward to welcome the existing users of those plugins and transition them to our MBS Plugin.

Older blog entries:

2022-05-10 MBS FileMaker Plugin, version 12.2pr6
2022-05-06 Documentation links for Get functions in FileMaker
2022-05-05 Custom Functions in JavaScript reloaded
2022-05-04 MBS FileMaker Plugin, version 12.2pr5
2022-05-02 One month until dotfmp 2022
2022-05-01 Upcoming changes for MBS Plugins
2022-04-30 MBS Workshop in Hamburg bei der FileMaker Konferenz
2022-04-28 MBS FileMaker Plugin, version 12.2pr4
2022-04-28 Transactions with SQL functions
2022-04-24 Two months of war in Ukraine
2022-04-22 FileMaker Konferenz 2022 in Hamburg
2022-04-21 MBS FileMaker Plugin, version 12.2pr3
2022-04-15 MBS @ FMTraining.TV
2022-04-13 MBS FileMaker Plugin, version 12.2pr2
2022-04-13 Why MBS Plugin fails to load?
2022-04-09 MBS @ FMTraining.TV
2022-04-07 MBS @ FMTraining.TV
2022-04-01 MBS FileMaker Plugin, version 12.2pr1
2022-04-01 Company's 22nd Birthday
2022-03-30 Sorting Scripts by Name in FileMaker

Archives

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
XML: RSS Feed XML: Atom Feed

Start Chat