Community Videos, Tips, & Techniques, Articles.

Updates for the MonkeyBread Plug-in are here! Join us as we go over all the fantastic new changes to one of your favorite FileMaker Plug-ins. Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Join Jacob Taylor as he answers questions from viewers on Claris FileMaker Server, Claris FileMaker Cloud and security! Have your own questions? Keep an eye out for future Open Q&As LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Welcome to the HOnza Calculation Magic Show! Without any pre-defined images or webviewers up his sleeves, HOnza manages to create PNG images - including barcodes! Future LiveStreams: https://fmtraining.tv/#LIVE [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 13.4. Phidget Let's start with the most comprehensive and coolest new feature of the release: Phidgets. Phidgets are small additional devices that you can connect to your computer and with which you can then input or output data. For example you can connect a small motor, a temperature sensor, a humidity sensor, a gyroscope or a small LED display and exchange data with these devices. Since a few years we already have a plugin for Xojo, which allows the interaction with these small devices and we are proud to offer the use of these small devices now also for FileMak…

For Nick Hunter's latest webinar, we dive into implementing web scraping into your FileMaker database without using the webviewer. More specifically, these processes are performed on FileMaker Server! Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Add more color to your FileMaker solutions with a color picker! Chris Johnston is here to explain how to accomplish this using a webviewer. Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Jonathan Ray is back with an amazing bulk record deletion technique. Not only will this save you time, it'll give you confidence to safely delete records in bulk! Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

ALERT: Twilio updated their requirements for businesses using their service to send marketing and transactional text messages. Jacob Taylor joins us to go over those changes, and what you need to do to comply. Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Do you believe in Calculation Magic? Join HOnza as he manipulates PDF documents with FileMaker with no plug-ins and no external devices! Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Nick Hunter is back with a new series of videos on ChatGPT and FileMaker! Watch this multi-day series to learn how you can incorporate this AI into your FileMaker solution. Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Recently a client asked me where all the MBS functions are. Looking in the calculation dialog, you see just MBS listed: If you ask why we don't have over 7000 functions listed there, the answer is easy: It would be a nightmare for you to use. Recently I made a special version of MBS Plugin to register all functions individually and show them in the calculation dialog right away: You don't see the scrollbar on the screenshot, but all 7000 functions are there. The dialog takes about 12 seconds to open as FileMaker adds all the functions to the list. And it takes another 10 seconds to open the MBS section there. There is a significant time cost for having a lot …

Jonathan Ray joins us to discuss a technique that allows you to create multiple records at one time. Learn about this incredible time saving "Shopping Cart" method and add it to your developer tool belt! Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Submitting information to your FileMaker database via PDF is another great function that the MonkeyBread Plug-in offers. We'll be covering all the unique options that MBS offers when it comes to PDF forms! Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Having issues with your FileMaker Server? The MonkeyBread Plug-in can provide a debugging solution! Use MBS to log intermediate results in your scripts along with the MBS Trace feature. Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Join Richard in this beginner and intermediate open Q&A as he discuses topics such as minimal audit logs, capturing photos on iOS using FileMaker Go and more! Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

For 13.4 release, we'll update the WebDownloadDelegate functions in MBS FileMaker Plugin to work again with web viewers using WebKit 2 (since FileMaker 16). Once again you can control downloads in FileMaker's web viewer on macOS and iOS. When a download starts, you get a script triggered to inform you about the progress. Then we have script triggers for download finished or failed and to update on progress. The download can be stored in a specific folder with WebDownloadDelegate.SetFolder, but if you don't set it, we will just use a temporary folder. And we create a folder with random GUID as name to make sure the file can be stored on disk without a name …

Jesse Barnum is back with another exciting 360Works Plug-in, Zulu. Learn how to turn any FileMaker Server into a shared calendar server. Zulu will sync FileMaker to iOS, OS X, Google Calendar and Exchange/Office 365! Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Join Jesse Barnum from 360Works as he dives into 360Deploy. Learn how you can deploy your development environment onto a production server while keeping data intact! 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 the new MBS FileMaker Plugin 13.3 release: Announcement, release notes, new functions and download FileMaker Monkeybread Plug-in Update 13.3 PDF Forms with Submit button for Adobe Reader using the FileMaker MonkeyBread Plug-in Debugging your FileMaker Servers with the MonkeyBread Plug-in Digital Document Super Glue in FileMaker What’s New in…

You may find it convenient sometimes to create or update records in a different table without switching layouts. If you do this in a script, you would usually cause a layout change, to fill the fields from the other table on a different layout. However, such a layout change is not really necessary and costs time. Wouldn't it be easier to create a record with only one script line? Without any relationship, portal and layout change? FM.InsertRecord We have the FM.InsertRecord, FM.UpdateRecord and FM.DeleteRecord and related functions in MBS FileMaker Plugin to help you. The FM.InsertRecord function inserts a new record in any table of any database. Relationsh…

Join Richard Carlton and Christian Schmitz as they use the MonkeyBread Plug-in to demo a real world example of combining digital documents together! Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Join Richard as he deploys SendGrid, Twilio's SMTP service, to a real customer. He also explores the Sender Policy Framework to prevent your emails from ending up in Spam folders! Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Want to sync your databases without a network connection? MirrorSync from 360Works is the answer! Jesse Barnum returns to discuss updates to the MirrorSync product. Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

In this Open Q&A LiveStream, Leland answers some FileMaker-related JSON and JavaScript questions. Have questions of your own? Join us in our next Open Q&A! Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Richard and Jacob are back to discuss bug fixes and updates to FileMaker 20.1.2! They also answer open questions on the Claris FileMaker platform, including FileMaker Server. Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Data URLs, URLs prefixed with the data: scheme, allow small files to be embedded inline in documents. Leland is here to show how you can do this in FileMaker using the Web Viewer. Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

In this article today I will show you 5 tips and tricks with MBS that can make your life easier. I wish you a lot of fun with it. Open files from container with the click of a button Did you know that with the MBS FileMaker Plugin you can open files directly by script function? This is possible with the function Files.LaunchFile. In the parameters we specify the path to the file that should be opened. Set Variable [ $r ; Value: MBS("Files.LaunchFile"; "/Users/sj/Desktop/abc.png") If you want to open a file from a container, you first have to take a small indirect route, e.g. we store the files in the temporary folder. For this we first use the function Fo…

Richard is back with some new triggers to add to your tool box! This LiveStream discusses triggers for beginning and intermediate developers to be used when database users become idle. Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Practice your JavaScript skills with a latency indicator. Leland gives an intro to JS charting and how to add moving gauges to your FileMaker solution! Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Interested in transient notifications for your database but don't know where to start? Join Richard Carlton as he breaks down this topic on a beginner and intermediate level! Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

You can set optional flags affecting the graphics state, coordinate handling, as well as color and image conversion rules in DynaPDF. MBS( "DynaPDF.SetGStateFlags"; PDF; Value { ; Reset } ) If the parameter Reset is true, the new flags replace current flags. If set to false, the flags are combined with the current flags. Let's check the possible flags to use: RestorePageCoords If set, the current base coordinate system like bottom or top down is saved and restored with the graphics state. This affects calls to DynaPDF.SaveGraphicState and DynaPDF.RestoreGraphicState calls. If not set, this will restore to Bottom-Up coordinates. The DynaPDF.SetPageCoords fun…

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 adding a submit button to a PDF document with DynaPDF functions in MBS FileMaker Plugin to send the PDF file to our server. PDF Forms with Submit button for Adobe Reader using the FileMaker MonkeyBread Plug-in Debugging your FileMaker Servers with the MonkeyBread Plug-in Digital Document Super Glue in FileMaker What’s New in the FileMaker MonkeyBr…

Our series on JSON and JavaScript continues with two add-ons! Join Leland as he breaks down JsonArraySort & JsonDiff. Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.T www.FMStartingPoint.com www.rcconsulting.com

Deploying FileMaker to customers onsite offers its own set of challenges. Join Richard as he discusses the steps you can take to overcome these challenges as well as examples of his own recent onsite deployments. Future LiveStreams: https://fmtraining.tv/#LIVE [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 13.3. PDF Preview With the new version of the plugin we have also added a new component that I would like to introduce to you today. With the Preview component you get a control for macOS and Windows that gives you a PDF preview in the layout. Since the plugin puts the control on the layout, it is independent of FileMaker, it can stay when switching records and can load data from a container field or from a file on disk. First you can use Preview.Available to check if the functions are available for your operating system. With the functions Preview.Create or Previe…

PostMan can be a useful tool for exploring and trying out API's outside of FileMaker. Join Leland in this LiveStream to find out how it works, including a couple examples from ChatGPT's API functionality! 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 debugging with the MBS FileMaker Plugin with Trace and Log function to find issues in your scripts, especially on server side. Debugging your FileMaker Servers with the MonkeyBread Plug-in Digital Document Super Glue in FileMaker What’s New in the FileMaker MonkeyBread Plug-in - 13.2 Release The FileMaker MonkeyBread Plug-in Spotlight: OCR T…

A recording of our short presentation for Reconnect.Sydney to talk about what is new in 2023 for MBS Plugin for Claris FileMaker. All movies Watch on YouTube. MBS-Sydney-2023.mp4

Christian Schmitz has released a new 13.2 version of the MonkeyBread plug-in in the wake of FileMaker 2023. Watch this LiveStream to learn about all the awesome new functions! Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

What is cURL and how can we leverage it with FileMaker? This livestream explores cURL options that FileMaker allows us to use in the InsertFromURL script step. Future LiveStreams: https://fmtraining.tv/#LIVE [email protected] www.FMTraining.TV www.FMStartingPoint.com www.rcconsulting.com

Need to extract text from an image? Let Christian Schmitz show you three different ways to get text from a picture with the MonkeyBread Plug-in. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Continuing our JSON 101 series we tackle Execute DAPI. Using this script step we can query our database and get back JSON data. Let's explore our JSON options for creating the query and parsing the results. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

When you run into trouble and you contact us via support@ email address, we may frequently question you to provide: The text of your script. But, please no screenshot. You can copy the script text into an email or print to PDF. The log of plugin calls from Trace function, so we see what you call and what parameters you actually pass. If CURL functions are involved, the CURL debug messages via CURL.GetDebugMessages function. We frequently ask to reproduce the problem in a new database or with a short script. It's hard to dig through 1000 lines of script to come to the 10 lines where the problem shows and make sure none of the lines above cause…

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 is new in the MBS FileMaker Plugin in version 13.2. We talk about merging documents with DynaPDF including PDF documents and various image files. Digital Document Super Glue in FileMaker What’s New in the FileMaker MonkeyBread Plug-in - 13.2 Release The FileMaker MonkeyBread Plug-in Spotlight: OCR The FileMaker Monkeybread Plug-in Spotlight: …

To round out our series on installing FileMaker 2023 Servers, for this stream Richard and Jacob show a from-scratch FileMaker Server 2023 setup and installation on MacOS Monterey in AWS! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Yesterday was Windows, today is Linux 2023. If you need to know how to install a FileMaker 2023 Linux server from scratch, Richard and Jacob are here to show you how to do it. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Watch Richard Carlton and Jacob Taylor demonstrate a "from-scratch" FileMaker Server 2023 setup and installation on a Windows Server 2022 on AWS! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Recently we got a request to merge documents of several types. Basically PDF files and images. Clients want to merge report from FileMaker with attachments like image files of repaired items and additional certificates as PDF documents. The start file has a layout with six container fields for input. It could have been a portal with a sub table for the fields, but for some reason the client didn't do that. So six fields may or may not contain some content. We start with a script by checking if DynaPDF needs initialization. Either on startup or first time you use our plugin's DynaPDFfunctions, please locate where the library is and call DynaPDF.Initializ…

Recently in the FM Training Livestream, we talked about the new OnWindowTransaction trigger in FileMaker 2023 version. We looked into the Creating audit logs with the OnWindowTransaction script trigger article on the Claris Engineering blog. You may also want to check the blog article from Soliant here: Transaction Logging in FileMaker 2023. We got a few questions and thoughts and we look forward to have someone make a session about the trigger for next Claris Engage to talk about all the little details, but let me start here with a few thoughts and possible pitfalls: OnWindowTransaction trigger is defined per file, so one script for …

A new update of our add-on pack is coming out, which means more free add-ons for you to use! This stream, Calvin looks at the updates to the Left Navigation Card add-on. Stuart takes us through the Modular Search add-on. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

We are happy to see 24U automate adding MBS Plugin to the iOS apps in Xgode with a simple checkbox. If you like to make an iOS app with MBS Plugin to get a branded FileMaker Go for your company, please check this out: Let us know if you have any questions.

Complex PDF management can be achieved with the Monkeybread Plug-in. Christian Schmitz is here to discuss what the WinPDF, PDFKit, and DynaPDF functions can do for your FileMaker file. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

FileMaker Starting Point’s update was released at the beginning of this year - lets break down the new design and new features. This stream we looked at the Data Migration tool. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Digital Document management in FileMaker remains a hot topic. Richard is here to cover ways of doing it within FileMaker, and Christian Schmitz is here to discuss how the MonkeyBread Plugin can help with that. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

After you read the blog post about printing on macOS, you may wonder how to use these functions on Windows. The answer is that we have different Printer functions. On Windows we show the standard print dialog and click for you since we can't intercept it like we do on macOS. But this is usually quick enough, that you may only see the dialog for half a second. The Printer.Print function goes like this: MBS( "Printer.Print"; Printer { ; CloseDialog; Number of Copies; Paper Format; Paper Orientation; Paper Source; Pages From; Pages To; Collate Pages; What; PrintToFile } ) Over time we added quite a few parameters. First one is the name of the printer. Since the matc…

You may want to use our plugin functions to control printing in FileMaker Pro. Built-in to FileMaker is a script step, which allows you to configure printer settings with a dialog and store them in the script. But that is specific to the selected printer and may not work with a different one. For a bigger solution, you may want to have a table with details for printers, so you can pick the right printer based on what you like to print. For example use a black & white laser printer for some prints, but use a color printer for some reports and print invoices on a printer with some specific later paper in one tray for the first page. And then print other pages of the …

Did you know that FileMaker Pro or the whole computer can go to sleep while doing a longer script? On macOS there is a feature called App Nap to save energy by sleeping applications. And of course on Windows and macOS the display gets to sleep after some time and sometimes even the whole PC or Mac goes to sleep. With MBS FileMaker Plugin, you can add a script line on the start of your script and then a second line on the end of the script. The start of the script calls the ProcessActivity.beginActivity function like this: Set Variable [ $activity ; Value: MBS( "ProcessActivity.beginActivity"; "IdleSystemSleepDisabled UserInitiated"…

Let's talk about what JSON looks like, what the syntax rules are, and mostly - how FileMaker works with it currently! This recording is meant for developers who have not had much exposure to JSON, and they should walk away from the video with a better understanding of this language. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Add title Sometimes you’ll get calls from clients where they swear that the Internet is completely full! Richard is here to discuss how to manage nontechnical FileMaker users and how to deal with and troubleshoot their Network latency.Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Script Triggers allow you to specify that a script runs when a certain event occurs. Richard is here to break down the types of Script Triggers and use cases for them. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Our presenter discusses his FileMaker add-on for logging a ‘Session’ every time a user opens a FileMaker file, including logging every script that is run during their session. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Christian Schmitz returns to discuss how his Monkeybread Plug-in can expand the power of your webviewers in FileMaker, Extract text and HTML, run JavaScript directly, fill forms in your FileMaker files, and more. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Need to edit images in your FileMaker databases? The Monkeybread Plug-in can convert image formats, scale, crop, rotate, draw text, differences in pixel tracking between Windows and Mac, and more! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

For this series, Nick tackles renovating and modernizing a Viewer's file live. This allows the audience to see how tackling a customer project can be accomplished by a senior FileMaker engineer. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Moving files into and out of your FileMaker databases can get complicated. Christian Schmitz is here to discuss using his Monkeybread Plug-in to upload, download, list, delete or rename your files using FileMaker. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

For this FileMaker Server Open Q&A, we discuss Time Machine backups, hardware requirements for FM 19 and FM 2023, Azure, AWS pricing, and more. Future live streams: 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 what is new in the MBS FileMaker Plugin in version 13.2. Including the plugin running on Linux on ARM with a demonstration of Trace function, DynaPDF functions for JavaScript and form fields, use of MongoDB functions, more Archive functions, WinPDF functions for rendering previews of PDF pages, AVPlayer and WMFP functions. What’s New in the FileMaker MonkeyBread Plu…

In this article we want to introduce you the new functions from the MBS FileMaker Plugin in version 13.2. FileMaker 2023 As you have probably already noticed, FileMaker 2023 was launched at the end of April. We are happy to announce that we have adapted our plugin to be compatible with the new FileMaker version and you can use the functions as usual under FileMaker 20.1. With the Release 13.2 we support FileMaker 7 to the latest version 20.1. DynaPDF DynaPDF focuses in this release on the integration of JavaScript codes in the documents. Already since plugin version 6.4 we can include JavaScript actions in a PDF document. A JavaScript Action causes…

Since FileMaker 2023 we got the feature named OnWindowTransaction trigger. You may have read about it on the Claris Engineering Blog: Creating audit logs with the OnWindowTransaction script trigger. Now where do you store your AuditLogs? In the same table, the same database, on the same server? Maybe better take advantage from the fact, that you get JSON data passed to your trigger and pass it to MongoDB. Since MongoDB stores JSON very efficiently, you could just store all your audit data there. Whether you store them all on one MongoDB server (cluster) or have each FileMaker server from a client have their own MongoDB server, depends on how …

For our Thursday stream on FileMaker 2023, we show off two demos. In particular, we focus on Claris Connect and it’s corresponding scripts, and the new Perform Call Back on Server. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Thank you to Doug Wallis & Connor Brock for their fantastic presentation on FileMaker Server 2023 on our livestream! We talked Persistent Cache, Ubuntu 22.04 Long Term Support, Server-Side Java Garbage Collection and more! Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

We were grateful to have Rick Kalman from Claris, present on our Livestream about FileMaker 2023! Watch the recording here, where we talk about FileMaker 2023's new features, including new scripts, free Claris Connect, and more! Watch the recording here: https://youtu.be/98-QecdDnq0 Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

I just published two (long) blog posts about FileMaker 2023. In-depth review FileMaker 2023 Audit Log feature And for those interested and who understand French, we're hosting a Q/A Webinar at 6PM CET.

Claris has released FileMaker 2023. Join Claris and RCC over the next 4 days as we dicuss changes and new features. We’ll talk platform improvements, security, and show off demos to our live audience. Register for RCC FileMaker LiveStreams Here: https://fmtraining.tv/#LIVE Interested in finding out more about the FileMaker Platform, check it out here. https://bit.ly/claris23 Need FileMaker Licenses? Please contact RCC Sales Here: [email protected] We can’t wait to see you all in our LiveStreams!

Want to generate a PDF using Javascript in FileMaker? For day seven of our Javascript in FileMaker series, we begin to break down the beginning stages of how to do so. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

We continue our Javscript 101 in FileMaker series by exploring how to use jQuery in a webviewer to work with existing HTML from websites! Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

We start Javascript 102 in FileMaker, beginning our discussion on jQuery. Day one defines what libraries are, and specifically what jQuery as a library offers you. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

For day 4 of our Javascript 101 in FileMaker series, Leland talks limits in Javascript, the FileMaker Data API, pagination in FileMaker and more! Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

We continue Javascript 101 for FileMaker, but on day 3 we talk about the definitions of “Syntax”, “Scope, “Operators”, and “DataTypes” as well as jump into, according to Leland, the more “fun”stuff! Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

We continue our series on Javascript 101 for FileMaker developers. For day 2, we refine our basics by opening a sample file and beginning to break down more difficult concepts. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

We start our series on Javascript 101 for FileMaker developers. For Day One, we discuss the very basics of Javascript, and how to get a 'Hello World', so you can begin implementing Javascript in your FileMaker solutions. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Here is a snippet we showed on the FMTraining live stream yesterday and it may be interesting for everyone here: Set Variable [ $image ; Value: MBS( "GMImage.NewFromContainer"; $input) ] If [ MBS("IsError") = 0 ] # limit size to maximum 1000 pixels in width Set Variable [ $scale ; Value: MBS("GMImage.Scale";$Image; "1000>") ] # remove metadata Set Variable [ $r ; Value: MBS( "GMImage.SetProfile"; $image; "IPTC"; "" ) ] Set Variable [ $r ; Value: MBS( "GMImage.SetProfile"; $image; "EXIF"; "" ) ] Set Variable [ $r ; Value: MBS( "GMImage.SetProfile"; $image; "XMP"; "" ) ] # save Set Variable [ $NewImage ; Value: MBS("GMImage.WriteToJPEGContainer"; …

Since Microsoft added some PDF functions to their frameworks in Windows 10, we can now implement this to our MBS FileMaker Plugin. That got possible since we dropped Windows 7 and require newer functions for component management in Windows 8. For MBS FileMaker Plugin 13.2, we add the new functions for you to try out: WinPDF.GeneratePreview Adds preview to an existing PDF container. WinPDF.IsPasswordProtected Whether this document is password-protected. WinPDF.LoadContainer Loads a PDF document from data in container. WinPDF.LoadFile Loads a PDF document from file synchronously…

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 Webview functions in MBS FileMaker Plugin. Let us show you have to use the inspector and run JavaScript. The FileMaker Monkeybread Plug-in Spotlight: Webview The FileMaker Monkeybread Plug-in Spotlight: Image Editing The FileMaker Monkeybread Plug-in Spotlight: SFTP Claris FileMaker Monkeybread Plugin 13.1 Update Claris FileMaker Monkeybread…

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 GraphicsMagick functions in MBS FileMaker Plugin. Let us show you have to use the new crop example and many others. The FileMaker Monkeybread Plug-in Spotlight: Image Editing The FileMaker Monkeybread Plug-in Spotlight: SFTP Claris FileMaker Monkeybread Plugin 13.1 Update Claris FileMaker Monkeybread Plugin 13.0 Update Webhooks in FileMaker …

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 SFTP functions in MBS FileMaker Plugin. Let us show you have to use the CURL functions for FTP, SFTP and FTPS. The FileMaker Monkeybread Plug-in Spotlight: SFTP Claris FileMaker Monkeybread Plugin 13.1 Update Claris FileMaker Monkeybread Plugin 13.0 Update Webhooks in FileMaker with the MBS Plugin FileMaker Monkeybread Plugin Open Q&A …

In the past we may have connected a FileMaker solution to push data to a web server with a MySQL database. But nowadays, we prefer MongoDB for a lot of things. No hassle dealing with defining the schema upfront and enjoying a lot of built-in features like audit logs and scaling via a cluster. With MongoDB we can setup a cluster and link a few servers together as a cluster. Within the cluster the MongoDB servers synchronize themselves automatically eventually. You may connect for example a server in America with one in Europe and one in Asia. This distributes the load to this servers and makes the whole access more responsive. If needed, we can later add more s…

While we have our advanced RegEx functions in MBS FileMaker Plugin using RegEx.Compile and RegEx.Execute, we got a set of easier functions: RegEx.Match This function can simply tell you whether there is a match, e.g. when you like to check if some text is contained in a piece of text. You can play with the data viewer and just evaluate it. e.g. MBS( "RegEx.Match"; "H(.*)o"; "Hello") Or use it to check if for example a text is a number by using a pattern like this: MBS( "RegEx.Match"; "^(\d+)$"; "12345") The ^ means the beginning of the line (if multi line is enabled) or beginning of the inp…

Since we added the search box for the relationship graph for Windows in MBS FileMaker Plugin, a lot has improved. We fixed bugs and added more functionality, so checkout the version as in version 13.1 of the MBS Plugin for both FileMaker Pro and Claris Pro: As you may notice the look changed a bit and it is no longer a text field, but a combo box, so you can popup the control and see the choices. We populate the choices when the dialog opens, so if you just added a new table, it doesn't yet show up. But next time you open the window, it should be in the list: We hide the field, if you move to another tab. And when we create the field, we generate two…

In this article we want to introduce you the new functions from the MBS FileMaker Plugin in version 13.1. Archive With the new functions of the Archive component you can easily create your own archives. First, you create a new archive with the Archive.Create function. In this function you define the format in which your archive should be written. The following formats are available: 7zip, ar, arbsd, argnu, arsvr4, bsdtar, cd9660, cpio, gnutar, iso, iso9660, mtree, mtree-classic, newc, odc, oldtar, pax, paxr, posix, raw, rpax, shar, shardump, ustar, v7tar, v7, warc, xar and zip. Then we have to choose a filter that fits the format. Optionally, we can then specify…

For this server Q&A, we discuss why RCC uses Macs over Windows for FM Servers, and backups, including a showcase of the S-3 Hourly backup for AWS, backup files via rsync, and more! Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

A client asked about uploading via SFTP and using rename command. There is a trick to use quote commands to rename the file when the uploaded finished. We like to avoid having a half uploaded file, so we upload to a temporary file first and then rename it. Take a look on this script: Set Variable [ $curl ; Value: MBS("CURL.New") ] Set Variable [ $result ; Value: MBS( "CURL.SetOptionURL"; $curl; CURL Test::URL & "temp.jpg") ] # login via password Set Variable [ $result ; Value: MBS( "CURL.SetOptionPassword"; $curl; CURL Test::Password) ] Set Variable [ $result ; Value: MBS( "CURL.SetOptionUsername"; $curl; CURL Test::Name) ] Set Variable [ $result ; Value: …

You may know our JavaScriptWebKit functions for macOS and iOS. But with the upcoming 13.1 release, you can use those functions on Windows and Linux, too. It's up to you to provide the library, so we go through this step by step for Linux. Here is the screenshot with the trace output on Linux: You should have a recent FileMaker Server installed on Linux with Ubuntu in a recent version. Please open a terminal connection either by doing so on the server directly or via ssh connection. First we go to refresh the package directory on Linux by running the following command: sudo apt-get update Next we can search JavaScript Core library: apt-cache …

Recently we got asked what we can do for emailing in MBS FileMaker Plugin. While we recommend not to try and replicate a full Mail client, you can do a lot with our plugins and so let us sum up what we can do: SMTP We provide CURL functions and SendMail functions to send emails with more options than what is built-in to FileMaker. Send Email Our plugin can send emails via SMTP protocol. Port is 25 by default, but alternatively you can use port 587 if a firewall blocks port 25. Or for smtps:// protocol we use port 465. When you send an email, you retain the protocol from curl, so you can see what happens. This may show errors like invalid credentials, hit…

For 13.1 we get new Archive functions to build a zip archive on the fly. One of the use of deprecated ZipFile functions was to assemble an archive in memory from various files or containers. You can now do that with our Archive.Create function. Just call it to either start an on-disk or in-memory archive using the compression format and compression filter of your choice. We usually use zip for maximum compatibly, but you can also do tar or 7zip. Next you can add content. For that you may use Archive.AddContainer to pass a container value as variable or pass a field reference. We read the content of the container and compress it in memory. If you have existing…

You have a SQL data source and you like to get JSON from it inside FileMaker to pass that JSON on to a web services or DATA API? Or you have a SQL source and you like to move records from it to FileMaker easily? Or other direction? Since MBS Plugin supports CubeSQL, Centura SQLBase, DB2, DuckDB, Firebird, Informix, InterBase, MariaDB, Microsoft Access, Microsoft SQL Server, MySQL, ODBC, Oracle Database Server, PostgreSQL, SQL Anywhere, SQLite, SQLCipher and Sybase as data source, we can help here. ODBC itself can of course be used for many more here. Let us show you a script to connect to a data source by its name used in the system. This means you…

There is more to come based on questions and feedback. IMAP If you like to change our IMAP example to use oAuth, please use script steps like this: Set Variable [ $r ; Value: MBS("CURL.SetOptionURL"; $curl; "imaps://outlook.office365.com/INBOX") ] Set Variable [ $r ; Value: MBS("CURL.SetOptionXOAuth2Bearer"; $curl; "eyJ0eXAiOi...") ] // your oAuth token Set Variable [ $r ; Value: MBS("CURL.SetOptionUserName"; $curl; "[email protected]") ] // no password needed! You remove the CURL.SetOptionPassword there and add the CURL.SetOptionXOAuth2Bearer with the token. For the URL make sure you have the imaps protocol with the s. A typo in the URL and nothing will wor…

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 is new in MBS FileMaker Plugin 13.0 including MongoDB, DynaPDF, CURL, new checkboxes in preferences and more. Claris FileMaker Monkeybread Plugin 13.0 Updates Webhooks in FileMaker with the MBS Plugin FileMaker Monkeybread Plugin Open Q&A Microsoft Office 365 Authentication with oAuth 2 How to build an iOS SDK App The FileMake…

Did you know that Windows 10 has a built-in OCR engine? For MBS FileMaker Plugin 13.1 we add new WindowsOCR functions. These functions allow the plugin on Windows 10 to use the built-in OCR classes and expose them as functions to you in FileMaker. This was made possible by dropping Windows 7 support, so we can now use the functionality from Windows 8 to use these classes. Although if you call them on Windows 8, they will return an error. Please use WindowsOCR.Available in your script to check whether it returns 1. Once you know you run on Windows 10 (or 11), you can check the available languages with WindowsOCR.AvailableRecognizerLanguages function. This function ca…

After multiple requests from our viewers, Christian Schmitz is here to tackle Microsoft Office 365 Authentication with oAuth 2.0 in FileMaker using the MBS Plug-in! Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com