Community Videos, Tips, & Techniques, Articles.

When managing and optimizing FileMaker databases, understanding the details of your data is crucial. Whether you’re looking to optimize performance, audit data quality, or get insights into database structure, having precise statistical information about your database can be invaluable. The MBS FileMaker Plugin offers powerful functions for querying detailed statistics on fields, records, and entire tables. In this blog post, we’ll explore three key functions — FM.FieldStatistics, FM.RecordStatistics, and FM.TableStatistics — and how to use them to gain deep insights into your FileMaker databases. 1. FM.FieldStatistics: Dive into Field Details The FM.FieldS…

Greetings from the Australian FileMaker conference. It just started and we are happy to meet so many developers from the Asia Pacific area. Lots of attendees from Australia and New Zealand, but also up to Japan or Dubai. And some usual suspects from USA, Canada and Europe, who just like me love to explore the world. In total 110 people came including the Claris representatives. There will be a short MBS Presentation to highlight a few new things in the plugin. Learn what is new in MBS Plugins this year. If anyone needs a license, you can place an order in our MyCommerce web shop via our pricing page and use coupon code FileMakerConference for a 20% discount on …

Interested in the Claris FileMaker platform but still on the fence? Join us as we discuses why this is "the ultimate tool for building the custom operational apps that teams rely on". Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Join Robert Holsey, the Product Manager of Claris Studio, on Friday at 1PM Pacific, as he dives into the latest improvements to Claris Studio! Register for the LiveStream: https://fmtraining.tv/register.php?eventid=150611565253544396124226612616494237178858579423459849544 [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Recently clients asked to get a quick way to insert records with JSON data. As soon as that was done, the next one asked for updating and then of course for our insert and update. We had these functions for years: FM.InsertRecord FM.InsertOrUpdateRecord FM.InsertOrUpdateRecord2 FM.InsertOrUpdateRecord3 FM.InsertOrUpdateRecord4 FM.InsertOrUpdateRecord5 FM.UpdateRecord FM.UpdateRecord2 FM.UpdateRecord3 FM.UpdateRecords FM.UpdateRecords2 FM.UpdateRecords3 FM.DeleteRecord FM.DeleteRecords And all these functions are very handy, but how about passing parameters as JSON? …

When you’re bulk uploading photos, it’s easy to accidentally upload the same photo twice. Learn how to detect and delete duplicate images in FileMaker! Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

You've told yourself you'll upgrade your FileMaker Pro version "next year", year after year after year, and now it is extremely out of date. Not to worry, Richard is here to show you how to rescue your file, if possible! Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

FileMaker WebDirect allows a user to access a FileMaker solution via a web browser, but as a developer - how do you build a solution that will perform well in a web browser? Join Nick Hunter in this multi-day webinar on everything WebDirect. Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Learn how to use dynamic portal sorting via an add-on this Friday at 1PM Pacific with Kristian Olsen! Kristian will be covering the add-on pack, WolfPack. Register for the LiveStream: https://fmtraining.tv/register.php?eventid=3468161029954177139214133331073087562813347986518513924653 [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Have questions about the MonkeyBread Plug-in? Join Christian Schmitz this Thursday at 1PM Pacific for an open Q&A! Register for the LiveStream: https://fmtraining.tv/register.php?eventid=4095341560389751366554074874639452802593101144492328815374 [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

FileMaker relationships seem to be a friction point for a lot of beginner developers. Not to worry, Richard is here to discuss troubleshooting your FileMaker relationships! Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Some may have decided to wait this long before updating their FileMaker Server to the latest Claris FileMaker 21 release. If so, this FMS Q&A with Jacob Taylor may address any last concerns you may have. Future LiveStreams:https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Importing and updating massive amounts of data can seem daunting and time consuming but that doesn't have to be the case. In this 6-day webinar, Nick Hunter shows how to speed up your import from weeks to hours! Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

The Product Manager of Claris Connect, Edward Lee, is here to talk about what Claris Connect is, and what it can do for you. Don’t miss out this Thursday at 1PM Pacific! Register for the LiveStream: https://fmtraining.tv/register.php?eventid=4445754262715125500879314321450777203470617475082130413739 [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

We often recommend developers NOT use validation field options but what are the alternatives? Nick Hunter is here with a 3-day webinar on better methods for validating without the validation tab in FileMaker. Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Christian Schmitz joins us to talk about his MonkeyBread Plug-in with over 7300 functions! Learn how you can extend your Claris FileMaker solution in some amazing ways. Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

The Execute FileMaker Data API can now be used to create and delete records as of FileMaker 2024. Check out this LiveStream recording with Calvin Mosiman to learn more! Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

On Friday at 1PM Pacific, Rosemary Tietge will join us to discuss what Claris thinks is the best practices to upgrading your (or your clients) version of FileMaker. Register for the LiveStream: https://fmtraining.tv/register.php?eventid=4222249202656233929157081946400525804427170282253992235855 [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Want to learn more about hosting options for your Claris FileMaker database? Join Sangita Banerjee, the Claris FileMaker Cloud project manager, this Thursday at 1PM Pacific for a FileMaker Cloud overview! Register for the LiveStream: https://fmtraining.tv/register.php?eventid=2296863661155176511332513136544890631685856346374599611316 [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Did you know that in Release 14.3 we have added the option in the Quicklist area to output the Quicklist entries as a JSON text array? You can simply use the QuickList.JSONArray function to do this. Today I would like to introduce you to this function in comparison to a function that was added last year: QuickList.JoinJSON. Quicklist entries as JSON array Let's take a look at an example where we want to write entries in a quicklist and have them returned later as a JSON array. First we create a quicklist and enter a few entries there. We can then extend this list as needed afterwards, as we do with blackberry, for example. Finally, we want to get this quicklist …

"Global field values are global to the FileMaker user, not to the database file." If this statement is confusing to you, join Nick Hunter as he walks through Global Fields and how to use them cleverly. Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Today I would like to introduce you to a really cool function from the latest release of the MBS FileMaker Plugin. It's about the DragDrop.AttachToOverlay function. This function combines 2 areas from our plugin. The possibilities of drag and drop and our overlay windows. We introduced our overlays for the first time at the beginning of this year. These are areas that you can create on the screen, give them a background, which you can move freely as you wish and which you can use with several mouse events, such as click, enter or exit. At the beginning of the year, we published the blog article Overlay windows for FileMaker. The second part we want to talk about tod…

In this 2-day Custom Publishing Mail livestream series, Nick Hunter will be demonstrating his latest techniques for using Publishing Mail with brand new Layout Calculations! Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Kyle Williams is back with a new demo file that allows you to leverage the power of the web viewer! Learn how to create dynamic tab controls that provide new capabilities not previously possible in FileMaker. Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Join Andy LeCates from Claris this Friday at 1PM Pacific as he goes over the latest release of FileMaker Pro, 21.0.2. This release is full of bug fixes and we’ll be there to discuss and answer your questions! Register for the LiveStream: https://fmtraining.tv/register.php?eventid=2197839630568639503779859077666293393756675132093062298033 [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Claus Lavendt returns to our LIveStream this Thursday at 1PM Pacific! Don’t miss out on learning all about the free Missing Admin Tool for FileMaker Server. Register for the LiveStream: https://fmtraining.tv/register.php?eventid=858036021690279360514532505712411851522004286480452095905 [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

FileMaker allows you to take the skills you learn as a beginner and build upon them as you progress as a developer. Hidden objects are a great example of this! Join Nick Hunter as he demonstrates their use without complex scripts! Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Portals can open a world of connections in your Claris FileMaker database but what if you want to show data from two relationships away? Join us this Friday at 1 PM Pacific to learn more about Multi-Hop Portals! Register for this LiveStream: https://fmtraining.tv/register.php?eventid=430191602848357869404161515800889716449799881665119050363 [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Do you have ideas on optimizing the way your team works but don’t have a way to make it happen? Join us this Thursday at 1PM Pacific as we discuss why Claris FileMaker could meet all your needs! Register for this LiveStream: https://fmtraining.tv/register.php?eventid=2215934685624723237089956338601111702986870553397197049205 [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

A Bill of Materials (BOMs) is a list of raw materials needed to manufacture an end product and an integral part of some businesses. Check out this mini-series to learn how to create your own indented invoices! Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Struggling with Pop-up menus because of complicated relationships? Join Nick Hunter as he demonstrates a Data Picker! This "context free" technique may be the solution you're looking for. Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Calvin Mosiman is back and he is here to discuss pivot tables! Join us as we take apart a Pivot Table sample and break down everything you need to know about pivot tables. Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Do you have a FileMaker file in an old format from several years back? Join us Thursday at 1 PM Pacific to find out how to upgrade to the latest format and the problems you may run into. Register for the LiveStream: https://fmtraining.tv/register.php?eventid=3164990675642915004704501516907104608154409287223035579414 [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Today at 1 PM Pacific time is the first day of Nick Hunter’s brand new LiveStream series on FileMaker WebDirect! We will run through all aspects of building a solution which will perform great on WebDirect and much more. Register for the LiveStream: https://fmtraining.tv/register.php?eventid=5432926701084195961000550691684000436338429737331476983243 [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Introduction to ZeroTier: build modern, secure, multi-point virtualized networks of almost any type. Jacob and Richard are here to talk about how they use it in their day-to-day business. Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Christian Schmitz returns with the Claris FileMaker Monkeybread Plug-in 14.2 release. Learn about all the new functions and capabilities you could implement to your FileMaker database! Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

In this article Stefanie introduces you to the new functions from the MBS FileMaker Plugin in version 14.3. Python I would like to introduce you to the highlight of this release right at the beginning. You can now use Python in your projects with the help of the MBS FileMaker Plugin. This programming language, which appeared in the 90s, is one of the most popular of its kind and is used by many developers. We are therefore pleased to be able to open up this world to you in this release. Use our Python functions to load a local Python library and evaluate expressions or run scripts. Get and set variables in Python to exchange data in memory. The Python code can op…

Caution, oversized load ahead! Join Richard as he demonstrates how to move Claris FileMaker data in bulk using the Data Migration Tool. Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Is your FileMaker performance suffering because you have a spider-web Relationship Diagram? Richard is here to discuss how to untangle your relationship graph into an anchor-buoy design! Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Users get distracted and records get abandoned. Join Richard as he discusses how to save your user's "forward progress". Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

A common problem clients have is to install the right plugin file on Linux. It seems to confuse some clients which Linux variant they have and then the plug-in won't load. Plugin location The MBS Plugin on a server goes into three folders: FileMaker Server/Database Server/Extensions FileMaker Server/Web Publishing/publishing-engine/cwpc/Plugins/ FileMaker Server/Web Publishing/publishing-engine/wip/Plugins/ First is for server side scripts, second for WebDirect and third for Data API. Once you put the plugin into the folders, check admim-console to activate plugins for all three and for server scripting activate MBS plugin. If the plugin doesn't show there…

Nick Hunter is here to explain how you can use data filters with relationships instead of finds. Learn how this technique allows you to filter records AND portals! Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

When you like to position something in a window in FileMaker Pro, you may wonder what toolbars are visible to the user. The user may have the normal toolbar and below and for some toolbars you an ask the state, but not for the formatting bar. You can ask FileMaker with Get(AllowFormattingBarState) whether the formatting bar is allowed to show. And using the Allow Formatting Bar script step you can turn it on or off. But beside just turning it on or off to make sure you know the state, we could help with a function to know the state. Our first try was to check the checkbox for the menu entry. While the plugin can check the checkbox state with Me…

If your user needs to compress one file and send it via email, they can compress the file in Finder or Explorer and attach the file to an email and send it off. But what if you ned to do this 100 times and you need a script to do this? Send XML File as Zip Let's start with a XML (or JSON) export from FileMaker which you like to email with MBS FileMaker Plugin. You could just add the XML directly as an attachment with SendMail.AddAttachmentText function and call the job done: Set Variable [ $r ; Value: MBS( "SendMail.AddAttachmentText"; $email; $XML; "UTF-8"; "export.xml"; "application/xml") ] But let's use our new Archive.CompressText functio…

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 talk about error handling with ClearErrors and ErrorLog, HadErrors, AddToErrorLog, Text.TextToHTML and DynaPDF.CreateTextField functions. More videos The FileMaker MonkeyBread Plug-in Q&A Exporting FileMaker Settings into Excel Files using the MonkeyBread Plug-in The Claris FileMaker MonkeyBread Plug-in 14.2 Release FileMaker MonkeyBread Plug-in Pre…

You've discovered how incredibly useful the Claris FileMaker platform can be but now you're asking yourself, "How Do I Buy Claris FileMaker?" Check out this LiveStream where we break down the licensing. Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

We got trial keys about 6 years ago added to our FileMaker and Xojo plugins. A trial key is only valid for a limit time and allows to test all features without demo limitations. Due to the time limitation of the key, you can use it for a few weeks. The key later expires and you are back to demo mode or you order a license to get a permanent license. We setup a form to request a license key: Request Trial License Key We may limit who can get a trial and filter out the requests looking like spam. But so far we issued over 1800 trial keys to various people. Please understand that trial keys are not intended for deployment of solutions as keys expire. Our regula…

The Substitute function, "Returns a text string with every occurrence of searchString in specified text replaced by replaceString.", but what does this mean? Nick Hunter is here to further explain how it works!! Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

There are six conferences left for FileMaker this year and still time for you to sign-up to one and enjoy meeting your fellow developers. Meet Claris staff and us to ask your questions, bring ideas and show what you do with FileMaker. Reconnect.fm 5th to 6th September 2024 in Brisbane, Australia With over 150 attendees this is the biggest conference for FileMaker in Australia and the whole southern Asian area. Meet Claris staff including Clay Maeckel (Software Architect) and (VP Global Sales) to calc about what's under hood and whatever sales and licensing questions you have. Your chance to visit Australia and meet the locals! MBS is sponsor…

There is a little thing we can easily do in FileMaker when creating new records. We can get the ID of the new record. But if we insert via SQL, we can't get it. Usually we workaround by using UUIDs and then put in a new UUID for the record into the insert command. This way we know in advance which ID the new record will have. Now in PostgreSQL you can use INSERT command with RETURNING option to return the new record ID. As we can use our SQL functions to connect to PostgreSQL databases, we can use that feature here. We skip the connection part and directly create an INSERT command to create a new record in table Persons. We pass values …

What happens when you need a record from an unrelated table and you can’t make the relationship? Richard is here to discuss the art of Table Occurrence Group (TOG) hopping! Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Recently a client asked about whether we can do MQTT inside FileMaker to subscribe to a topic and receive messages or even send messages. Let's summarize what MQTT is for you: MQTT (Message Queuing Telemetry Transport) is a lightweight messaging protocol designed for devices with limited resources and for low-bandwidth, high-latency, or unreliable networks. It operates on a publish/subscribe model which allows for efficient distribution of information to many receivers. We discovered that we have MQTT capabilities built-in to the CURL library. Just use an URL with "mqtt://" followed by IP or domain name of the server. In the path of the URL goes th…

Back to basics! Richard is here to cover Anchor buoy and FileMaker relationships for beginners, step by step, with a fresh file. Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

For MBS FileMaker Plugin 14.3 we add the possibility to evaluate Python code in FileMaker and run scripts. This enables you to integrate existing Python code and use it in FileMaker. That may be a quick calculation to calculate a checksum, process some text, JSON or XML data or to utilize an existing script by running it within FileMaker. Python comes with hundreds of available modules that you can import and use. Initialization Depending on the platform, you install Python libraries in different ways. For macOS you can use Homebrew command line tools to install the python package. For Windows you can download the official Python installer and run …

In the last days we had a discussion with a client about FileMaker 2024 and the quick open feature. The user may press Command-K (macOS) or Control-K (Windows) and search for things. This includes layouts and scripts and they can go to layouts and run scripts, when you wouldn't expect it. We love to give everyone a reminder on a little security thing: Any script in FileMaker may get called anywhere by anyone. When you write a script, you usually make assumptions. The script expects to be in a certain layout on a specific record to do its job. You expect it to be called because a user pressed a specific button or used the custom menu to only call i…

There are new JSON functions with the FileMaker 2024 release: JSONMakeArray and GetLiveTextAsJSON! Corn Walker is here to discuss what these functions are, and how these improvements help. Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

In FileMaker Pro 21, the Revert Transaction script step is now supported in sub-scripts. Corn Walker is here to break down the impact that this change will have on your transaction scripts. Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Recently a client asked how to show 3D models in FileMaker on Windows. We looked for various solutions and on the end came to using JavaScript viewer for 3D objects: js-3d-model-viewer. To show a file, you would export it to a temporary folder with FileMaker. You put the JavaScript file into the same folder and have your script export also the html file there. The HTML file needs to reference the model file by name. Although you could just name the model file the same each time and just use the same html. To access local files in the same folder, you need to overcome Cross-origin resource sharing (CORS) rules. Basically all files must be hosted on the same…

One of the big billets for FileMaker 2024 (a.k.a. FileMaker 21.0.1) is that FileMaker now interacts with AI. Vince Menanno and Will Miro are back for a second day to explain more new AI features! Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

We recorded the MBS Plugin talk at the dotfmp 2024 FileMaker conference in Berlin: We talk about SystemInfo.MacMemoryHostStatistics function CURL functions for MQTT Python functions to evaluate and run Python code within FileMaker Shell functions to ping a server Using GraphicsMagick functions for drawing progress bars WebViewer functions to print HTML as PDF file DynaPDF functions to layout books automatically in scripts Show XL functions to create conditional formatting in Excel files. Matrix functions for CSV handling Data detector on macOS to identify data in text Search scripts for Windo…

Recently at the dotfmp conference, we talked about storing text vectors for LLMs in FileMaker as container instead of text to save space. But does it? Let's check with current FileMaker Pro. We can store text in a FileMaker database. The size to store the record is a bit more than the text. Our test table has primary key, two time stamps and the account name for creation and modification. With the overhead for managing the blocks this takes about 270 bytes per record in our test database. If you store the text in a container field, you basically get the text stored and there is a 12 byte overhead for the container, if you just write text there. Set Field [ …

AI integration with the Claris FileMaker platform is here with the 2024 release! Join Vince Menanno and Will Miro as they dive into AI Semantic Search at a beginners level. Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Hundreds of bug fixes are yet another amazing component of the Claris FileMaker 2024 release. Join Richard and Jacob as they highlight some of the major bugs that were fixed. Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Buried deep in the release notes for FileMaker Pro 2024 (a.k.a. version 21.0.1) is a dramatic announcement: the Xalan XSLT processor has been replaced with libsxlt. Although both processors conform to the XSLT 1.0 specification (more on this later), they do differ in several aspects. This could have an impact on your existing stylesheets: Extension functions If you have been relying on extension functions in the Xalan namespace, you will need to replace those with their EXSLT equivalents in their corresponding namespace: xalan:nodeset ==> exsl:node-set (xmlns:exsl="http://exslt.org/common") xalan:distinct ==> set:distinct (xmlns:set="http://exsl…

I presented on FileMaker Semantic Search at dotfmp in Berlin on June 6 a couple of days after the release of the new FileMaker 2024. I've revised my slide deck to be the first in a series of articles going into detail on how to implement the new features. If nothing else, I'll show you how to double the native embedding performance! https://medium.com/transforming-digital/a-deep-dive-into-filemaker-2024s-new-semantic-search-functionality-e24b2ed24ffd

You may know that FileMaker has variables within Let(), $ variables in a script and $$ variables as per file globals. But MBS FileMaker Plugin provides higher levels. Our plugin based variables (see FM.VariableSet) stay in the process space of the current loaded plugin. But there is also shared memory to store something per computer, independent of the current application. On a FileMaker Server you can have three times the plugin installed and also on each web direct worker. You may run one or more FileMaker Pro copy on a machine and each has plugin managed variables for itself. But they can also access the shared memory (see SharedMemory.SetValue) on the same …

Join Wim Decorte of Soliant and Jacob Taylor of RCC for a demonstration and discussion of Claris FileMaker Server 2024's brand new support for Lets Encrypt SSL. 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 talk about XL functions in MBS FileMaker Plugin to do custom exports. More videos Exporting FileMaker Settings into Excel Files using the MonkeyBread Plug-in The Claris FileMaker MonkeyBread Plug-in 14.2 Release FileMaker MonkeyBread Plug-in Presentation with Christian Schmitz Scanning in FileMaker with the MonkeyBread Plug-in Printing in FileMake…

With the new Claris FileMaker 2024 launch, there are new FileMaker Server improvements. Douglas Wallis and Connor Brock from Claris are here to discuss what new features you can expect. Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

FileMaker 2024 (a.k.a. FileMaker 21.0.1) has launched! With the new version of the Claris FileMaker platform comes a host of new features and improvements. Rick Kalman and Douglas Wallis are here from Claris Inc. to talk about this exciting new product launch! Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

The Claris FileMaker 2024 release is here and we have a great line up of resources for you! NINE amazing streams with different guests from the FileMaker community, including staff from Claris! Click here to view the schedule and register for each LiveStream: https://fmtraining.tv/#LIVE Want to know the Top 10 Things to know about this release? We have that too, check out this video: https://youtu.be/iqQ2P9qYoqk Read more about the release directly on Claris’ site here: https://bit.ly/CFM2024_rcc Lastly, if you would like to jump directly to a trial of the new version: https://bit.ly/CFM2024trial_rcc

View File SECURITY CHANGES AND ENHANCEMENTS IN FILEMAKER® PRO 21 Security Changes And Enhancements In FileMaker® Pro 21 By: Wim Decorte and Steven H. Blackwell The recently released FileMaker® Pro 21 new version continues the efforts of Claris/FMI and several members of the FileMaker Developer Community to enhance and improve the Security features in the products. In this White Paper Wim Decorte and I will discuss much of the Security information relevant to this new release as well as some aspects of other recent patches issued by Claris. Much of the specific discussion in the White Paper focus…

Scanning documents into your Claris FileMaker database may be an important step in your digital document management. Join Christian Schmitz as he breaks down how the MonkeyBread Plug-in can help with scanning. Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Applying what you've learned about the Claris FileMaker platform to individual customer situations is a skill set of its own. Join us as we discuss how to apply your technical knowledge to a customer problem. Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Improving the performance of individual parts of your Claris FileMaker database can improve the performance of the whole. Join us as we discuss performance speed when it comes to Summary fields. Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Your server is on fire! What do you do when you have to restore a backup after an emergency with your Claris FileMaker Server? Join Jacob Taylor as he preps you for any Claris FileMaker Server emergency restoration. Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

You've got mail! E-mail has become such an integrated part of most businesses and can provide so much value to your FileMaker database. Join HOnza as he breaks down how e-mail works. Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Christian Schmitz is back with another useful feature of the Monkeybread Plug-in, printing! Check out this LiveStream to learn how to take control of printing in the Claris FileMaker platform! Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Pop quiz! If a script calls another script, what is automatically "passed on" to the subscript? Check out this LiveStream on script inheritance in the Claris FileMaker platform to find out the answer! Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Calvin Mosiman is back to discuss how to use Perform Script on Server (PSOS) to render your PDFs in the Claris FileMaker platform! Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Since we all love to make clones for using the data migration tool, we like to pass through some data with the clone. But a clone can't have records! If we like to pass data in the clone like a version number, we need to carry it inside the schema. This happens by putting the text into the default value of a field. Like having a special table for global settings and there a version field with the version number as default value. Add field with default You can modify the schema on FileMaker Pro, if it is not busy. So we usually do it on idle time with our FM.ExecuteFileSQLOnIdlefunction and run it in a script pause. The SQL command uses ALTER co…

Did you hear the great news? The beta for FM Starting Point Lite 2024 is now available FREE for download! Check out this LiveStream to learn more about this latest release. Download the beta for FMSP Lite: https://bit.ly/FMSP_Lite_2024. [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 go through the resent MBS Presentation from the last conference and discuss the individual features. More videos FileMaker MonkeyBread Plug-in Presentation with Christian Schmitz Scanning in FileMaker with the MonkeyBread Plug-in Printing in FileMaker with the MonkeyBread Plug-in The FileMaker Monkeybread Plug-in 14.1 with Christian Schmitz Web Sc…

Just when you thought relationships in the Claris FileMaker platform couldn't get more complicated, you find out about many-to-many relationships! Not to worry, we're here to show how these can be a great tool. Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

For a lot of Claris FileMaker beginners, relationships seem to be one of the harder things to master. Join us as we break down the basics of relationships. Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Since we got JSON.Replace function to search and replace values in JSON, we got requests to decide in code what and how to replace. For the upcoming 14.2 release we offer you a JSON.ReplaceEvaluate function where you can pass an expression to run within the replace to decide what to do. Let's make a very easy example: MBS( "JSON.ReplaceEvaluate"; "[1,2]"; "$[*]"; " MBS(\"JSON.CurrentMatch\") + 1" ) Input is a JSON array with two values: [1, 2] and output is an array with values [2, 3]. The search expression finds each entry in the array and in the expression we query the current JSON value and adds one. You use JSON.CurrentMatch function to ge…

Check out the FileMaker Magazine website. Matt Petrowsky provides a huge collection of training videos around FileMaker. And recently he started a series of videos about our MBS Plugin: Watch it on filemakermagazine.com and subscribe to his YouTube channel. Matt shows what cool things he built with our Matrix functions to work on tab separated data from clipboard. More videos from Matt about MBS Plugin in this playlist: ISO FileMaker Magazine: MBS JavaScript Power ISO FileMaker Magazine: FileMaker Maps - Using MapKit & MBS ISO FileMaker Magazine: MonkeyBread Plug-In for Claris/FileMaker - Part 3 ISO FileMaker Magaz…

Jonathan Ray is back with another secret on improving your Claris FileMaker database's performance and it's a good one! Join us to learn how conditional formatting and portal filters could be hurting your speed. Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

In case you missed it, we split our FM Forums Open Q&A into different videos so you can find what you need easier! In this Part 1, we talk about user specific permissions on a Claris FileMaker Server level. Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Welcome to Day 1 of Claris FileMaker Audit Logs with Calvin! Join us to learn how to construct and read audit logs so you can keep track of what happens inside of your database. 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 talk about scanning: Use WIA functions on Windows to connect to scanners. Use ImageCapture functions on macOS to connect to scanners. Use DocumentCameraScan functions on iOS to get a document scanned using the iPhone camera (needs Filemaker iOS SDK app). Use ContinuityCamera functions to take a picture with the iPhone and receive it in FileMaker Pro on your Mac. …

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 talk about what printing functions we have in MBS FileMaker Plugin: PrintDialog functions for macOS, Printer.SetPrinter and Printer.Print functions for Windows, PDFKit.Print, PDFKit.SelectPrinter and PDFKit.SetPrintSetting functions for iOS. You may print on iOS without print dialog to print a receipt in a POS software. And even on server you can print a PDF directly to a nearby printer in…

Live data vs Lookups, who would win? Find out as we discuss when to use which and their roles in Claris FileMaker's relationships. Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

I am trying to use the TimeOn Weddirect to show the users when the next script is going to run and download data from the server, it seems to work fine from the client but not from WebDirect? is the install timerOn supported On WebDirect?

Join Richard as he goes through FM Forums, answering questions and concerns by Claris FileMaker developers at a variety of skill levels! Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Setting up a Preference table can make a huge difference if your Claris FileMaker database is going to have more than one user. Join us as we talk about everything you need to know about Preference tables! Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Party time! Join HOnza Koudelka as he demonstrates how to make a TV show styled party game with custom-made bluetooth buttons with Claris FileMaker. Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Dave Ramsey joins us to talk about Proof+Geist’s FMPerception, FMComparison and FMLayoutLens! Learn how they can help you develop, deploy, and maintain your Claris FileMaker solutions. Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Join us for everything Dynamic Window Management in Claris FileMaker. From Card Style windows and Sliding Panels to Custom Dialogues and much more! Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

If you use FileMaker iOS SDK, we can provide a few new print commands for iOS in the MBS FileMaker Plugin in version 14.2. The new PDFKit.SelectPrinter function allows you to pick a printer. And the PDFKit.Print function got extended to print PDF documents as well as images. You can configure printing with PDFKit.SetPrintSetting function. Let's start with selecting a printer: If [ Length ( PDFKit Print::PrinterURL ) > 0 ] Set Variable [ $r ; Value: MBS( "PDFKit.SetPrintSetting"; "PrinterURL"; PDFKit Print::PrinterURL ) ] End If # show the dialog Set Variable [ $userDidSelect ; Value: MBS( "PDFKit.SelectPrinter" ) ] If…