New in this prerelease of version 14.6 of the
MBS FileMaker Plugin:
- Removed the dependency on VCRUNTIME140_1.DLL. Appeared back in pr1.
- Updated DynaPDF to version 4.0.95.269.
- Added DynaPDF.GetLastTextPosXAbs and DynaPDF.GetLastTextPosYAbs functions.
- Improved XML.SetPathValue to not create duplicate nodes when finding them using namespaces.
- Tuned formatting of calculations to break behind and/or for long lines.
Download at
monkeybreadsoftware.com/filemaker/files/Prerelease/
You can subscribe to our FileMaker mailing list to get notified for new pre-release and release versions.
Today is day 5 of our calendar and our monkey has a few calls to make on his iPhone. He just doesn't want to keep typing in the number and searching for the customer. It would be much easier if he could simply save the specific contacts in Apple Contacts with the touch of a button. That's no problem, because as a Mac user you can read and write data in Apple Contacts. We use our Contacts functions for this.
But before we can start, we first need to be able to assign phone numbers and email addresses to our contacts. Until now, this was very complicated because we had to leave the giftee layout and enter the data in the respective layouts of the tables. We would now like to change this. To do this, we go to our relationship diagram and double-click on the equal sign between our phone and giftee relationship. Then the Edit Relationship dialog opens and we can make settings.
Here we can decide whether we can delete or create data records via this relationship. To do this, we can make a choice in the checkboxes at the bottom. We tick Allow creation of records in this table via this relationship and Delete related records in this table when a record is deleted in the other table for the Telphone table. This allows us to create records in our portal and if a gifte is deleted, the associated telephone numbers are also deleted. We now do the same for the mail addresses.
(more)
 |
 |
 |
| Door 4 - Add GTC with DynaPDF |
Today I would like to show you a tool that you can use in FileMaker with the MBS FileMaker Plugin: DynaPDF. With DynaPDF you have the possibility to create, edit, merge, analyze or sign PDF documents in FileMaker. DynaPDF offers you many possibilities around the topic of PDF.
Our monkey also wants to use one of these functionalities today. Because today we want to build the possibility to attach user terms and conditions to a PDF document. The user terms and conditions always remain the same and can be attached to any outgoing document, e.g. an invoice. I will show you how this works today in this door.
First we have to initialize DynaPDF, which means we have to tell FileMaker where the DynaPDF function library is located. The files are automatically delivered with the download of the plugin and can be found in Examples > DynaPDF. The files have the extension dll and dylib. Which of the files you need depends on your operating system. If you want to use DynaPDF on a Mac, you will need the path to the dynapdf.dylib file. If we are working with Windows, it also depends on whether we are working with a 32 or 64 bit version. If you are using FileMaker 19 or higher, this decision is easy, as only a 64 system can be used here. In any case, the library has the extension .dll.
If you are not sure, just put both dll in the same folder and the plugin will grab the file it needs. The next piece of information we need is the DynaPDF license key. If you want to use DynaPDF in your solutions, you need an appropriate DynaPDF license and an MBS FileMaker Plugin license.
There are four different DynaPDF licenses. Which license you need depends mainly on which DynaPDF functions you use. If you need more information, please visit our website to find out which license is right for you. However, we do not necessarily need a license to try it out, but need to live with the watermark.
After we have determined the path to the libraries and the license key, if available, we can now call the DynaPDF.Initialize function. In the parameters we first enter the path to the library and then the license key. If we do not yet have a license key, we pass an empty string here.
(more)
Viele Kunden interessieren sich im Moment für das Thema elektronische Rechnungen. Mit dem MBS Plugin und den DynaPDF Funktionen können wir Ihnen helfen dies in FileMaker Lösungen und Xojo Anwendungen zu implementieren.
ZUGFeRD
Wenn Sie in das Thema e-Rechnung rein schauen, dann sollten Sie auf der Webeite vom Forum elektronische Rechnung Deutschland einmal lesen, was ZUGFeRD, was XRechnung und was Factur-X ist.
Dann laden Sie sich den aktuellen Standard mal runter: ZUGFeRD 2.3.2. In dem Download finden Sie dann die Spezifikation für ZUGFeRD (und Factur-X). Dazu kommen noch diverse Code Listen, Schema Dateien und viele Musterrechnungen.
(more)
Welcome to our third door in this advent calendar.
Today we would like to start expanding our database.
We want to have the possibility to store additional documents for the giftees.
For this purpose, we will create a table with the name Files.
This table should store the name of the file, the type and the file itself as a container value.
In addition, we also need a field with the Foreigen Key here,
because we want to establish a relationship so that the files can also be assigned to the giftee.
Now we have to think about how we want to bring these files into our database.
We want to use drag and drop to do this.
So we build an area where we can drag the desired file and the type and name are then automatically
read out and the file and the remaining information are then stored in a record in the new table.
This data record should be related to the giftee that is currently displayed.
We can create drag and drop areas with the MBS FileMaker Plugin.
To avoid wasting useful space for a drag and drop field on our layout,
we would like to place this drag and drop field as an overlay,
i.e. a freely movable area on our layout that can be activated and
deactivated by clicking a button. To do this, we first need to create an overlay
and then assign drag and drop functionality to it.
So let's start with the overlay first.
To do this, we have the functions from the Overlay section.
First, we create a new overlay with the MBS function Overlay.Create.
This function returns a reference.
We also need to specify this reference in the other functions so that we know exactly
which overlay in our project the functions should be applied to.
Next, we want to determine the size and starting position of our overlay.
To do this, we use the Overlay.SetFrame function and,
as already mentioned, specify the overlay reference, the position with X and Y
coordinates and the height and width of the overlay in pixels.
So we want the top left corner of our overlay to be 30 pixels away from the right and top edge.
In addition, our overlay should be square and 200 x 200 pixels in size. Our function call looks like this:
Set Variable [ $r ; Value: MBS("Overlay.SetFrame"; $overlay; 30; 30; 200; 200) ]
(more)
New in this prerelease of version 14.6 of the
MBS FileMaker Plugin:
Download at
monkeybreadsoftware.com/filemaker/files/Prerelease/
You can subscribe to our FileMaker mailing list to get notified for new pre-release and release versions.
Hello and welcome to this year's MBS FileMaker Advent calendar.
This year our logo monkey has turned into a Christmas elf and has to take care of the coordinated distribution of presents at Christmas.
What could be more obvious for our monkey than to get an overview with a FileMaker database.
Over the next 24 days, we'll show you how to pimp a simple database with the help of the MBS FileMaker Plugin.
All you need is to have fun with FileMaker.
We'll start by creating the database and work our way through step by step.
Even though the advent calendar is suitable for beginners,
advanced users and professionals can certainly use some of the ideas from the advent calendar for their own purposes.
So let's start with our first door and thus with the basis for this calendar.
Our FileMaker database.
Although we provide you with this database,
it can be useful to deal with the topic of how such a database can be set up.
Initially, we only have a few tables, which we will expand over the course of the Advent calendar.
Initially, our database consists of 3 tables.
The table with the name of the giftee is our main table in which we find the information about the giftee,
such as the last name, first name, date of birth and address.
In addition, each recipient has their own identification number that can be uniquely assigned to them.
This means that the number exists exactly once for each recipient.
In this example, we call it the Primary Key in the table.
(more)
You may know we have over 40
goodies for developers on macOS to make the live easier. And of course also a few things for Windows. But did you know that not only developers enjoy these enhancements, but also your users?
While the normal users of your solutions don't enjoy syntax coloring as they don't edit scripts, they may still enjoy our benefits in same places like the search feature in the export dialog.
(more)
Check out the FMTraining.tv website. Richard Carlton and his team do a daily free live stream about FileMaker to watch.
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 check out the new MBS Plugin 14.5: Announcement, new functions and release notes.
(more)
As you may know Americans love to shop on Black Friday and Cyber Monday. This year Black Friday is 29th November. About half our customers are in North America, so we are happy to offer you a discount if you buy this weekend.
Please use coupon code
BlackFriday for the web shop with 20% off for new licenses of MBS Plugins, DynaPDF and
LibXL.
Updates are already offered with discount (usually 50%) compared to new purchases and and our academic prices already have a discount, too. If you like, you can email us to get an order link for all licenses you need or provide an invoice if needed. Especially if you like to use Paypal for payment, we can provide a link with discount or write a custom invoice.
Order MBS FileMaker Plugin Order MBS Xojo Plugins Order LibXL
As usual the discounted offer allows you to buy whatever licenses you may need in the next year. Especially if your license expired in 2023 or before, this is a great chance to get up to date!
This offer expires 3rd December 2024.
PS: We can do DynaPDF upgrades with the discount, too. Please contact us if you need an upgrade for something, e.g. to make invoices with ZUGFeRD.
You have a question? Please don't hesitate to contact us by email or
form. We may help to point you to the right offer.
A recording of the MBS FileMaker Presentation at the EngageU conference in Malmö, Sweden in November 2024. Christian summarizes what is new in the plugin for 2024.
Watch on YouTube. Let us know if you have questions.
We are glad to inform you that the new LibXL version 4.5.0 is available now.
What's new in the version 4.5.0:
added support of workbook properties (xlsx)
added support of XLOOKUP, LET and XMATCH functions (xlsx)
added access to default column and row formats: Sheet::colFormat() and Sheet::rowFormat() methods
added the updating/moving existing pictures after inserting or removing rows and columns with Sheet::insertRow(), removeRow(), insertCol() and removeCol() methods (xlsx)
added the Book::removeAllPhonetics() method: removes all phonetics data (furigana) from a workbook (xlsx)
added some specific language locales for detecting dates in the Sheet::isDate() (xlsx)
fixed a precision error with calculating RGB values from theme colors (xlsx)
fixed a bug with writing a corrupted file after using Sheet::removeCol(), Sheet::insertCol(), Sheet::insertRow() methods
with shared formulas in a sheet (xlsx)
fixed a bug with using a sheet name with a quote together with the Sheet::setPrintRepeatRows() and Sheet::setPrintRepeatCols() methods (xlsx)
fixed a bug with loading some xlsx files
The LibXL library can be used with MBS Plugins in Xojo and FileMaker. Updated plugins will be available soon. As usual we add the new functions soon. If you need help or want to try the new version early, let me know.
If you like to hang out with a few FileMaker nerds at an English speaking conference in Vienna, you should sign up for Vienna Calling soon. The early bird offer expires 30th November 2024.
4th to 7th June 2025 in Vienna, Austria
If you like to hang out with some FileMaker geeks and talk all day about technical details, this is your chance. Be ready to share something like showing a cool technique in your projects or how you use FileMaker!
(more)
Präsentation von Stefanie Juchmes-Simonis anlässlich der FileMaker Konferenz in Liechtenstein im Oktober 2024 mit Übungen, wie man im Büroalltag den Stress abbauen kann.
Man sieht sich auf der FileMaker Konferenz in Hamburg, vom 15. bis 17. September 2025.
That was a great
EngageU conference with 200 people from 25 countries. We had 35 sessions in 4 tracks over 2 days plus an optional training day. After the
Claris Engage, this is the biggest conference for FileMaker in the world.
Thanks
- to Squaremoon and Clickworks for organizing it.
- to the attendees for joining.
- to the sponsors to support the event
- to Claris to show up with staff
We were very happy to see 30 women to join as well as a lot of younger FileMaker developers.
We had a terrific conference and met a lot of people from all over the world. Even people from Australia came to Malmö. See you next year at one of the
many conferences!
Please visit us at the booth to say Hello, ask a few questions and learn what is new for
MBS FileMaker Plugin. Join our presentation on November 19 at 10:30 o'clock for the presentation.
As usual you can come by, read the papers, ask us questions and talk with us about existing and future features.
Use coupon code
FileMakerConference for the discount on new licenses. See
pricing page.
See you soon!
Präsentation von Stefanie Juchmes-Simonis anlässlich der FileMaker Konferenz in Liechtenstein im Oktober 2024 mit einem Einstieg in eigene Funktionen für FileMaker Anfänger.
Man sieht sich auf der FileMaker Konferenz in Hamburg, vom 15. bis 17. September 2025.
Earlier this year we added the Overlay functions to our MBS FileMaker Plugin. You can use them to show a graphic on screen outside or on-top of the FileMaker windows on macOS and Windows. This is great for showing splash screen with your logo when the solution starts, some navigation or arrows for a tutorial. What you show is up to you and some people just use it as a notification banner.
For version 14.5 we add a new function called Overlay.AddWebViewer to the plugin. Use this function to add a web viewer to the overlay instead of a picture. The web viewer can load some HTML plus CSS to show a webpage with transparency. This may include showing images, an animated GIF or even a movie. The website could also have some JavaScript to do some animation.
Let's start with a script to create an overlay with a web viewer. The Overlay.AddWebViewer function takes the overlay and adds a web viewer using WebKit on macOS or Microsoft's WebView2 control on Windows. Once we have it, we can load an URL with a HTML Page from our website and show the overlay. Loading the webpage from our website allows us to adjust it later.
(more)
Nickenich, Germany - (November 12th, 2024) -- Monkeybread Software today is pleased to announce MBS FileMaker Plugin 14.5 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 14.5 has been updated and now includes over 7500 different functions, and the versatile plugin has gained more new functions:
For this release we updated our Barcode detection code. The Barcode.Detect function can now better detect barcodes, e.g. find a small QR Code on an full page. The Barcode.DetectAsJSON function can find multiple barcodes and return them all as JSON with details like their position on page.
On macOS we have plenty of enhancements to FileMaker Pro for developers. We added auto complete for custom functions to offer you table occurrences, field, operator, function and parameter names. We even make suggestions for Get() functions.
We add a comment field to the manage database dialog. To put in a comment, you create a field named _TableComment and add a comment there. Commit your changes by closing the dialog. The next time you select the table in the dialog, the plugin will show the comment below the table name.
We added tooltips to show field comments in the debugger, export dialog, script workspace and calculation dialogs.
For DynaPDF we have new parser functions to list and then delete images on a PDF page. You can query the color and text alignment and bounding box for annotations. The DynaPDF.GetGlyphOutline function queries the outline of a glyph used to draw a character.
On macOS and iOS you can now use the Vision.RectifyDocument function to align and rectify an image. The same feature as used in the DocumentCameraScan functions, but now available on its own.
Our overlay windows can now show content based on a web viewer. Use Overlay.AddWebViewer to create the web viewer inside the Overlay. Load some HTML and CSS to show content with transparency in the overlay.
The Process.List function got implemented for Linux, we have a Math.Rate function to calculate interest like Excel, Text.FilterSwissQRCode function to filter text for use in Swiss payment QR-Codes, new WordFile functions to read and write metadata in Word files and a new List.Intersection function.
Added CURL library to version 8.10.1, discount to 2.2.7d, DynaPDF to 4.0.94.265, jpeg to 9.6, libarchive to 3.7.6, LibXL to 4.4.0, OpenSSL to 3.3.2, SQLite to 3.47.0, libxml2 2.13.4, libxslt 1.1.42, Xcode to version 16.0 and the plugin SDK.
See release notes for a complete list of changes.
