Community Videos, Tips, & Techniques, Articles.

To finish our UI/UX for Advanced Developers series, we discuss how to build smart sub summaries and identical sorts for records and portals. Check out the future live stream schedule at: 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 12.5. One Plugin for FileMaker AND Claris Recently, the first version of the Claris product line has been released. We are proud to announce that our plugin will also work on the new platform and you can use it there as usual. The best thing is that you can use the same plugin file for FileMaker and the new Claris. This is the first and currently the only plugin worldwide that works on both platforms equally. MongoDB Watch video about MongoDB MongoDB and MBS - A look under the hood Since version 12.3 there is th…

Continuing our UI/UX for Advanced Developers series, for Day 14 we cover how to apply the Sort feature to both records and portals, and how to build smart buttons using titles as a reference. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Pivot Tables are a method for summarizing and re-odering data laterally as opposed to vertically down a layout. Summarizing data into vertical columns is not a default capability in the FileMaker Platform. It has to be cleverly scripted. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Next to your container fields in iOS, you can show a button to insert a picture from the photo libraries. If you'd do this with our older ImagePicker functions, you may get a dialog about permissions to access the photos library. The new PhotoPicker functions allow you to access a dialog to pick photos from your app without such a dialog. The dialog runs as part of a background app included with iOS, which has all the permissions needed. It can show the whole photo library without your application having access to it. The user can select one or more pictures and have those being available to your applications. The images are then downloaded in the background …

For Day 13 of our UI/UX for Advanced Developers series, Nick covers why making a feature to sort records is necessary, and how to create fields as building blocks for the sort feature. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

A lot of people are confused about the new Claris Platform. We’re here to help answer questions, comments, or concerns. This time, Richard explains the differences between the Claris and FileMaker platforms in detail. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

For this stream, we answer questions about vertical market apps, installing Claris Studio and Claris Pro on servers, and migrating to Linux! Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

ExecuteSQL in FileMaker provides some additional ways of rapidly generating reports and finding unique sets of data without creating additional relationships. Calvin Mosiman dives into ExecuteSQL for beginners, so they can learn to use this valuable tool. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

ExecuteSQL in FileMaker provides some additional ways of rapidly generating reports and finding unique sets of data without creating additional relationships. Calvin Mosiman dives into ExecuteSQL for beginners, so they can learn to use this valuable tool. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

For this stream, we answer questions about vertical market apps, installing Claris Studio and Claris Pro on servers, and migrating to Linux! Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

https://youtu.be/bMu_nLwqfrM For day 9 of our Advanced UI/UX series, learn how to position card style windows in a layout, use card style windows in your scripting, and to display messages inside of the card style windows. 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 8 of our UI/UX for Advanced Developers, Nick discusses how to open and close Card Style Windows, use them to edit data, and use them to replace popovers. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

You like to have a FileMaker Server on the go with your Macbook (Pro) M1 or M2? Install Parallels and let it install Windows 11. Within the ARM version of Windows 11, you can install FileMaker Pro 19.5 and it seems to work fine. Since there is no native version for ARM64, the application runs in emulation within Windows. You can also install FileMaker Server. Running a FMS on Windows 11 and not Windows Server 2016 or 2019 is not really supported, but can work. The installer will complain about missing Internet Information Services and Application Request Routing. But you can go on one of the Microsoft websites and download the Application Request Routing installer …

For years we have nice goodies for FileMaker developers on macOS and now we got one for Windows: You can search within a relationship with a search field: I tried for years to do something there. But when the plugin asks Windows about what is on the window, the OS would say: zero controls. Yes, the normal Windows API doesn't see the controls since they are all done in C++ classes drawing directly into the window. Without a handle to work on, we gave up several attempts to do something. But a few days ago I looked again on various windows and I noticed that the third tab actually uses a real Win32 control to show the graph for relationships. Probably because this …

Christian Schmitz regularly updates the Monkeybread plug-in with new and exciting features. For MBS 12.4, he discusses MongoDB integration, code-folding all those pesky Loops, 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

Sometimes FileMaker developers miss a script trigger to run when you switch between windows. We usually recommend people check if Window.Currentfunction returns a new number. And you may do that with Schedule functions. Here is a script to start a schedule to check the window regularly: # current window Set Variable [ $currentWindow ; Value: MBS("Window.Current") ] Set Variable [ $r ; Value: MBS( "FM.VariableSet"; "WindowActivateTriggerCurrentWindow"; $currentWindow ) ] # Schedule a calculation to check window every second Set Variable [ $schedule ; Value: MBS( "Schedule.EvaluateAfterDelay"; 1; "Let([ lastWindow = MBS( \"FM.VariableGet\"; \"WindowActiva…

We resolved the problems we had with Claris Server and now our plugin works there. If you have a Claris Pro or Server, feel free to later try the 12.5pr4 version of MBS Plugin. On the licensing we got asked if we sell Claris Pro/Server plugin separately. What a terrific business idea! But no, we don't ask for extra money to move from FileMaker to Claris. Just make sure you have a recent license, which includes 12.5 (or later), so you can use our current plugin versions. And eventually most of our customers may move in a few years, when the Claris product line has a more attractive offering compared to the FileMaker line. We'll update documentation over the time to a…

Do you know the additional functions for containers that the MBS FileMaker Plugin offers? In this blog article I would like to introduce you to a few of them. Let's start with the loading of a file into the container field. For this we use the function Container.ReadFile. With it we read files via a native file path. This path can be defined by a text field or by the FileDialog functions with the help of a dialog. This function can be used not only in FileMaker Pro, but also on the server. We must pay attention that the server is authorized to access the files, otherwise it does not work. Beside the file path also a mode can be specified. If no mode is specified, th…

Sometimes we need to make screenshots or present with FileMaker Pro or Claris Pro in other languages and you can have at least eleven languages: You know all the languages in those menu bars? I made a couple of little AppleScript apps to launch FileMaker Pro 18, 19 and Claris Pro in another language. So I can double click the French one and another instance of FileMaker Pro launches on my Mac with French localization. Download: LaunchFileMakerInDifferentLanguages.dmg We updated this to include Claris Pro, include Apple Silicon code and proper entitlements to avoid permission errors. You may still be asked once to allow automation, e.g. like this: P…

We like to show you a few functions related to CSV and what you can do with combining various functions of our MBS FileMaker Plugin. Usually you get a CSV file as an export from some other database, e.g. a list of sales. Read Textfile If you like to read a text file, you can simply use our Text.ReadTextFile function. Pass the path and the text encoding to use and you get back the text. The encoding should be right for umlauts or accents. Usually everyone uses UTF-8 nowadays, but we also support various older encodings. If you have the file in a container, please check the Text.ReadTextFromContainer function, which takes a container value as reference. Parse CS…

Claris has launched a new platform, and there is a lot of confusion in the community. Richard is here to help answer your questions on the topic. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Ransomware and the sanctity of your FileMaker databases are hot topics in today’s security landscape, but Jesse Barnum is here with SafetyNet as a solution. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

How to automatically install MBS Plugin in FileMaker without having the plugin? We have gzip versions of our plugins here: gzip downloads. There you find the current URLs for all our plugins and the version.json with the version information. You may do a script to automatically install the plugins. Now we got the question how to load the MBS Plugin with Insert From URL for an installation, so here is an example script: # normal release here Set Variable [ $URL ; Value: "https://www.monkeybreadsoftware.com/filemaker/files/gzip/version.json" ] Set Variable [ $JSON ; Value: "" ] Insert from URL [ Select ; With dialog: Off …

The Claris Platform has launched! Rick Kalman, the director of Product Management for Claris, joins us on stream to discuss. Check out the future live stream schedule at: 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 check out the new functions here. 12.4 MBS FileMaker Plug-in Update with Christian Schmitz SQL connectivity with the FileMaker MBS Plugin Easy SQL with the MBS FileMaker Plugin FileMaker MonkeyBread Plugin & MongoDB What's new for the FileMaker MBS Plugin 12.3 Customizing your FileMaker Solution using the MonkeyBread Plug-in Using Monke…

In this article we want to introduce you the new functions from the MBS FileMaker Plugin in version 12.4. MongoDB In the last release we already introduced our new component MongoDB which allows you to read and write data in MongoDB using FileMaker. Please have a look at the video MongoDB and MBS - A look under the hood which describes the functionality in more detail. In this release we have added a few new functionalities that should make your work with MongoDB even easier. With the functions MongoDB.CloseCollection and MongoDB.CloseDatabase you explicitly close a database or a collection. Normally you don't need to use these functions because when you open a n…

Check out the FMTraining.tv website. Richard Carlton and his team do a daily free live stream about FileMaker to watch. A few days ago Christian Schmitz from Monkeybread Software joined a live episode to talk a bit about the MBS FileMaker Plugin. Watch it on YouTube. We check out the SQL functions in MBS FileMaker Plugin to do a SQL connection to a PostgreSQL database. SQL connectivity with the FileMaker MBS Plugin Easy SQL with the MBS FileMaker Plugin FileMaker MonkeyBread Plugin & MongoDB What's new for the FileMaker MBS Plugin 12.3 Customizing your FileMaker Solution using the MonkeyBread Plug-in Using M…

Check out the FMTraining.tv website. Richard Carlton and his team do a daily free live stream about FileMaker to watch. A few days ago Christian Schmitz from Monkeybread Software joined a live episode to talk a bit about the MBS FileMaker Plugin. Watch it on YouTube. We check out the FMSQL functions in MBS FileMaker Plugin to quickly use SQL under the hood without doing SQL ourselves. Let the plugin write the SQL statements and just call functions like FM.InsertRecord, FM.UpdateRecord or FM.DeleteRecord. Easy SQL with the MBS FileMaker Plugin FileMaker MonkeyBread Plugin & MongoDB What's new for the FileMaker MBS Plugin 12.3 …

For Day two of our UI/UX for Beginners series, we discuss positioning of objects in space. You will learn the difference between expression and function, as well as how to use colors and visual effects. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

In this stream series, Nick covers basic design concepts and how UI-UX applies to FileMaker solutions. Day One - we cover the history of GUI, what UI is, what UX is, and why it is called “design”. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

For this stream, Christian Schmitz shows how the Monkeybread function can be used within FileMaker to insert, update and delete records without writing SQL yourself. 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 10 of our series on how to build a bot for FileMaker, Nick breaks down how to go about debugging your bot once it is built. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Nick, joined by Richard Carlton and Jacob Taylor, breaks down the interactions your FileMaker bot will have with the FileMaker Server. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

MongoDB is a source-available cross-platform document-oriented database program. With the power of MBS and FileMaker, you can now connect your FileMaker databases to your Mongo database! Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

After continuing the Task queue conversation, Nick sets up a Server Scripts Activity system and demonstrates how to get the status and other information from performed Scripts. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Let Stefanie show you how to install a local copy of MongoDB and use it in Claris FileMaker with the MBS FileMaker Plugin. We have a version in English and a version in German. All movies Watch on YouTube. MongoDBen.m4v In Deutsch

MongoDB is a document-oriented database program. With this presentation from Chris Moyer, you can see the possibilities in making a hybrid application with MongoDB and FileMaker. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

For this FileMaker Server Open Q&A, we field questions about government-issued common access cards integrating with FileMaker, hosting options for your FM Servers, OAuth, 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

For Day One of our ‘Build a Bot in FileMaker" series, Nick Hunter explains what a bot is, why and when it’s useful, and demonstrates a fully functioning bot! Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Nick breaks down how you can use a "trigger" technique to evaluate auto-entry calculations on demand. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

With the updated release of FileMaker 19.5, the MonkeyBread Plug-in has also been updated! Christian Schmitz comes on to talk about his new functions and features. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

A cool new thing comes with the MBS FileMaker Plugin 12.3 for us: You can connect in FileMaker to a Mongo DB server and create on this server databases, collections and documents with various functions, search in documents and delete them as needed. The special thing about Mongo DB is that it is not a relational database based on tables and relations, but its data has a JSON like structure. This allows you to make queries that were previously not possible due to the restriction of relationships or table boundaries. So find out who is longer in your company: the carpet in the warehouse or your trainee. We add a new example file about Mongo DB to our plugin examples. …

Nick does a short series of streams about building a selectable date record generator for your FileMaker database. He shows the completed version before building it from scratch. He also discusses knowing when to use specific tools to fix your problems in FileMaker. Check out the future live stream schedule at: 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 take about the new MBS FileMaker Plugin 12.3 release. See announcement and documentation. What's new for the FileMaker MBS Plugin 12.3 Customizing your FileMaker Solution using the MonkeyBread Plug-in Using MonkeyBread for FileMaker Webhooks - Day 2 (WebHooks) Using MonkeyBread for FileMaker Webhooks - Day 1 (WebHooks) Windows/Mac Webcapture and Webcam…

For MBS Plugin 12.4 we implemented a long standing wish from various FileMaker developers: Code Folding. As you know our plugin highlights matching script lines for If and Loop blocks. So you see what lines belongs to what other line. Now when we detect such a block, we add a little control on the between the line number and the text. You can click that control to hide some lines and later click it again to show them. When you save the script, FileMaker reloads it or you start dragging a line, all lines show again. Our line hiding is only temporary until something unhides them. Please try and let us know the if you find issues. As usual, this fea…

Handling duplicate records can be a pain. For Day 28, we break down a script we use to remove/merge duplicate records. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

You may want to add an entire module to your database by duplicating another module. We break down how to do this step-by-step, by making a Purchase Order module from Estimates. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Conditional formatting is useful for making important objects or information stand out on your layouts. We break down the basics for Day 26. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

A few days ago Christian Schmitz from Monkeybread Software joined the DIG FM Meeting to talk a bit about the MBS FileMaker Plugin. Watch it on YouTube: We talked about what is new in MBS Plugin 12.3, showed off some evergreens and answered questions. 0:00:15 Plugin Website and Overview 0:01:23 WHAT'S NEW in 12.3 0:01:28 Functions for MongoDB 0:18:00 DynaPDF 0:32:12 "Live Text" 0:36:46 "Cool things with Error Logging" 0:44:22 Audit functions 0:55:50 SQL functions 1:02:57 Serial ports and devices 1:03:37 TOTP, time-based passwords 1:04:25 Variable lookup, Levels of Variables in FileMaker 1:08:15 Script Workspace enhancements 1:15:20 Manage…

FileMaker has 26 unique script triggers that can allow scripts to be performed after a variety of actions. For Part 2, we continue to explore and explain these triggers. Check out the future live stream schedule at: 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 12.3. MongoDB The coolest feature in new release is the new Mongo DB topic. You can now use FileMaker to access MongoDB databases, read, write and delete data. The special thing about Mongo DB is that it is not a rational database that is limited by relationships and tables, but is based on a JSON-like structure that also allows unusual queries. For example, you can formulate searches to see who has been in your company longer, the carpet in the warehouse or your employee. In rational databases, your carpet wouldn't normally appear in the same table as your employe…

Calendars are not native to the FileMaker platform, and as a general rule they are not provided by Claris. This livestream covers how you can add a calendar to your database. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

As a followup to our discussion on Naming Conventions, Michael and Richard discuss data modeling and what tables you actually need inside of your FileMaker database. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Unique, consistent names for scripts, layouts, relationships, and table occurrences are needed to stop developer confusion. Even though re-sequencing is inevitable, we discuss how you can make this easier on yourself. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Understanding how FileMaker's behavior changes after being hosted on a server is important. For Day 18 we cover record locking, error trapping, and how scripts can interact with multiple users. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Day 17 - we discuss Reporting. Reporting is the last thing that developers typically build in a FileMaker solution, but it should be documented and planned out well before you start to build your app. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Scripts are what control all the processes in your FileMaker database. On Day 11 we talk about the common scripts that most beginner FileMaker developers will want to write. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

How developers organize relationship graphs varies, but Anchor-Buoy is a proven, clean and simple technique. For day 8 of our series, we break down how Anchor-Buoy works and how it makes relationship graphs easier to understand. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Andy LeCates and Connor Brock, from Claris, join our stream to discuss the release of Claris FileMaker 19.5 - full of bug updates and some new features! Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Blue Feather is pleased to announce our latest open-source project for FileMaker web apps, Jetstream FileMaker! Jetstream FileMaker builds on Laravel Jetstream and lets you get started building a web app for your FileMaker database with features like user registration, logins, password resets, and 2FA in just a few minutes. It’s very fast to get started, easy to get data from your FileMaker database, and Vue and Tailwind CSS let you build a great front-end user experience. Check out the GitHub for full download instructions and a video demo of the setup process. Contact Blue Feather today if you'd like to talk to the experts about building web apps for your File…

In this article we want to introduce you the new functions from the MBS FileMaker Plugin in version 12.2. Error Count for MBS functions For years we already have the isError function in the MBS FileMaker Plugin. We can call this after a MBS function to see if the previous MBS function returned an error. If you use many MBS functions in a script this can get confusing and it might be enough for you, e.g. if you are testing a script, to know if a plugin function in the whole script throws an error at all. For this we have developed two new functions. With the HadErrors function you get back the number that is currently in the error counter. This will be incremented…

At the dotfmp conference we got a nice idea for a feature: MBS FileMaker Plugin already scans script lines to find missing variables and show a little warning for undeclared variables. We added the feature to scan for comments containing URLs. If we find an URL, we add a little button to the end of the line, which currently shows an arrow and a globe: You may click on the line to select it and then click on the control we add. Maybe double click may also work directly. But only if the list of script steps doesn't consume the click, it will come to our control. You can configure this via our preferences dialog or the new SyntaxColoring.CommentLinks.SetEnabled fun…

On Day 6 of our Build a CRM in 30 Days series, we tackle one of FileMaker's most complicated topics: Relationships. Learn how FileMaker uses relationships to make a cohesive, interconnected database. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

On Day 5 of our Build a Custom CRM in 30 Days series, Richard discusses the basics of FileMaker scripting, what the script workspace is, how to disable and enable code, and understanding Context inside of FileMaker. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

On Day 4 of our Build a Custom CRM in 30 Days series, we discuss how to recycle starter solutions, what starter solutions are available, and explain UI/UX and how that effects your solutions. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

On Day 3 of our make a Custom CRM in 30 Days series, we break down a beginner's security concerns and explain FileMaker Server in more detail. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

On Day 2 of our Customize a CRM in 30 Days series, we discuss the four modes in FileMaker and introduce Layouts, Tables, Fields, Records, and Found Sets! Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Join us for the beginning of our 30 days of Building your own CRM using the FileMaker Platform! Day 1 covers the basics of What FileMaker is, the capabilities of the platform, and how you can use it for your business. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

In this livestream, Richard recaps the latest Claris announcements, including FileMaker 19.5 and 19.6, and Claris Pro 20 - part of the brand new Claris Studio! Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Google is disabling Less Secure App access to email at the end of this month. If clients are using this to send or receive email with FileMaker, they will need to change their integration to use OAuth. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Claris’ Director of Platform Evangelism, Andrew LeCates, joined us for an Open Q&A on all the latest Claris announcements - specifically the Problem Solvers Circle and FileMaker 20. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

In this session with Claus Lavendt from DataManix, we talk about different tools and ways to optimize your development. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

We have a NEW version of FM Starting Point 2022! In this livestream we introduce and discuss our new UI and simplifications, as well as have open bug-fixing and Q&A. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Open FileMaker Q&A with Nick Hunter In this livestream, Nick answers questions on UI/UX design and some of his advanced relationship and script trigger techniques! Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

In Day 2 of Nick's advanced discussion on script triggers, he covers excessive use of triggers and how to avoid their misuse. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Sometimes your customers are terrible about communicating their needs. Richard and Kristian explain how you can figure out what your customer really wants when you can't read their minds! Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

In the final day of Nick's relationship series, he discusses exactly how he uses Tags and Global fields with his relationships to further optimize his databases. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

In Nick's final livestream on the ASCII table, he discusses how you can "hijack" the characters to further manipulate FileMaker. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

By default our SQL functions work in auto commit mode. If you like to use transactions, you need to turn off auto commit mode. You may have a script to connect to a database and after the SQL.Connect call is successful, you turn off auto commit: Set Variable [ $r ; Value: MBS( "SQL.SetAutoCommit"; $Connection; "off" ) ] Now you can for example run INSERT SQL commands for multiple records. If all functions returned success, you may commit on the end: Set Variable [ $result2 ; Value: MBS("SQL.Commit"; $Connection) ] Or in case one of them failed, you can do a rollback: Set Variable [ $result2 ; Value: MBS("SQL.Ro…

Sometimes you don't want your End Users to have access to Find Mode. In this Livestream, Calvin shows how to get around that by scripting search filters! Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Container fields can store lots of files within your FileMaker database! As a beginner, understanding their possibilities and functionality can be difficult, so Calvin takes the opportunity to thoroughly explain the basics of Containers. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

If you ever wanted a function to filter text in one click, Nick Hunter has the answer! In this 3 day series, Nick starts by explaining the ASCII table and how he uses it in FileMaker. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Jonathan breaks down his sample file that allows you to build Google Translate into any of your databases - without using an API! Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

The clock starts ticking… we're closing the registration for #d22 in 12 days. If you ever thought about joining THIS is the time now to decide: https://dotfmp.berlin/registerchoose (We have exciting topics in the making… but, psst…)

Richard explains how he uses the MonkeyBread Plug-in to make automatic thumbnails for videos, reducing a multi-minute process to only a few seconds. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

In this Supra-Optimization Livestream, Nick focuses on the speed of Auto-Entry vs Calculations, and shows how his techniques shorten imports from hours to minutes. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Day 3 of Nick's series on Relationships in FileMaker. This time, Nick explains how to add multiple values to filter the relationship. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Portals are a layout object that displays data and is often something that trips up beginner developers. Calvin breaks down what they are and how best to utilize them. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Do you need your FileMaker solution to look less like it was made in FileMaker and more like a stand-alone app? With the MonkeyBread Plug-in, you can do just that! Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Relationships in FileMaker can be difficult. Nick explains some of his unique techniques by tackling this subject from the ground up. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Day two of using the MonkeyBread Plug-in to add Webhooks to your FileMaker databases. This time, Christian Schmitz covers how Webhooks interact with FileMaker Server and how to build scripts that call those Webhooks. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Christian Schmitz of the MonkeyBread Plug-in returns to discuss MBS functions that allow for the use of webhooks! This time, he shows us buttons that can send HTTP requests whenever you press them. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

The last day of HOnza's series on turning your FileMaker databases into apps. This time HOnza covers MDM, Plug-ins, troubleshooting, offline syncing, 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

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 show you how to use WebHook functions in MBS FileMaker Plugin to get notified when someone presses a small bluetooth button. We show you how to use WebHook functions in MBS FileMaker Plugin to get notified when someone presses a small bluetooth button. See also older videos: Using MonkeyBread for FileMaker Webhooks - Day 2 (WebHooks) Using MonkeyBread f…

Day 4 of HOnza's livestreams on Xgode and turning your FileMaker databases into apps. HOnza covers App Store builds, metadata, encryption, privacy, submitting for release, resolving rejections and updating your apps! Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Day 3 of HOnza's series on turning your FileMaker databases into apps! This time, HOnza covers Ad-Hoc and App Store builds, beta test submissions, app previews, 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

The April 8th FMDiSC meeting was one of the most extraordinary I have experienced in my 30 some years as part of the FileMaker Developer Community. Both the interview with Molly Connolly and the panel discussion with David Knight, Chris Moyer, Ernest Koe, Mark Richman, and Bob Shockey were highly compelling. I strongly recommend that all take the time to view the video recording of this meeting found here: https://www.youtube.com/watch?v=a-oevQ6nwOw Steven H. Blackwell Platinum Member Emeritus

Day 2 of HOnza's series on making Apps out of your FileMaker databases. This time we walk through setting up an Apple developer account, as well as HOnza's best practices for testing and making apps. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

HOnza starts a 5-day series on using his fantastic product, Xgode, to help make digital apps using FileMaker! He also begins to discuss the ins and outs of navigating Apple's submission system! Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com