Community Videos, Tips, & Techniques, Articles.

A SSL Certificate enables an encrypted connection and is required for the installation of FileMaker Sever. In this 2 for 1 LiveStream, Jacob Taylor discusses purchasing a SSL Certificate AND installing FileMaker Server. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

As a Claris partner, we also resell FileMaker licenses. Buying the license from us has some extra benefits, one of them being a nicely formatted PDF document with all information about the license, including download links. In order to be able to generate this document from our FileMaker based CRM, I needed to find a way to include functional web links in it. So I wrote a custom function that does it, without needing any plug-ins or other external technologies. The custom function simply takes a PDF saved from FileMaker, and adds a link to it. As long as you know what page and where on that page you want the link to be, you can modify your PDF that easily. …

Presenting the ultimate Free FileMaker Plugin! It is like a Swiss Army Knife for your FileMaker app. If FileMaker doesn’t have a feature, this probably has you covered. Nick Orr presents the latest on this valuable tool. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Nick Orr from BaseElements joins us as we dive into his FileMaker Diagnostic Tool. It does a million useful things, including documenting abandoned layouts and scripts! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Jesse Barnum from 360Works joins us as we discuss Offline Sync and Worldwide Replication. As we wrap up the conversation, we let more people from around the world log in to the closest server and make edits. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Jesse Barnum from 360Works joins us as we discuss Offline Sync and Worldwide Replication. During Day 4, we invited everyone around the world to join the closest server and make edits. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

If you like to connect to MySQL or MariaDB from FileMaker with MBS FileMaker Plugin, you can set SSL options to connect through an encrypted connection. The options are named SSL, but nowadays it's all TLS v1.2 or newer. Here is a sample script we build with a client to get this FileMaker solution to connect to a MySQL server to download data, e.g. from a web shop. # Query parameters for connection Set Variable [ $$SQL.DB ; Value: Test SSL::_DBName ] Set Variable [ $$SQL.Server ; Value: Test SSL::_Host ] Set Variable [ $$SQL.Account ; Value: Test SSL::_User ] Set Variable [ $$SQL.Pwd ; Value: Test SSL::_Passwort ] # …

Jesse Barnum from 360Works joins us as we discuss Offline Sync and Worldwide Replication. During Day 3, we completed the deployment and answered questions on the process. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

FM Quickstart, the premier free CRM app for FileMaker, has been updated for FileMaker 19. Several new features and modules have been added including Task Lists, Calendar, and more. FM Quickstart Implementation Plans have also been added to our services offered in order to assist with setup and customization of FM Quickstart. Learn more about these new features and download the app here: https://dbservices.com/articles/fm-quickstart-19/ dbservices.com

Jesse Barnum from 360Works joins us as we discuss Offline Sync and Worldwide Replication. During Day 2, we cover the installation of Mirrors Sync and discuss the mechanics of Synchronization. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Jesse Barnum from 360Works joins us as we discuss Offline Sync and Worldwide Replication. During Day 1, we cover the basics, including having your Amazon server setup and ready to sync. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Claris released a new Engineering Blog where they've included some awesome performance recommendations. Let's go through it! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

I updated my SwiftFM repo for the FileMaker 19 Data API. https://github.com/starsite/SwiftFM Notable improvements include support for the new `validateSession()`, and moving the server `message` into the completion block. So now you can access the message in the closure, where it's more helpful. Better examples as well. Give it a ⭐️ on GitHub if you find it useful. Thanks! 😘

Everyone talks about IoT. We don't talk, we do. Just like our colleague Milan who wanted to get his greenhouse under control... As a little boy he grew tomatoes and some herbs in pots on balcony (because we didn’t have a garden at that time). Over time his hobby evolved into growing vegetables in a greenhouse. Since he also likes technology and automation, now many of the repeating processes are controlled by Claris FileMaker, Raspberry Pi, Hardwario, LoRa, Node-RED, etc. As Milan grew up and got his own garden, he could build a greenhouse there. Thanks to the greenhouse, he can extend the growing season to begin in early spring and last until late fall. B…

"Make Apps That Don't Suck" - Mike Lee. Learn how this can apply to FileMaker Custom Apps and start making awesome apps yourself! Mike Lee's presentation: https://bit.ly/2Ciut9L. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Just when you thought we couldn't make FileMaker Starting Point any better, we add an Enterprise version! Watch this Enterprise audit and learn more at: https://fmstartingpoint.com/ Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

If the calendar improvements weren't enough to get you excited about the new FM Starting Point 2020, then how about drag and drop Add-ons! Free sample file: https://bit.ly/2OsGiwk. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Last week, the 1st Claris Engage conference took place, virtually, over a 2 day period. John Mark and I plus our special guest Marc Larochele (from Productive Computing) reminisce about previous DevCons and then, at 11 minutes in, we start to discuss the conference itself. (All of the sessions are available to watch at the Claris Comminity website. Login and then click on Academy, fill in the simple questionnaire and then click on Engage On-Demand). What you will get in this podcast is our perspective and thoughts and we think you’ll find it a worthwhile listen. https://firesidefilemaker.podbean.com/e/we-were-engaged-were-you/ Our last podcast had a very special…

FM Starting Point 2020 is here for FileMaker 19. We’ll discuss changes and capabilities of this totally FREE CRM, starting with the calendar improvements. Learn more at: https://fmstartingpoint.com/ Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Ready? Aim. Scan! Storing strings of text can be pretty useful and 2D barcodes can store a lot of data. We'll show you how to create and read 2D barcodes in FileMaker. Free sample file: https://bit.ly/3gSaz4d Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Custom functions can perform calculations much faster than calcs in Scripts. We'll look at some of these, plus look at integrating with Twilio. Free Sample File: https://bit.ly/322BSEM Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

WhatsApp everyone! Calvin is back and this time he shows us how to integrate the messenger app WhatsApp with the FileMaker Platform. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

With latest MBS FileMaker Plugin 10.3 we tuned our dark mode support for FileMaker. While Filemaker's Script Workspace comes with some syntax highlighting features built-in, our MBS FileMaker Plugin can add more for macOS users: On the left is pure FileMaker and on the right side is with MBS FileMaker Plugin. Below in light mode: You may notice that our plugin applies coloring rules, e.g. to highlight broken script lines in red. The plugin colors comments based on tags, highlights blocks and shows errors for undefined variables being used. Learn more about Syntax Coloring If you run in the screens below, the colors are not right and you …

In this LiveStream FileMaker Q&A recording we answer questions about installation, upgrading, purchasing and how to make FileMaker work for you and your company to increase ROI. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Creating virtual menus in FileMaker can be so complex that your head will explode. Kristian shares a sample file to assist in your confusion https://bit.ly/2OsGiwk. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

A number of people say that Join Tables are too complex and totally unnecessary but they don't have to be! We’ll try to help educate you on some relational database techniques and hopefully make join tables a little less complex. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

We heard the cries for an inspector for Windows and looked around for help. Recently we found Firebug, but that only works if you install it on the same domain. Our search continued and we found DebugBar, an extension for Internet Explorer and it still works in Windows 10, so we worked on an integration into FileMaker as DebugBar doesn't do that as is. For MBS FileMaker Plugin 10.3 we add the new WebView.ShowDebugBar function. Our plugin will look for the web view in the FileMaker window, then create a new window and host there the DebugBar component. Looks like this: We have four tabs there. The first one allows you to inspect the DOM and you can use the green …

Did you know you can use XML functions in MBS FileMaker Plugin to split your Database Design Report XML files into smaller XML files and put them in a GIT repository? First you can use FM.RunDatabaseDesignReport function in our plugin to trigger FileMaker to create a DDR by script. Or you use AppleScript for GUI scripting as you can see in this older blog post: Automate creation of Database Design Reports in FileMaker. For FM.RunDatabaseDesignReport, here is an example line: MBS( "FM.RunDatabaseDesignReport"; 1 /* XML */; "/Users/cs/Desktop"; 0; "Anlagen.fmp12" ) First parameter is 1 to enable XML. Second parameter is folder path, but that is ignored on Windows o…

In this article I want to introduce you the new functions from the MBS FileMaker Plugin in version 10.3. LibXL Let's start with a few innovations with LibXL, that allows you to edit Excel files. You now have functions with which you can identify the area of the table where data is filled in. You can determine the first row or column in an existing Excel document and which one is the last row or column that is filled. This simplifies your work. For example, you want to enter data in an existing table. You first determine the last filled row and then you enter the new values in the next row There is the new XL.Sheet.CellWriteTextAsNumber functio…

Now that you have one foot into deploying your first app to WebDirect, we can move on to Day Two where we finish the conversation on some of the "gotchas" that can snag beginners. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Building your first app with FileMaker Pro can be exciting. Deploying that to WebDirect can be a different experience. We’ll discuss some of the "gotchas" that can snag beginners. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

One step closer to your first FileMaker Go App! Join us as we continue the conversation on how you can do a little advanced planning to avoid some "gotchas" that usually trip beginner developers. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

How exciting, you've decided you want to access your FileMaker app on an iOS device. If this is your first FileMaker Go custom app, there may be some "gotchas" that can catch beginners off guard. We'll cover these to save you some time and headaches! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

If your FileMaker Server crashed, would you know how to handle it? In this LiveStream we go over emergency restoration considerations. Free sample file: https://bit.ly/2YIbWff. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Help! My file is getting huge because of all the records I use for charting. How can I reduce the file size and produce the same chart? Jonathan Ray explains how to build native FileMaker charts and Google charts using JSON text instead of records. Sample file: https://bit.ly/31kaQbr. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Another day, another Server configuring conversation. Join us in Day Two as we continue the basics of installing FileMaker Server with an emphasis on backups and SSL Certificates. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

We invited Darren Terry on our show to talk about the calculation dependency tree (what triggers calculations to fire). What we got was so much more than we expected. Darren’s close ties with Claris engineers and dedication to the platform has given him insight into how FileMaker works under the hood. To put it simply, both of us were flabbergasted at how much he taught us about FileMaker. Come join us in this in this "can’t miss" PodCast about the calculation engine and whatever else comes across Darren’s big brain. (Our regular guest, Marc Larochelle had this to say "You can plant an entire garden while learning about dependency trees." https://firesidefilemaker.po…

Learn the basics of installing FileMaker Server with an emphasis on backups and SSL Certificates. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Jonathan Ray shows off a Lean Design Technique - How to create “summary” fields that give you the numbers you want without the dialogs you hate. Free Sample File: https://bit.ly/3dsfYwD. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

How fast can Auto-Enter Calculations run? VERY FAST. Join Nick Hunter as he covers the benefits of auto-enter calcs. Check out the video description for a couple free sample files. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

You've already taken one of your first steps towards becoming a FileMaker expert and learned how to build reports. So what's next? Subsummary Reports! Join us as we dive into the basics of subsummary fields. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Is the FileMaker Developer Subscription (FDS) right for you? Join us as we talk about what comes with the subscription and what you can't do with it. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

View File Sign In With Apple Addendum 5 Wim Decorte and I are pleased to release another in our series of White Papers related to extending oAuth2 and OIDC to the FileMaker Platform. Addendum5 deals with the use of Apple ID and Sign In With Apple to authenticate FileMaker users. Submitter Steven H. Blackwell Submitted 07/16/2020 Category White Papers FM Version 17  

Dialing your iPhone from FileMaker Pro or Go is a niche topic, but can be a major time saver for some businesses. Calvin Mosiman explores this capability using Open URL! Free sample file: https://bit.ly/37ICEYf. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Learn how to properly summarize and total up List Views and related records in a report. We will look at the very basics, including subsummaries, and how to tune for performance. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

On the third day of the new Video Player App overview, FMTraining.TV gave to me: a technical DAPI tear down with Jacob Taylor. Follow along with the free sample file: https://bit.ly/37ICEYf. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

One day wasn't enough to cover how awesome this new Video Player is. Nick Hunter takes over Day 2 and explores complex relationships, sorcery and Lean Design. Free sample file: https://bit.ly/37ICEYf. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

FMTraining.tv’s new Video Player is pretty awesome. By popular demand, and with the help of Myles Debski, we start Day 1 of our in-depth overview of the Video Player. Follow along with the free sample file: https://bit.ly/37ICEYf. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

With users being on various FileMaker clients, you need to make sure your UI is consistent between platforms. Nick Hunter to the rescue! We’re going to unpack the conversation of making UI work between all 5 or 6 FileMaker Clients. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Hello Everyone, We’re happy to release a new accordion table solution for FileMaker. Accordion tables allow you to have expanding rows in a FileMaker layout, fulfilling a similar role as a list view or portal. These are incredibly flexible and allow you to do things like: Nest Multiple Levels of Expanding Tables Combine Data from Different Tables into a Single List Trigger FileMaker Scripts from Clicking Table Elements Fully Customizable Style to Match Your Theme Download the demo and check out the documentation to see how you can integrate accordion tables into your solution.

With next MBS FileMaker Plugin (already in 10.3pr7 to try), you are able to trigger the sharing services in macOS from FileMaker. You can pass images, URLs, styled text and native file paths to various services. Not just one value, but several, e.g. Send text and image to Messages Send files, text, images, URLs, subject and recipients to Apple Mail Send pictures to Photos application Send text and URLs to reminders or notes applications Send files via AirDrop to other users Send URLs to reader list in Safari Send PDF to Books application Send picture to make it the desktop background More services are available, for …

Learn how to radically speed up your record filtering by offloading the script to the server for processing. Super Nick will be there to guide us through our learning experience. Follow along with the free sample file: https://bit.ly/nickmay2020 Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Learn how to leverage the Let function, and the massive performance improvements it can bring to your FileMaker custom app. Free sample file: https://bit.ly/nickmay2020. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Now loading: How to Build a Progress Bar in FileMaker. Join us as we discuss how you can enhance your solution with a progress bar. Follow along with the free sample file: https://bit.ly/nickprojectsstartersolutionfixed. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Make sure the core of your FileMaker App is well organized with proper naming conventions. It could keep you out of trouble! Check the description of the video for three FREE awesome sample files. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

After watching Nick Hunter present on how to “Empower Your Searches”, we figured that we should have a basic course on the benefits of Auto-Enter Calcs. Free Sample File: https://bit.ly/nickprojectsstartersolutionfixed. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

What is Workflow Security and how is it any different than "Bad Guy" Security? Learn about what it takes to protect your FileMaker data from both internal and external threats. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Ever wonder how FileMaker compares to Excel? Or how FileMaker competes with Access or other Database Management Systems? Join us as we explore these different programs and talk about how FileMaker can be useful for your team. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Is there a such thing as too many FREE sample files? In this special FileMaker Q&A, we cover an overview of Andre's sample file. Follow along, download the sample file: https://bit.ly/3gymyV3. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

When it comes to mutli-record selection techniques, this demo will explore both basic examples and advanced examples. Follow along with this free sample file: https://bit.ly/2XyXjJC. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Can't get enough of FileMaker 19's newest Add-on feature? We have you covered! We'll take a look at the components of a custom add-on as well as other caveats about building your own FileMaker custom add-on. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

The first step in building a script is learning about the tools you have. In this video for beginners, we dive into the "If" script step and the slightly more advanced, "Case" script step. Follow along and download the free sample file: https://bit.ly/2zsf05p. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

With the last DynaPDF update we got new support for ZUGFeRD 2.0 and Factur-X, two standards to deliver invoices as PDF files with embedded XML data. We supported ZUGFeRD 1.0 before and now upgraded code to support version 2, too. So here is a little FileMaker script to convert an existing PDF into a ZUGFeRD 2.0 document. Before you start, please assemble the XML for the invoice and know whether it's Minimum, Basic, Comfort or Extended level. So the script here initializes DynaPDF library if needed and then creates a new PDF environment. We set import flags to import all content and prepare for PDF/A. If needed, you could skip some content like annotations dire…

Learn the basics of capturing errors in your FileMaker Scripts, and presenting that information to the user. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

ExecuteSQL in FileMaker is back with Day 2 and this time with a sample file! Calvin continues the conversation as we explore ExecuteSQL in FMSP's Calendar. Download the sample file: https://bit.ly/3bO6JWA Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

ExecuteSQL in FileMaker is very powerful. It 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 Function. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Makeovers can take some time and effort. UI makeovers are no different! Nick Hunter lays down design rules and guidelines and shares some important tips on slide controls and button bars. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Watch as a viewer's solution undergoes a complete transformation into a more modern UI design... in real time! Along the way, Nick Hunter will lay down design rules and guidelines, giving precious insight, reasoning and advantages behind those rules. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

On the third and final day of Nick Hunter Speeding the Search in FileMaker, we have a sample file to share with you. Download the file: https://bit.ly/nickmay2020 Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Introducing our Deploying FileMaker 19 Video Training Course! Enjoy this intro video that will lead you into the rest of the amazing 9 hours of video training on deployment. This course has topics for beginner, intermediate, and advanced users! For more information or to purchase this course, visit: FMTraining.TV [email protected] www.fmstartingpoint.com www.rcconsulting.com

Nick Hunter continues the conversation on his most advanced and powerful techniques to search records, combine multilevel filters with search, and search records from multiple related table sources at the speed of light. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Nick Hunter explains in-depth his most advanced and powerful techniques to search records, combine multilevel filters with search, and search records from multiple related table sources at the speed of light. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Introducing our Video Training Course for the FileMaker 19 Platform! Watch this introduction video that will start your journey into 60 hours of amazing video training. The course has topics for beginner, intermediate, and advanced users! For more information or to purchase this course, visit: FMTraining.TV [email protected] www.fmstartingpoint.com www.rcconsulting.com

"Insert From Device" is a FileMaker Go specific script step, which provides most of the awesome capabilities that people expect from a mobile device. This includes signature capture, barcode capture, image capture, and video capture. 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 have read the documentation about the new JavaScript integration in FileMaker 19. Let's take a look on this in detail. For every website you load, FileMaker injects automatically a little JavaScript when the page is finished loading. The JavaScript for the PerformScript script in the FileMaker namespace looks like this: As you see for MacOS (and iOS), they use the MessageHandler protocol offered by WebKit, which is the same we use for our WebView.AddScriptMessageHandler function in MBS FileMaker Plugin. The message handler is quotes the given parameters, builds a JSON text and passes this to the message handler. If you need, you can use MBS FileMaker P…

Have you seen the machine learning functions in FileMaker 19? Apple added CoreML framework in 2017 and presented it at WWDC that year. The framework allows to easily load a model for machine learning and call it with your input data. Examples include visual detection of things in pictures like image classification. Other examples include speech detection and sound analysis, text analysis or pattern matching. For example we saw models to take text and tell you the language or the mood of the writer. Also welcome are models to detect porn or violence to filter those. FileMaker 19 comes built-in with a new script step Configure Machine Learning Model to loa…

Understanding the need for continuously updating data as opposed to historical snapshots. Lookups are good for creating one-time relational links. Learn the differences and how to integrate both into your FileMaker solution. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

In Part 1, we discussed all of the tools within FileMaker itself. In Part 2, we discuss many of the external tools that are available to all developers to help their efforts. It's a fascinating discussion and we almost guarantee that you'll discover new tools that may well become essential to you and your work. https://firesidefilemaker.podbean.com/e/developer-tools-part-2/ P.S. Today we hit a huge milestone by surpassing 20,000 downloads. We are immensely grateful to all of our listeners.

The just released FileMaker version 19 brings some welcome additions to use JavaScript with web viewer. You can now use a script step Perform JavaScript in Web Viewer to run JavaScript within the web viewer on the current layout. In MBS FileMaker Plugin, we have our own WebView.RunJavaScript function since version 1.3 from July 2007. That function has been upgraded as WebView.Evaluate end of last year for version 10.0 of our plugin to provide results back on MacOS, Windows and iOS. The built-in functionality has an advantage the plugin can't provide, which is is having it work in FileMaker Go or Web Direct. But you first need to upgrade everything to FileMaker v…

During this Q&A with a twist, we look at sample files and cover multiple topics like: Portal filtering, Virtual Lists, Master Detail Layouts and more! Sample file download links can be found in the description of the video. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

View File The New Add-on Feature: Caveats, Cautions, And Nuances In an effort to raise awareness about this and to offer some recommendations about Best Practices, we are providing this document in bullet-point format for the FileMaker Developer Community. —By— Stephen Dolenski and Steven H. Blackwell Submitter Ocean West Submitted 05/20/2020 Category White Papers FM Version 19

Record Locking - Only 1 user can edit a specific record at a time. Preventing users from running into each other in a shared, hosted solution is an important skill for a FileMaker Developer in order to keep workflow going. 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 special LiveStream Q&A clip, Richard takes the time to answer some great questions on PDF generation and saving to a path 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

We have three handy custom functions for you to log function calls with MBS FileMaker Plugin: CountScriptCall LogFunctionCall LogFunctionResult And they can be used together to log function calls like on the screenshot here: CountScriptCall Now let's take a look on each function. Start of the script may just call the first two functions together in one Set variable script step: The CountScriptCall function is to check which scripts get called and how often. We can call it in each script on the start to log that this script is still in use. We use a global variable $$LogScriptCalls to turn this on/off as needed. In th…

What does it mean for a FileMaker database to be "normalized"? In this special LiveStream Q&A clip, Richard takes the time to answer this great question on database normalization and expand on the concept. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Is it possible to create so called "global" layout object? You update it on layout1, and it is auto-updates in layout2 and layout3? --- Example: I have three Contract layouts and they share the bottom part, where person sign it. I called this object as Sign. Sometimes, I add new merge fields to this part, and I have to go through all of the Contract layouts and add merge fields.

This is the weirdest thing. I use a script to produce a collection of PDF'd reports that go into a specific folder, which is identified in the script. There are 31 reports that are produced by this script. Of those, only one won't save. The error message below is for another script that is getting the same error message. That one file contains all 31 reports. I have no problems with space. I have tried different names for the file. The only thing that is a mystery to me is the part in the error that says, "unlock it." I have no idea what "it" the message is referring to. I wouldn't know how to lock a disk, and the other files were able to access the same di…

Data doesn't always have to be displayed vertically in a table. Pivot Tables are a great way to reorder data laterally on a layout. Calvin Mosiman takes apart a Pivot Table Sample and discusses it. Learn how you can incorporate this into your solution! Sample File: https://bit.ly/2W4382k Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

In team settings, digital document management can be the difference between a well organized business and workplace confusion. We cover the basics of container fields, storage of the container, performance considerations and much more about Digital Document Management. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Gents, when I evaluate ExecuteSQL in DataViewer - it is working, but when I attach this calculation to field - it doesn’t! I receive a “?” instead. Where am I wrong?

On the last of three FileMaker API Days, special guest engineer Art Sevilla wraps up the conversation on FileMaker and APIs. Download the work files: https://bit.ly/3aYTxO9 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 second of three FileMaker API Days, special guest engineer Art Sevilla expands on Day 1 as we continue the conversation on FileMaker and APIs. Download the work files: https://bit.ly/3aYTxO9 Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Gents, I have 3 layouts: Contract, Appendix 1, Appendix 2. I need to print all of them into one pdf file. Is it possible?

In the first of three FileMaker API Days, special guest engineer Art Sevilla discusses what an API is and defines terms like REST, JSON, and Postman. Download the work files: https://bit.ly/3aYTxO9 Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

This stream is for beginner to advanced users who want to learn about the proper use of pop-up lists, menu lists, radio buttons and checkboxes. We also mix elements to create multiple control styles and uses for each. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Anyone could please help me with my script? Validating the following fields: DatePaid,OR# and AmountPaid. i'd like to validate the field with Script Triggers -OnCommitRecords and with the Button(Save). I have attach my script here, problem is it seems the first "if" line is the that works.

In this two part podcast, John Mark & I, are once again joined by Marc Larochelle (CEO of Productive Computing) for a discussion about the tools that are available to FileMaker developers at all levels. This part mostly covers the internal tools and options that are available inside of FileMaker and in Part 2, we'll be discussing some of the external (commercially available) tools that could enhance your development efforts. We hope you find the discussion interesting and enjoyable. Part 2 will be released on May 20, 2020 https://firesidefilemaker.podbean.com/e/developer-tools/

This stream covers different aspects of what it takes to use FileMaker WebDirect as opposed to FileMaker Pro Advanced. Decide if the challenges and benefits weigh in your favor. Check out the future live stream schedule at: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com