Monkeybread Software
mbsplugins.bsky.social
Monkeybread Software
@mbsplugins.bsky.social
MBS Plugin for FileMaker and Xojo
MBS #FileMaker Advent calendar - Door 23 - Dictionary

Welcome to door 23. We have already seen that we can turn an SQL result into JSON, XML, a matrix, CSV, or text. Now I would like to introduce you to another data structure: dictionaries.

www.mbsplugins.de/archive/2025...
December 23, 2025 at 6:51 PM
MBS #FileMaker Advent calendar - Door 22 - Table statistics

Today I would like to talk to you about the FM.TableStatistics function. This function provides you with table statistics for your table.

www.mbsplugins.de/archive/2025...
December 22, 2025 at 4:21 PM
MBS #Xojo Plugins, version 25.6pr4

Updated LibXL to version 5.0.1.
Improved Translation classes to work mostly on macOS 15 and iOS 18, too.
Added Saxon example for to visualize electronic Invoices (ZUGFeRD, Facture-X, XRechnung or EN16931-1:2017.).

www.mbsplugins.de/archive/2025...
December 22, 2025 at 11:22 AM
MBS #FileMaker Plugin, version 15.6pr4

Added Linux and iOS support for Files.GetNodeID function.
Changed minimum iOS version for deployment to iOS 13.2.
Updated DynaPDF to version 4.0.102.302.
Updated to LibXL 5.0.1.

www.mbsplugins.de/archive/2025...
December 22, 2025 at 10:37 AM
MBS FileMaker Advent calendar - Door 21 - XML

Our 21st article about SQL in #FileMaker:

We have already output the results of SQL queries as text, as a matrix or as JSON. Today, I would like to introduce you to another return format: XML.

www.mbsplugins.de/archive/2025...
December 21, 2025 at 9:53 AM
MBS #FileMaker Advent calendar - Door 20 - Copying records to a new table with SQL

Welcome to door 20 of this advent calendar.

With the FM.InsertRecordQuery function we can transfer certain entries from one table to another.

www.mbsplugins.de/archive/2025...
December 20, 2025 at 11:36 AM
MBS #FileMaker Advent calendar - Door 19 - CSV and TSV

The FM.SQL.CSV function helps to export records as CSV or TSV as comma or tab separated text.

www.mbsplugins.de/archive/2025...
December 19, 2025 at 2:23 PM
Watching for schema changes in your #FileMaker Server

Do you have a FileMaker Server with multiple databases?

Do you like to keep track who makes changes?

With FileMaker Server 21.1 the Plugin SDK got a new entry point for requesting schema changes.

mbsplugins.de/archive/2025...
December 19, 2025 at 6:28 AM
MBS #FileMaker Advent calendar - Door 18 - Update

Today, I would like to show you how to update data records using our FM.UpdateRecord function.

www.mbsplugins.de/archive/2025...
December 18, 2025 at 8:37 PM
MBS #Xojo Developer Conference Update

Four months to go and we got a few more registrations from 10 countries: 🇩🇪, 🇳🇱, 🇵🇱, 🇬🇧, 🇨🇭, 🇺🇸, 🇪🇸, 🇬🇷, 🇨🇦, and 🇫🇷.

If you signed up and you didn't receive an email from us, please contact us.

www.mbsplugins.de/archive/2025...
December 18, 2025 at 7:42 AM
MBS #FileMaker Advent calendar - Door 17 - Compare tables

The FM.CompareTables function can compare changes in tables.
It compares two tables for their fields and records and checks whether data has been changed, added, or deleted.

www.mbsplugins.de/archive/2025...
December 17, 2025 at 3:51 PM
#FileMaker Server 22.0.4 is there

Enhanced OData capabilities, macOS 26 compatible, Security Fixes and bug fixes.

help.claris.com/en/server-re...
Claris FileMaker Server Release Notes
help.claris.com
December 16, 2025 at 5:40 PM
MBS #FileMaker Advent calendar - Door 16 - Delete

Today we want to take a look at how to delete records. As already mentioned in door 3, we can also delete records using the MBS SQL functions.

www.mbsplugins.de/archive/2025...
December 16, 2025 at 4:11 PM
Translation Framework in #Xojo

Since macOS 26 (and iOS 26) you can use the Translate framework to perform on-device translation services. You can use this with the upcoming MBS Xojo Plugins, currently in beta test.

www.mbsplugins.de/archive/2025...
December 16, 2025 at 7:25 AM
MBS #FileMaker Advent calendar - Door 15 - Information about tables and base tables

In order to perform SQL queries, we need to know the database structure. Which tables do we have and what are the names of the fields in the corresponding tables?

www.mbsplugins.de/archive/2025...
December 15, 2025 at 4:15 PM
MBS Xojo Plugins, version 25.6pr3

Merged a couple of plugin parts
Fixed a problem with DASessionMBS class' constructor
Updated Scintilla to version 5.5.8.
Changed minimum deployment to macOS 10.13 and iOS 12.0.
Added IndentSize property to JSONMBS class.

www.mbsplugins.de/archive/2025...
December 15, 2025 at 10:50 AM
MBS #FileMaker Plugin, version 15.6pr3

Fixed an issue with FM.InsertOrUpdateRecord and field names containing double colon.

Changed Text.HTMLtoStyledText to add return after DIV element.

Added JSON.SetFormatOptions function.

www.mbsplugins.de/archive/2025...
December 15, 2025 at 10:21 AM
MBS #FileMaker Advent calendar - Door 14 - SQL and JSON

We have already established that we can output the results of our SQL query not only as text, but also as a matrix, for example.

Today, we want to receive our results as a JSON return.

www.mbsplugins.de/archive/2025...
December 14, 2025 at 8:18 AM
MBS #FileMaker Advent calendar - Door 12 - UNION

Today, I would like to explain the term UNION in SQL in detail. With UNION, we can combine results from multiple tables.

Enjoy the 12th article from Stefanie in this series.

www.mbsplugins.de/archive/2025...
December 12, 2025 at 1:14 PM
Christmas Funding Drive for The FM Soup

As you may know the FileMaker Soup is a community organized forum for English speaking Claris #FileMaker developers to support each other.

The forum is run by a non-profit organization.

the.fmsoup.org/t/fm-soup-fu...
December 12, 2025 at 8:58 AM
MBS #FileMaker Advent calendar - Door 11 - Adding records

Today, we want to take a look at how we can use SQL to insert new records into our table with FM.SQL.Execute or FM.InsertRecord.

www.mbsplugins.de/archive/2025...
December 11, 2025 at 2:27 PM
MBS #FileMaker Advent calendar - Door 10 - Minimum and Maximum

Welcome to Door 10. Today, I would like to talk to you about the FM.SQL.Max and FM.SQL.Min functions.

www.mbsplugins.de/archive/2025...
December 10, 2025 at 5:57 PM
With Xojo 2025r3 we got a new thing: Libraries

Let's check the new library feature in #Xojo and look a bit into how to use it and what benefits and limits it has.

www.mbsplugins.de/archive/2025...
December 10, 2025 at 11:46 AM
Three weeks till year's end

You can order licenses already for 2026 and beyond and get invoice in 2025. New license and multi year renewal for MBS #FileMaker and #Xojo Plugin licenses.

www.mbsplugins.de/archive/2025...
Three weeks till year's end
www.mbsplugins.de
December 10, 2025 at 7:23 AM
MBS #FileMaker Advent calendar - Door 9 - Totals and averages

Today, I would like to introduce two functions that you can use to evaluate the data in your results even further: FM.SQL.Sum and FM.SQL.Avg.

www.mbsplugins.de/archive/2025...
December 9, 2025 at 2:58 PM