Community Videos, Tips, & Techniques, Articles.

You can copy and paste stuff in FileMaker: Layouts, script steps, scripts, custom functions, value lists, fields and table definitions. Each time FileMaker puts a XML on the clipboard, but you can't see it. It is kind of hidden, so FileMaker can find it for pasting. But you can't just paste it to your favorite text editor. With MBS Plugin 15.4 we change this. Our plugin monitors when FileMaker goes to back or comes to the front and updates the clipboard: If the clipboard has FileMaker's XML, we copy the XML into the text section, so you can paste it in a text editor. If the clipboard has text, which is valid XML for FileMaker, but not yet the section that F…

Have questions about the MonkeyBread Plug-in? Bring them to our Live Q&A with Christian Schmitz tomorrow (8/29) at 1PM Pacific and get them answered! Register for this LiveStream: https://fmtraining.tv/register.php?eventid=5596821672510236438838997538406536204005883658397647436838 [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

With MBS FileMaker Plugin 15.3 we allow you to dynamically register custom function via plugin functions. Yes, make your own functions on the fly and use them in all your database files. Instead of defining custom functions in FileMaker directly and then copying & pasting them to other files, you can store them in records and register them at startup. Each function gets the following: ID It needs an unique ID which is what FileMaker internally uses to find the function. Please use an ID >= 3 and assign them yourself to the functions. Name An unique name, which doesn't match a FileMaker function or an existing cus…

Last week HOnza and Vince Menanno joined for a quick lesson on “Go to List of Records”. They both return tomorrow (8/28) at 1PM Pacific for an advanced look at the new script step. Register for this LiveStream: https://fmtraining.tv/register.php?eventid=6267576476932978591550071579391940020942271731265061483761 [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

One day of 360Works’ MirrorSync and FM StartingPoint wasn’t enough so Jesse Barnum is returning tomorrow (8/27) to continue the conversation! Join us to learn how you can sync offline FileMaker solutions. Register for this LiveStream: https://fmtraining.tv/register.php?eventid=1421077929525970110963523311304743939349612646002104209874 [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Rick Kalman, from Claris, is back with more exciting Claris FileMaker 2025 news! Check out this recording to learn about the latest FileMaker Pro and Go updates. You can also read the release notes here: https://help.claris.com/en/pro-release-notes/content/index.html [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

MirrorSync from 360Works allows you to sync offline FileMaker solutions and now the MS scripts and layouts are pre-setup in FM Starting Point. All you have to do is buy a license and sync. Join Jesse Barnum tomorrow (8/22) to learn more! Register for the LiveStream: https://fmtraining.tv/register.php?eventid=4237816003638079921512569608244313097543825304657759769246 [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

HOnza and Vince Menanno join us tomorrow (8/21) for a quick lesson on the new “Go to List of Records” script step! Register for the LiveStream: https://fmtraining.tv/register.php?eventid=2380428552311183387876352322730974339446991906129377810219 [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

“Using InspectorPro, FileMaker developers can analyze their solutions to gain insight into performance” and it is now FREE! Vince Menanno joins us today (8/19) for a two-day breakdown of InspectorPro 9. Register for the LiveStream: https://fmtraining.tv/register.php?eventid=2791064889353062958575603871484874152766413622727582322698 [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

For MBS FileMaker Plugin 15.3 we added iOS support to the ListDialog functions in addition to MacOS and Windows. You can just use it anywhere in a script or calculation to have the user pick something from a list. For example you can fill the list with a text field holding all options. or you use SQL to either go over values in a table to collect them (with distinct option) or you use FileMaker_ValueLists in SQL to query a value list content. Here a small example script: Set Variable [ $r ; Value: MBS("ListDialog.Reset") ] Set Variable [ $r ; Value: MBS("ListDialog.SetPrompt"; "Please select your country:") ] Set Variable [ $r ; Value: MBS("ListDialog.Se…

Todd Geist is back for a full week of Claris FileMaker 2025 and AI! Register for Day1: Basic Concepts: https://fmtraining.tv/register.php?eventid=2703023610114211989425823178566511211135935067408397617467 [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Claris Inc. rolled out two FileMaker Server updates this week! Check out this recording of Rick Kalman, from Claris, who hopped on our LiveStream to give the latest update. You can also read the release notes here: https://help.claris.com/en/server-release-notes/content/index.html. [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

With over 7,700 functions that allow Claris FileMaker developers to extend their solutions, the MonkeyBread Plug-in is an amazing tool. Join Christian Schmitz tomorrow (8/15) to learn about the latest MBS 15.3 release! Register for the LiveStream: https://fmtraining.tv/register.php?eventid=5523573893077451445972837622030260322432735770232146782526 [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

HOnza returns tomorrow (8/14) for a Claris FileMaker 2025 performance breakdown! Learn about the insights and results from his latest performance tests, including the JSON functions. Register for the LiveStream: https://fmtraining.tv/register.php?eventid=3784146308619509647360503524270883034794388641142932231246 [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Nick Hunter returns with a two day LiveStream on FileMaker schema naming conventions. We’ll be covering best practices for naming Tables, Fields, and Table Occurrences! Register for the LiveStream: https://fmtraining.tv/register.php?eventid=4509108042210648732751639990558475401547226119740700517966 [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

For the next version we include round corners for the iOS SDK with the Window.SetRoundCorners function in MBS FileMaker Plugin. You can call Window.SetRoundCorners just after showing the card window. Our plugin will look for the top most card window and apply the corners. Since there may be a short delay before FileMaker actually creates the card and shows it, we need to wait a bit. In our sample script, we perform a short script pause. Then even if FileMaker animates the card, the plugin can find it and apply the corners. Here is a sample script for iOS: New Window [ Style: Card ; Name: "test" ; Using layout: “PlaceHolder” ] Pause/Resume Script [ Du…

Did you know, that our variable auto completion works directly inside the Script Workspace within a line? And you can define the variables with "Set Variable" or within comment lines. See also Auto Complete variables and functions

FM BetterForms allows FileMaker developers to connect their solutions to the web. Charles Delfs (FM BetterForms Founder) joins us this entire week to demonstrate how! Register for Day 1, Intro to Web Apps: https://fmtraining.tv/register.php?eventid=4620076124158292796941918363615500960486037618259855232942 [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

In this article we want to introduce you the new functions from the MBS FileMaker Plugin in version 15.3. SQL First of all, I would like to introduce you to the new features for SQL. A very interesting function is the SQL.InternalSQLiteLibrary.Dump function. This function convert an SQLite database into UTF-8 text SQL statements that will exactly recreate that original database. We also have new functions that allow you to activate extensions within SQLite. With SQL.InternalSQLiteLibrary.SetBase64ExtensionEnabled you can enable the base64 extensions to convert (binary) blobs and base64 text into each other. You can also use SQL.InternalSQLiteLibrary.SetCSVEx…

Did you notice that stepping in the debugger in FileMaker scrolls to show the current line? We think it would be better to show you the next few lines, so with MBS FileMaker Plugin 15.3 we adjust the scrolling and reveal a few more line. This feature automatically kicks in on macOS if you install the new plugin. We scroll about 3 rows up or down. If you don't like it, you can turn it off with the SyntaxColoring.DebuggerScrolling.SetEnabled function.

Recently we had an user asking how much disk I/O certain script steps cause and whether we can see how much FileMaker writes or reads from disk. In MBS FileMaker Plugin 15.3 we added a new SystemInfo.AppResourceUsageStatistics function for macOS to query various statistics and return them as JSON. You can query: CPU Time Memory usage Neural engine memory Instruction counters Energy use Disk i/O Wakeups Pageing counters We can take a direct look on the statistics before doing an action and after the action. We see directly the CPU time spend for how many instructions, the memory allocated and whatever disk …

This may change how you write scripts. Your longer scripts may now have an index on top with goto: URLs jumping to specific lines. The goto:start and goto:end links may help to jump to start or end of the script. And script: links may jump to a different script. And a search: link may do a search in the script and jump to a different line like a section of the script. Let's start with script links. You put in the script name after the script: prefix. The plugin will read the name, decode percent escaped sequences and looks for a script in same file with the given name to show it. If you have special characters in the script name, please use GetAsURLEncoded() f…

In case you missed it, Wim Decorte has joined us for a week of AI on FileMaker Server with Claris FileMaker 2025. Today is Day 2 and we’ll be covering types of models! Register for the LiveStream: https://fmtraining.tv/register.php?eventid=4210962530076068049077341935697653854136383729059115080228 [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Did you know, that FileMaker allows you to move lines up and down in ScriptWorkspace with cursor keys while control key is pressed? Pick a line and press down the control key and simultaneously press up or down cursor key. This moves the selected lines in Script Workspace up or down by one line. For MBS FileMaker Plugin 15.3, we add the same feature for the calculation editor on macOS. Just hold down the control key and press cursor up/down to move the current selected rows by one row up and down. This feature is enabled by default on macOS and so far it seems to work fine for our clients. Please try it! Shortcuts for calculation editor …

In MBS FileMaker Plugin 15.3 we have a Format button on macOS for the data viewer's detail view. If the data is XML or JSON, we can use the format and colorize functions: JSON.Format & JSON.Colorize, XML.Format & XML.Colorize. Let's say you have some variables in the data viewer with XML or JSON content. When you double click the text, you get a new window showing the detail. Here we find the Format button added by MBS Plugin. Press the button and it will format the content: If we get a parse error or the content is not XML/JSON, we beep. If you click OK, the fo…

Don’t miss this! Claris Engineering joins us today (7/16) for a 3 day deep dive on FileMaker 2025! Lucy Chen, Wade Ju and Clay Maeckel start us off today at 1PM Pacific. Register here: https://fmtraining.tv/register.php?eventid=4406479901408074645562189504814393564030761829183247793771 [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

The Claris FileMaker 2025 fun continues! Today at 1PM Pacific we’ll be holding a Q&A for Claris Studio and Claris Connect. More LiveStreams coming this week. Register: https://bit.ly/fm25_fmtv_bulk Claris will be bringing their Community Live events in for a landing tomorrow (7/15) at 8AM Pacific. Don’t miss out! Register: https://bit.ly/fm25_claris_bulk

You can check the system requirements for FileMaker Pro and Server on the Claris website. In general there are two sides: First you install FileMaker software on a supported OS to receive support in case something doesn't work. On the other side, you may still use an older computer with an older operation system. Eventually you may need to upgrade the computers and OS as you want to get security fixes and not loose your valuable data to some malware attack. FileMaker Pro FileMaker Pro operating system requirements FileMaker Pro for macOS is listed to work on macOS 14 and macOS 15. But FileMaker 2024 and 2025 launches and operates fine on macOS 13.…

Since FileMaker 2025, you have a quick and easy function to extract text from PDF files in containers: GetTextFromPDF ( container ) You can call it and quick and easy get some text. Great, but what runs under the hood? For macOS and iOS we expect Claris to use PDFKit functions built-in to macOS. So it should return the same as our PDFKit.GetPDFText function. For Windows and Linux, the system doesn't come with a PDF library, so FileMaker brings pdfium library. This is the one used by Chromium and it can do text extraction. Since Claris uses a different libraries, you may not get the exact same output on both. There will be differences in the…

FileMaker 2025 (v22.0) comes with improved tools. When you install FileMaker Server, you find these tools in the /FileMaker Server/Database Server/bin folder. FMUpgradeTool A command-line utility (developer preview) for applying schema, layout, or script changes to a FileMaker Pro .fmp12 file without affecting the data. It uses XML-based patch files to modify an existing file (the source) and generate an updated version (the destination). Common use cases include delivering critical bug fixes, applying temporary debug patches, or making small enhancements between full app releases. It does not support migrating or altering record data. Best used for lightweight…

Claris released today FileMaker 2025 in version 22.0.1. Works fine with MBS FileMaker Plugin 15.2. You get a few cool new things. Let me point to a few highlights: Artificial Intelligence The new version embraces AI with providing a model server within FileMaker Server. You can install various models using the Miniforge project. Then you can have the server use embeddings to perform semantic search in server scripts. Linux support FileMaker Server supports Ubuntu 24 for Linux in addition to version 22. Please consider moving your FileMaker Server to Linux, if you haven't yet. Upgraded SQL engine …

Claris FileMaker 2025 is here and we have 4 weeks of livestream content! RC and Rick Kalman kick it off today with an overview at 1PM Pacific. Register here: https://bit.ly/fm25_fmtv_bulk Starting tomorrow (7/9) at 8AM Pacific, Claris will start a series of Claris Community Live events for this latest release. Register here: https://bit.ly/fm25_claris_bulk

Starting on July 8th, Claris staff and community leaders will be joining us for multiple LiveStreams on the Claris FileMaker 2025 platform! Find the list of LiveStreams and bulk register here: https://fmtraining.tv/register_bulk.php?eventid=5492522896098769845435058504559314874436564574939744775805 [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

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. A question and answer round for the MBS FileMaker Plugin. We talk about automatically installing the plugin with scripts. The we check DynaPDF functions to merge PDFs and convert HEIF/HEIC images to add them to the PDF. We render PDF pages and generate barcodes. A PDF form gets build, filled with data and exported. The user updates data and we import the changes back to FileMaker. We check to…

Recently we had the idea that we could draw charts ourselves with the GraphicsMagick functions. It's more a fun project, but I was able to draw a simple bar chart with a few drawing commands. We use a few filled rectangles to draw bars and calculate them on the fly in the while loop. Let ( [ We start here with a few values. You could of course pass them as parameters in a custom function. But for the example we just pass some example data: cities = List ( "Hamburg" ; "Berlin" ; "Munich" ; "Cologne" ) ; values = List ( 1800000 ; 3700000 ; 1500000 ; 1100000 ) ; And we define a color palette to pick the colors for…

Sometimes you may have a project where you need to output bidirectional text. If you output any of the following languages, you may need to think about how to handle the right to left direction: Arabic Aramaic Azeri Dhivehi/Maldivian Hebrew Kurdish (Sorani) Persian/Farsi Urdu When you use DynaPDF in FileMaker with MBS FileMaker Plugin, you can use the DynaPDF.SetBidiMode function to enable bidirectional mode and set it to RightToLeft layout. Of course you need to load a font with unicode code page to have it cover all the characters. The bidi algorithm makes sure you can mix left to right and right to left text withi…

A couple weeks ago we had Todd Geist join us for a week of OttoFMS. Today at 1PM Pacific, we’ll have Richard and Jacob attempting their own OttoFMS deploy (without adult supervision)! Register for the LiveStream: https://fmtraining.tv/register.php?eventid=3876557265812261929464853932319854139565507419367665785512 [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

When you build a mail solution using our CURL functions in MBS FileMaker Plugin, you may use sample code to do an IMAP upload. Commonly you use this to upload an email to the Sent folder when you sent it via SMTP. New in version 15.2 is the CURL.SetOptionUploadFlags function to pass the flags for uploads. In older CURL versions there was a default to set seen flag, but now you can and shouuld control it. For example we can use this to set the seen flag for an email, when we upload it to the sent folder, so it doesn't appear as a new email. Or you can set the Flagged flag value to mark the email as flagged. Here is the list of the flags: …

Did you know that you can use JSON in our Saxon functions? Originally Saxon is a XML library, but it can take JSON as input in various queries. The queries internally work with maps and arrays and these can be filled by JSON. Let us show you how to use JSON for Saxon.XPathQuery and Saxon.XQuery functions: Saxon.XPathQuery XPathQuery (commonly called XPath) is a language used to navigate and select nodes from an XML document using path-like expressions. It's often used within XSLT, XQuery, and XML-processing tools to pinpoint data locations efficiently. We can use the Saxon.XPathQuery function in MBS FileMaker Plugin to run XPath queries directly i…

Twilio provides APIs for developers to build communication features into their applications, including FileMaker. Learn how to use Twilio to implement SMS into FileMaker today at 1PM Pacific! Register for the LiveStream: https://fmtraining.tv/register.php?eventid=1512116919499215269506038597543338117833371045348439189027 [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

For the next version of MBS FileMaker Plugin in 15.3 we add the Window.SetRoundCorners function to provide round corners. At the recent Vienna Calling conference a developer asked if we can get the edges of the card in FileMaker to be round. And yes, that is indeed possible. Once the card is shown, the MBS Plugin can find the card window and apply round corners to it. This even works on Windows: This seems to work fine in FileMaker Pro on macOS and Windows. It does of course not work for WebDirect or FileMaker Go. To add the round corners, you simply call our plugin function Window.SetRoundCorners just after showing the card. The plugin fi…

Nick Hunter is back with a new series! Join us today at 1PM Pacific for Day 1 of Intermediate & Advanced Relationships. Register for the LiveStream: https://fmtraining.tv/register.php?eventid=5740316211337105268699473510470998658661277504816385414462 [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Did you notice that MBS FileMaker Plugin 15.2 includes a new feature to add keyboard shortcuts for the result data types for a formula? If you visit the manage database dialog, you can use keyboard shortcuts to pick data types for a field: Text ⌘ T Number ⌘ N Date ⌘ D Time ⌘ T Timestamp ⌘ M Container ⌘ R Calculation ⌘ L Summary ⌘ S If you define the formula, you get a dialog like the one shown above. The MBS Plugi…

New Client Story: Lab9 & ClickWorks How do you scale internal systems to support a growing retail and service network; without losing agility? From building their first FileMaker tool in-house back in 1993 to powering daily operations for 300+ employees today, Lab9 has always valued efficiency and innovation. When their internal platform needed a complete redesign, they partnered with us at ClickWorks. Together, we reimagined their platform by refining design, improving day-to-day usability, and supporting teams across service, retail, and operations. It’s a collaboration that still continues today. Read the full story here - https://www.clickworks…

Did you know we can pass styled text to Apple Mail? We can use our SharingService functions to share data with other applications. This includes passing styled text, containers with images, files or URLs. Available services Using the SharingService.ServicesForItems function, we can query the available services to request. This allows us to check which services are available and only show a button to share via Airdrop, if that is possible. By default you have these services available on macOS: Title Name Text File Path Images URLs Add to Photos com.…

Todd Geist joins us for the next 5 days at 1PM Pacific for a series on OttoFMS and FileMaker Server! Learn more about this free data migration tool and deployment manager. Register for the LiveStream: https://fmtraining.tv/register.php?eventid=2869115884610708856046853598033301980653908467289176017307 [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

FM Starting Point 2025 is now out! We’ll be showing an overview of this free FileMaker CRM today at 1PM Pacific with Myles and Richard. Register for the LiveStream: https://fmtraining.tv/register.php?eventid=2378924403701264833127834713061775947583700310146634267859 Download FMSP: www.FMStartingPoint.com [email protected] www.FMTraining.TV www.rcconsulting.com

Join Claus Lavendt at 1PM Pacific today to learn how to secure your FileMaker Server from DDoS attacks. Register for the LiveStream: https://fmtraining.tv/register.php?eventid=1311431668691501837330622039815206072536283428976643488498 [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

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 talked about the 15.2 release: See announcement, the new functions and release notes. More videos The MonkeyBread Plug-in 15.2 Update with Christian Schmitz MonkeyBread Plug-in Open Q&A with Christian Schmitz The MonkeyBread Plug-in 15.1 Update with Christian Schmitz 25 Ways to Improve Your Database Using the FileMaker MonkeyBread Plug-in - Day 3 …

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. A question and answer round for the MBS FileMaker Plugin. We check Window.Activate, Process.SetFrontMost, Time.Format, AVRecorder, WebView, DynaPDF, JSON and more functions. We check out the script workspace enhancements with the various shortcuts and the snippet database. More videos MonkeyBread Plug-in Open Q&A with Christian Schmitz The MonkeyBread Plug-in 15.…

We used to suggest scripts like the one below to install the MBS FileMaker Plugin and check for the error status. But the following script has a big problem, a little oversight on how FileMaker works. Try to guess what is wrong here: Install Plug-In File [ Install Plugin Update if needed::Plugin File Mac ] Set Variable [ $LastError ; Value: Get(LastError) ] Set Variable [ $LastErrorDetail ; Value: Get(LastErrorDetail) ] The script installs the plugin and in case of an error, we like to query the error code and message. But this script never gets the last error detail! You may guess that we query the last error number and detail for the first line with the ins…

For this week, Richard and Margaret will show you how to add a completely fresh table to an already busy customer database, and the ins-and-outs of that process. Day one will focus on Data Modeling! Register for Day One: https://fmtraining.tv/register.php?eventid=4170783299115422248254663575189648357730623808426609664042 [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

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 talked about the 15.1 release: See announcement, the new functions and release notes. More videos The MonkeyBread Plug-in 15.1 Update with Christian Schmitz 25 Ways to Improve Your Database Using the FileMaker MonkeyBread Plug-in - Day 3 25 Ways to Improve Your Database Using the FileMaker MonkeyBread Plug-in - Day 2 15.0 MonkeyBread FileMaker Plug-in R…

In this article we want to introduce you the new functions from the MBS FileMaker Plugin in version 15.2. LibXL Let's start with what's new in the LibXL component. LibXL supports you since years in creating, reading and modifying Excel files. In this release you get the possibility to add and format tables. First, we can add a table with the XL.Sheet.AddTable function. You can give this table a name, a range and a style. You can change the name and style later using the other functions we have added. To change the name, we use the XL.Table.SetName function. To change the style, use the XL.Table.SetStyle function. You can find out which styles you can use here (ht…

XSLT (Extensible Stylesheet Language Transformations) has been a core technology for XML data transformation since the early 2000s. While XSLT 1.0 laid the groundwork, subsequent versions — 2.0 and 3.0 — significantly expanded the language’s capabilities, power, and usability. You can use XSLT 3.0 in Xojo with MBS Xojo Plugins and our Saxon classes. Please check the MBS Xojo XML Plugin. The built-in XSLT in Xojo itself is only doing XSLT 1.0. Here’s a breakdown of what you can do in XSLT 2.0 and 3.0 that you simply *can’t* do in 1.0. 1. Data Types Beyond Strings XSLT 1.0 is essentially string-based. Everything is treated as a string or node-set, w…

Join Jacob Taylor this entire week at 1PM Pacific for a complete FileMaker Server deployment on AWS tutorial! Register for Day 1: https://fmtraining.tv/register.php?eventid=5229916340448395273284332695105701686724772640084971830651 [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

A client asked about using Gmail with oAuth 2 and our SendMail functions in MBS FileMaker Plugin. We have an existing example for Microsoft Office 365, which we can adapt for Google Mail. We change a couple of URLs, the scope and then it works fine. But let's go step by step. As part of the oAuth, we later get a callback. Usually this is for contacting a web server, but we like to do it locally. We use our WebHook functions to do within the FileMaker Pro application and catch the answer from the JavaScript running in the browser. Set Variable [ $$WebHooks ; Value: MBS("WebHook.Create") ] Set Variable [ $r ; Value: MBS("WebHook.Listen"; $$WebHooks; 9999) ] S…

Finish the week with Christian Schmitz at 1PM Pacific to learn all about the latest MonkeyBread Plug-in 15.2 release. Register for the LiveStream: https://fmtraining.tv/register.php?eventid=809123821662612783734956270981249872194503437221875530854 [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Kristian Olsen joins us today at 1PM Pacific to discuss his ChatGPT FileMaker Add-on! Register for the LiveStream: https://fmtraining.tv/register.php?eventid=3614694288955383683273482599222495102174289096230728870519 [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Rendering text in a PDF might seem straightforward—until you try working with languages like Arabic or Hebrew. These languages require more than just placing characters from left to right. Without proper handling, the result can be unreadable or even misleading. Let’s look at how DynaPDF handles this challenge using Bidirectional (Bidi) Mode and Complex Text Rendering. The Problem with Basic Text Rendering When rendering Latin-based languages like English, you can often get away with simply passing text directly to DynaPDF and letting it handle the rest. But try the same with Arabic, and you’ll see this: Anyone who reads Arabic would instant…

If you enjoyed Kyle’s basic overview of JSinFM, you won’t want to miss this deeper dive! Join Kyle today at 1PM Pacific to learn more about injecting JavaScript into existing FileMaker webviewers. Register for the LiveStream: https://fmtraining.tv/register.php?eventid=5368803657973188027105354062945446996115129825983705852975 [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Rick Kalman from Claris joins us today at 1PM Pacific for the latest FileMaker News and to answer your community questions! Register for the LiveStream: https://fmtraining.tv/register.php?eventid=1212623626360485692070330154464255243402192886437052523874 [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Eric from Proof+Geist joins us today and tomorrow at 1PM Pacific for a two day event on building web apps with FileMaker! Register for the Day 1 LiveStream: https://fmtraining.tv/register.php?eventid=5884922293066375025587310645265305002534536559884735428630 [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Christian Schmitz returns to the LiveStream today (April 23rd) at 1PM Pacific for an Open Q&A! Join us with all your MBS questions, comments and concerns. Register for the LiveStream: https://fmtraining.tv/register.php?eventid=4048207882000996402135159406659072721355097733327393321139 [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Join Jonathan Ray today (April 22nd) at 1PM Pacific to learn how to fully unlock the power of the text editor in Claris FileMaker! Register for the LiveStream: https://fmtraining.tv/register.php?eventid=227897429491623287876789677984606631026035680370764446089 [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Today we like to connect to a DuckDB database from FileMaker using the SQL functions in MBS FileMaker Plugin. For that we need the client libraries for DuckDB, but where to get them? macOS with homebrew For macOS you can use homebrew to install the duckdb package. Then you get the duckdb library installed. You find the library on an Apple Silicon Mac: /opt/homebrew/Cellar/duckdb/1.2.1/lib/libduckdb.dylib For an Intel Mac, you find it in the /usr/local folder in a sunfolder. All platforms Just got to the DuckDB installation website: Installation There you can click Version: Stable Release Environment: C/C++ Platfo…

"AND LIVE FROM Claris Engage 2025 - It's FMTV!" We recorded a series of interviews with Claris Staff and Community Members while at Claris' developer conference in one of the new Apple Studios. These are all now available for you to enjoy: https://fmtraining.tv/engage-2025/ [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Today we like to connect to Postgres Database server from FileMaker using the SQL functions in MBS FileMaker Plugin. For that we need the client libraries for Postgres, but where to get them? macOS For macOS you can download the Postgres App to get a local test server for Postgres on your Mac. You can directly point to the libpq.5.dylib within the application. We adjusted the install names to make them work into the Frameworks folder of your application. The libpq library needs crypto and ssl libraries, so these must be in the same folder. We got the libraries here for you: PostgreSQL Libraries. You can store these for example in the Extensions folder next t…

The Claris Engage 2025 recap continues! In this special interview, we sit down with Claris VP of Product Management, Giuliano Iacobelli, to discuss all of the news from the conference. Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

While Claris Engage 2025 may have ended a couple weeks ago, we have some LiveSteam recordings for you to enjoy! First up is this year's Keynote recap with Richard Carlton and Garrett Debski. Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Join Kevin Frank in this LiveStream recording on JSON and FileMaker custom functions! Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

As we wrap up our Claris FileMaker Beginner Training, you may be looking for some advanced training. Check out this two day event on Advanced Relationships with Nick Hunter for a potential next step. Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

While the MonkeyBread Plugin actually has over 7600 functions to extend your FileMaker solution, Christian Schmitz joined us with a quick list of 25 ways to improve your database! Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

The Claris FileMaker Engage conference is right around the corner! We had Julie Sigrinius, Senior Director at Claris, join us to talk all about Engage 2025. Learn more about Engage: https://content.claris.com/cpl-q2fy25-li-engage-rcc Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Learn how to build a Custom Find Mode in FileMaker to either simplify or enhance your user's experience. Nick Hunter demonstrates how you can accomplish this without the use of scripts! Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Conditional formatting allows you to change a fields formatting based on a specific action. Learn how to leverage this capability in your FileMaker database in this recording with Nick Hunter. Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

You think about going to Claris Engage 2025 in Austin Texas and you wonder what you could do there with a few extra days? Especially if you come over from far away, you may enjoy a few extra days to adjust to the time zone and see the surrounding area. I've been seven times in Texas to various conferences and so I can give you a few ideas on what you could do. If you go to downtown Austin, you can visit the capitol, enjoy a few drinks at the bars in sixth street. At sunset you can see a lot of bats flying out of the Congress Avenue bridge. It's amazing to see. You can visit the cathedral in Austin: West of Austin are …

When you receive an electronic invoice in the formats ZUGFeRD, Factur-X, X-Rechnung or UBL, you may need to visualize the XML file. You can use our DynaPDF functions to extract the XML from the ZUGFeRD invoice. Once you have the XML for one of the formats UBL or Cross Industry Invoice, you may want to convert it to HTML and show it in a web viewer. We leverage the XRechnung Visualization Transformators project from GitHub. This project has a couple of XML stylesheets to convert our invoices to HTML. For this they first convert the UBL or CII XML to an intermediate XML and finally convert that to XML with a second transformation. There is also an alternative ou…

This script utilizes the DynaPDF functions in MBS FileMaker Plugin for FileMaker to add an image into a PDF document. It initializes the DynaPDF library, imports an existing PDF, adds an image to the PDF, and saves the final version. Here’s a step-by-step breakdown of each action in the script. 1. Initializing DynaPDF If [ MBS("DynaPDF.IsInitialized") ≠ 1 ] Perform Script [ Specified: From list ; “InitDynaPDF” ; Parameter: ] End If This section checks if the DynaPDF library is initialized. The function MBS("DynaPDF.IsInitialized") returns 1 if DynaPDF is already initialized. If not, the script calls another script (InitDyn…

Sometimes plugin users wonder why the plugin doesn't see the WebViewer on the layout, so let's check the various cases: 1. Empty WebViewer Just put an empty web viewer on a layout. No URL. Does it exist? When you go to the browse mode, you see the outline drawn, but if you ask the plugin about the web viewer, it can't find it. Until FileMaker loads something into the WebViewer, it doesn't exist as a control with the operation system and the plugin can't see it. 2. Blank WebViewer You can put in the URL "about:blank" and then FileMaker creates the WebViewer right away. If you do something in the script trigger for layout entering, you may need a sh…

You have XSLT 1.0 in FileMaker built-in as well as in our plugin function to use XSLT (XML.ApplyStylesheet). With our Saxon functions you get XSLT 3.0 and you can enjoy all the 2.0 and 3.0 features in your FileMaker solution and Xojo applications. XSLT 2.0 and 3.0 introduce several significant improvements and new features compared to XSLT 1.0. Here are the key benefits of XSLT 2.0 and 3.0 over XSLT 1.0: 1. Support for Sequences (XSLT 2.0 & 3.0) XSLT 1.0: It processes XML documents element by element, and only allows a single value (like a string or a node) as the result of an expression. XSLT 2.0/3.0: It supports sequences, meaning that a…

Claris FileMaker Go is a client for iOS devices but there are some key differences from FileMaker Pro. We highlighted these differences in this recording using a special sample file. Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

In this advanced training, Nick Hunter covered how to use Relationships to master logic outside of FileMaker Pro's schema instead of calculations. Check out this mini-series to elevate your development skills. Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Updated with FileMaker 21.1, Open Quickly allows a user to access FileMaker's Manage Database, Scripts and Layouts via a search. Check out this recording to learn more about Open Quickly and the update. Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

For the 15.1 version of MBS FileMaker Plugin, we made a little change to Text.ReadTextFile to be able to read from /proc directory on Linux. This way you can read various system things. There are hundreds of things you can read there, so let us show you a few useful picks: Memory Information The meminfo entry provides information about memory utilization. This varies for different linux versions, but you should be able to query the text and find the entries you like. Set Variable [ $meminfo ; Value: MBS("Text.ReadTextFile"; "/proc/meminfo") ] The MemTotal is the total memory in the system. MemFree would be the free memory, but on a Linux system free memory…

We'd love to meet you at one of the various FileMaker conferences. Let us show you: The next conference is Claris Engage in two months, the official one from Claris themselves. Stefanie and I are signed up and will be there. If you have questions about the MBS Plugin, please stop us in the hallways and chat with us. We skip the booth this year as we like to enjoy the sessions ourselves and prefer to wander around instead of sitting on the 5th floor. If you like to join, there are still a few tickets available for the early bird pricing. The CodeWave conference for 2025 in Valencia is a great place to meet people from Spain. I visited this conference last y…

Learn how to implement auto-filling addresses using the Google API with Yitzchok Tzvi Fogel in this LiveStream recording! Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

FileMaker has the ability to export to Excel, but what if you want more out of this feature? MonkeyBread is the answer! Watch this recording to find out how MBS can improve Excel exports. Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

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 walk over some of the doors of our advent calendar. We talk about ics files, HotkeyWIA, WindowsOCR, ImageCapture, ContinuityCamera, AVRecorder, Printer, PrintDialog, PagesetupDialog and AppleScript functions. More videos 25 Ways to Improve Your Database Using the FileMaker MonkeyBread Plug-in - Day 3 25 Ways to Improve Your Database Using the FileMaker MonkeyBread …

HOnza joined us, with special guest Karl Jreijiri, to do a performance test on FileMaker with 1000s of virtual instances. Watch this recording to see how they used fmBlaze to perform the test and the results! Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

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 walk over some of the doors of our advent calendar. We talk about CURL, DynaPDF, MapView, SendMail, SharingService, XML, Calendar and UNNotification functions. More videos 25 Ways to Improve Your Database Using the FileMaker MonkeyBread Plug-in - Day 2 15.0 MonkeyBread FileMaker Plug-in Release with Christian Schmitz 25 Ways to Improve Your Database Using the…

In this article we want to introduce you the new functions from the MBS FileMaker Plugin in version 15.0. Saxon A completely new area that we plan to further expand in the next releases is the connection to the Saxon library. Saxon is a widely used and high-performance software library that specializes in the processing and transformation of XML and XSLT data. It enables developers to manipulate data efficiently and convert it into the desired formats. We would now make these functions from the library available to you in FileMaker. We have already included several functions in this release, but there will certainly be more to come in the future. To find out what…

Today is the day! Join us at 1PM Pacific as we start our 60 Day Claris FileMaker Training for Beginner & Intermediate Developers. While the training will be free to watch live, the Recordings will exclusively be available for paid, active subscribers. Register: https://fmtraining.tv/training-60-day.php

You can use various Amazon web services in FileMaker using our CURL functions in MBS FileMaker Plugin. You need to build the URL and her payload and either pass data in the URL or as POST data, depending on the service. You may easily translate an existing sample call on the AWS documentation for the call you like to make and translate that to setting the various options. The special thing for the AWS requests is the signature to properly encode and hash the credentials. For years we have CURL.SetupAWS function to help signing the requests. But since CURL got the AWSSigV4 Option, we can use our CURL.SetOptionAWSSigV4 function to sign the request on the fly. Th…

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 walk over some of the doors of our advent calendar. We talk about installation, DragDrop, DynaPDF, Contacts, web services and archive functions. More videos 25 Ways to Improve Your Database Using the FileMaker MonkeyBread Plug-in - Day 1 Exporting to Excel from FileMaker using MBS 14.5 MonkeyBread FileMaker Plug-in Release Unlocking the Power of PDFs in…

Our new 60 Day Claris FileMaker Training for Beginner and Intermediate Developers starts on January 21st at 1pm Pacific! While the training will be free to watch live, the Recordings will exclusively be available for paid, active subscribers. Register at: https://fmtraining.tv/training-60-day.php

We've heard about Perform Script on Server but what about Perform Script on Client? Kristian Olsen returns to explain how you can forcibly run a script on another client for notifications and much more! Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

With the Claris FileMaker platform, you can build upon your knowledge to continue to improve your solutions. Nick Hunter demonstrates how you can elevate your Custom Formatting with some special techniques. Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Don't let Custom Finds and Filters slow down your performance in FileMaker. Join Nick Hunter to learn how you can optimize performance by doing these custom finds and filters through Relationships instead. Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Christian Schmitz will be wrapping up his “25 Ways to Improve your Database with MBS” miniseries this week. Join him this Thursday (1/16) at 1PM Pacific for Day 3. Register for the LiveStream: https://fmtraining.tv/register.php?eventid=4799568847680493155418979764308192133835687019539627925579 [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com