Community Videos, Tips, & Techniques, Articles.

Check out the FMTraining.tv website. Richard Carlton and his team do a daily free live stream about FileMaker to watch. And they have a huge library of FileMaker training material to watch and learn all about the Claris FileMaker product family. 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 AVRecorder functions in MBS FileMaker Plugin to get pictures from a webcam. Windows/Mac Webcapture and Webcam with MBS in FileMaker Day 2 (Webcams) Windows Image Import with MBS in FileMaker Day 1 (Flatbed Scanner) Adding…

HOnza returns to discuss performance for FileMaker Server 19.4. With extensive performance testing tools, we discuss HOnza’s discoveries and what the application of those discoveries can do for you and your customers. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

We recently added auto complete for MBS function names for 12.1 pre-release, which is really handy. Just type the component name and once you got the right one, maybe with cursor down key, you can press the dot to complete. Then you continue to type and a new auto complete list shows the function names: Watch video on our blog. Once you got function name and there is not much text following, the MBS FileMaker Plugin will add the parameter names as placeholders. You can directly put in variables with same name or enter some value there. Available or recent FileMaker versions on macOS in MBS FileMaker Plugin 12.1.

In BookIT, being able to quickly find a client and add new reservations for them is effortless. On one screen, you see all the bookings they have made, and are able to add multiple new reservations, all without once asking them to repeat information they've already given you.

A reservation management system created using the NautilusFM framework. This 2.15 video shows how trips are entered and administered, including keeping track of sales, adding itineraries and scheduled dates, all done on one home screen.

Did you know you can search styles list in FileMaker on macOS when MBS FileMaker Plugin is installed? In the layout editor in FileMaker, click on the list of styles to set focus there. Then press command key together with the F key. The search panel shows and you can enter a search term. When you press return, the next item in the list is highlighted. ⌘ F shows find bar. ⌘ G goes to next found text. This is the same search we implemented for other lists like fields, databases, accounts, privileges or layouts. Over 20 lists in the FileMaker user interface can be searched this way. For …

360Works returns to demonstrate how you can send HTML emails from FileMaker using the 360Works Email Plug-in. Joe Martin does a in-depth step-by-step walk through to show you exactly how to install and use this plug-in for your own applications. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Today we like to show you how to manually install the MBS FileMaker Plugin on a FileMaker Server. Let's start with a freshly installed FileMaker Server: Everything is off and we copy the MBS.fmplugin file on macOS to this folder: for Windows you copy MBS.fmx64: for Linux your copy MBS.fmx here: The first folder is for server scripting (scheduled and PSoS), the second folder is for WebDirect and the third one for Data API. Now we can turn on the switches for plugins. But the problem is that FileMaker doesn't notice yet that there is a new plugin. We restart the server. It may be enough to stop it, wait ten seconds till everyth…

Need your new window to pop up at a specific screen location? This livestream discusses new Card positions, how to open a picker Card next to an active field, and the window functions you need to know to accomplish this. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

In this livestream, we discussed recent patches and known issues with FileMaker Server. Topics cover included, WebDirect's known bugs, slow files, and container uploads. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

The last of the JSON webviewer widget integrations. In this livestream we show off W3 accordions, games like connect 4 and minesweeper, image cropper, canvas drawing apps, and more! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

We have even more JSON widgets to integrate with your FileMaker database. This livestream discusses widgets for date pickers, multi-step sign up forms, responsive dropdown menus, and more! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Several ways to import pictures via MBS FileMaker Plugin: Scanner 📠 🖨 Webcam 📹 💻 Digital Camera 📷 iPhone 📱 🤳 Import images from your flatbed scanner or document feeder. Quite a lot of printers now have built-in scanners to do photo copies. Record video from your webcam in the computer or from external video camera. Show preview and take pictures. Import pictures from your DSLR. Have it take a picture manually or every few sec…

Want to use the MonkeyBread FileMaker Plug-in across multiple computers for your customers? Christian Schmitz walks us through the process to auto-install the plug-in for your solutions on Mac and Windows. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Christian Schmitz shows how you can use his MonkeyBread FileMaker Plug-in to take advantage of the Continuity Camera technology found on Apple devices. This allows your database to utilize your mobile device and take pictures directly into a container field! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

For MBS FileMaker Plugin 12.1, we have new WinPhotoAcquire functions to import images from digital cameras on Windows. You can take your DSLR, take a pictures, connect it to your PC and then directly import images to FileMaker. Our functions use the standard dialogs from Windows to perform the action and give the user the usual Windows workflow. The WinPhotoAcquire.ShowSelectDeviceDialog function can show the dialog to pick the device: Then the WinPhotoAcquire.Acquire function can start the import process. If a device is not selected, it may show the dialog from above. Then it may look for what images are on the camera: Next you see a dialog to …

Some of our viewers took the FileMaker Certification test. We chat with them about how our Certification training course helped them prepare for this developer milestone. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

In this Open Q&A we discuss the future of marketing for FileMaker across the globe, Siri and AI integrations, and lingering questions regarding the Certification Training. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

We have clients with lots of custom functions in various FileMaker databases. How would you automate this to track custom functions used in various files? For MBS FileMaker Plugin 12.1 we got two new functions for this: FM.CustomFunctionsList and FM.QueryCustomFunctionsList. Those functions do a bit of GUI scripting on macOS to get the list. The user needs of course permissions to open the dialog and the menu entry into the menubar for the plugin to click. The first example script will first trigger the seconds script to run in a second. Make sure the fmplugin extended privilege is checked, so the plugin is allowed to run a script. Once that is set, we run the FM.Qu…

Day 2 of building a recurring invoice system in your FileMaker database. This time we specifically talk about nested calculations, functions, and writing the necessary scripts. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Do you have a subscription-based product? One of our coaches demonstrates how to build a recurring invoice system to help your subscription workflow. Future live streams: 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.0. WebHook We have already introduced the WebHook component in the last release. It makes the connection between devices or systems that support the WebHook technology and your FileMaker application possible. In this release we added a few more functions to support you when working with WebHooks. Our WebHook functions got a new timeout property to prevent connections staying open forever without sending a request. You can set the time for the TimeOut yourself. To do this, use the new WebHook.SetTimeOut function. The default value is 5 minutes. The time is spe…

This livestream covers build x4 of the new beta-version of FMSP. Along with covering bug fixes, Nick Hunter covers his advanced custom searches. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Not every customer pays on time. One of our Coaches covers how to create a past-due invoice system in your FileMaker database. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Our MBS Trace function will get an upgrade for the version 12.1 of MBS FileMaker Plugin: Since we now sync parameter names as metadata into our C code, we can show it in the user interface on macOS, currently planned with a tooltip on function names: We add Plugin.GetFunctionParameters function to query it programmatically and we use it to annotate our trace logs: As you see the parameter names are now showing there right in the log. We hope this helps you debug the functions. Available now in 12.1pr1.

This is Day 2 of how to integrate a wide variety of webviewer widgets into your FileMaker file. We cover custom captchas, typing speed tests, price range sliders, and more! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Kyle Williams explains how webviewers can be used to integrate cool JS widgets into your FileMaker solutions. Day 1 covers the first ten widgets as well as several webviewer questions. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

This livestream discusses MBS enhancements to FileMaker Pro on Windows. We specifically discuss new hotkeys to control the script workspace and using a library of snippets to easily add common script steps. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Nick Hunter covers the bug fixes for the new beta release of FMSP 2022. He also continues to discuss the reasons and benefits behind the UI/UX redesign. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Most people know me for FileMaker™, which I've been doing for 34 years, but I've been an adventurer, with an irrepressible sense of humor all of my life. The 90 second video below will tell you more. Part Hogan's Heroes, part Sgt. Bilko, the stories from my 6 years in the Intelligence Corps should give you more than a few laughs. I've taken a break from FileMaker™ to write them; hopefully you'll take a break to read them. https://michaelrocharde.com/army-days/

Flexible audio handling is pretty much nonexistent within FileMaker. In this livestream we show off a javascript workaround so you can still make programmable sounds for your end users. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

RCC server specialist Jacob returns to answer questions about FileMaker Server, FileMaker Cloud, and Security. We also discuss installing plug-ins on your Server and licensing caps. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

In this livestream, we discussed the concept of script trigger execution in terms of priorities, in terms of the OS, and how FileMaker will prioritize those in order of execution. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Have a client that hates to use their mouse and loves keyboard shortcuts? In this livestream, Calvin discusses how to relate records in FileMaker using auto-complete. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

In this livestream, we released the beta version of the new FMSP for early testing! Nick discusses the new navigation, his neumorphism redesign, and his design choices and tricks. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

In this livestream, Kyle demonstrated how to utilize the MBS plugin with ExecuteSQL to create, delete, and modify Tables, Fields and Records in your FileMaker database. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

In this livestream, Claus Lavendt showed us how to automate a Unbuntu server installation. He covers how his shell script fully automates installing disks for data, container and backup data! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

As you may know we have some tools in the plugin for macOS to make the live easier in FileMaker. For various dialogs to enter calculations we got check syntax and evaluate buttons. That is convenient to make a syntax check or to evaluate the current calculation in the current context to test it without closing the dialog. For MBS FileMaker Plugin in version 12.0 we change the buttons to be a segmented control with four segments to do the syntax check, evaluate and now adding and removing table occurrences: See video in our blog post. As you see we got a button labeled "+ TO" and one named "- TO". The labels may change later in case we localise …

Check out the FMTraining.tv website. Richard Carlton and his team do a daily free live stream about FileMaker to watch. And they have a huge library of FileMaker training material to watch and learn all about the Claris FileMaker product family. 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. This is the second day of our walk through of the goodies in MBS Plugin to enhance FileMaker on macOS. Monkeybread - 12 Functions for FileMaker - Day 2 Monkeybread - 12 Functions for FileMaker - Day 1 Monkeybread Plugin & FileMaker 19.4 - Q&A…

Day 2 of our MBS enhancements to FileMaker pro! This time, Christian discusses how MBS can improve your script workspace, making your coding experience that much easier! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Christian gives us a walkthrough of MBS enhancements for FileMaker Pro. The first 12 functions cover the syntax colorizer and how to use MBS to make writing calculations much easier! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

In this livestream we discuss modular scripts for searches in FileMaker. We cover one script that works with multiple FMSP modules and a walkthrough of the scripts and calculations in the sample file. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

In this livestream we discuss modular scripts for searches in FileMaker. We cover one script that works with multiple FMSP modules and a walkthrough of the scripts and calculations in the sample file. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

In this livestream we discuss modular scripts for searches in FileMaker. We cover one script that works with multiple FMSP modules and a walkthrough of the scripts and calculations in the sample file. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Kyle continues to demonstrate how to leverage this amazing function. With an incredibly detailed sample file, he breaks down how to create JSON directly from any Execute SQL query. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

The new year is starting with a week of FileMaker broadcast sessions and you can watch them live for free or later on Youtube: We start on Monday with showing FileMaker enhancements on macOS. Since we have so many, we split it in two days with introduction on first day and second day for Script Workspace. This way we have more time to explain each feature in detail. Maybe you know a few, but I bet you find a new gem here! For Windows, we could do a session, too. Since we have hotkeys on Windows and can also inspect clipboard with the XML FileMaker stores there, it would be possible to make some nice things for FileMaker on Windows. e.g. press a hotkey, show a di…

In this livestream, we discussed the Log4j Zero Day Vulnerability and how that effects the security of FileMaker. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

In this livestream, we discuss Kristian's new development tool: WolfToolbox. We show it it can create/organize syntax menu commands and how it makes working with XML much easier. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

In this livestream, we continue our discussion about the new Wolfpack add-ons. We demo the virtual tabs add-on, how to update from it's previous version, and talk about how to make your solutions more dynamic. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

A simple method to overlay a marker over an image. The marker's position can be controlled in pixel increments (approximately). Note: The demo uses the Repeat() custom function: http://www.briandunning.com/cf/942 However, the function is not recursive and can be used as a regular calculation. OverlayMarker.fp7.zip

In this livestream, we discuss our Wolfpack update! New add-ons, which include how to create a virtual list that updates in real time, how to stage data before it's committed to your database, and more. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

In this livestream, Kyle Williams covered how to best create and format your ExecuteSQL queries in a way that they will be easy to understand and work with! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Day 3 of Nick Hunter's guide to solving difficult scenarios in FileMaker with creative problem solving. This livestream, breaks down the finer details of his scheduling solution. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

In this Livestream, we continue our talk about FileMaker not having a 'function' for every scenario. Nick shows us how to solve these problems, including speeding up solutions, transforming records and more! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

We discuss the Execute DAPI script step in FileMaker. This livestream also showcases a demo file that breaks down the script step by step! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

FileMaker can solve many problems, but sometimes it doesn't have a direct solution! In this livestream, Nick Hunter shows unique ways to get around problems in FileMaker with a scheduling app. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Christian Schmitz returns to discuss Monkeybread and the 19.4 update, as well as showing off an awesome new auto-complete feature for variables in calculations! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Build a Save, Edit, and Cancel records feature the super easy way! In this livestream, one of our senior engineers shows how to implement these features using lean design! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

For a couple of years we do various things in FileMaker Script Workspace like syntax coloring. We got a copy command once we started to read all lines in a script. Later we added checks to find usage of undeclared variables, so you easier spot typos in your variable names. Now we go one step further: We scan for variables and present you a list of names we know. When you have a script open in the Script Workspace and you open a calculation dialog, you can now auto complete. Just go into a calculation dialog for a Set Variable or Set Field or any of the other script steps taking a calculation. Then type something. We have a switch there, so only when you type a $ symbol…

If you like to see the IDs for your value lists and later reference them in your scripts, check out the new option in the upcoming MBS FileMaker Plugin in version 11.6pr2 or newer: If enabled in preferences dialog or via SyntaxColoring.SetShowValueListIDs function, the MBS FileMaker Plugin will query FileMaker's ValueListNames and ValueListIDs functions to assemble the lists and show right in the table the ID. You can use FM.ValueListIDForValueListName and FM.ValueListNameForValueListID later in scripts to pick the name of a value list by ID or otherwise. Or just do the same via custom functions if you prefer that. We'll provide 11.6pr2 next week, so keep checkin…

FileMaker 19.4 has come out and it has WAY more changes than we anticipated. In this livestream, we talk about it! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Our last stream on ransomware and how to protect your FileMaker databases. Heidi returns to discuss unique and clever ways you can hide your FileMaker Server from possible attacks. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

In this livestream, we continue to discuss how to protect yourself from Ransomware. Our presenters show off how ransomware works with a simulation software called Racketeer, and how to use it to improve your own security. 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 11.5. Text Let's start with the two functions that are new in the Text functions. With the function Text.Concat we create a text that writes all texts specified in the parameters one after the other. No space is set between the individual texts. Let's have a look at the sample. We have entered the words banana, orange and pineapple in the parameters of this function. Set Variable [ $Concat ; Value: MBS("Text.Concat"; "Banana"; "Orange"; "Pineapple") ] In the dialog box we see the text we get back. The second new function is Text.List. It too w…

Ransomware is malware that employs encryption to hold a victim's information at ransom. We discuss ransomware and how you can improve protection on your FileMaker databases. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Claris had a presentation on the future of the FileMaker Platform. Richard and two of RCC's senior engineers recap and discuss. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Wouldn't it be cool if you could always see your portal totals immediately below the last used portal row, instead of having them at the bottom of the portal? www.nautilusfm.com/portaltotals

I goofed - please delete I have posted elsewhere Hey All -- I have a search script that is working - yipee - it finds invoices within a date range and displays them I want to add an additional parameter that only displays the records found that also match what the user selects from a Picklist ie. Web Orders, Catalog Orders, Phone Orders Basically, FIND all invoices in a Date Range that were Phone Orders I can't seem for the life of me to make the additional parameter work. Does anyone have a direction they can point me in? I've attached what is working, I've removed all of the code that I can't make work - any help is greatly welcome

In this livestream, Richard and Jacob discuss Azure and setting up OAuth and easy password management for your FileMaker users. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

More FileMaker server questions with Jacob. We cover preferences and file options in FileMaker, best PSOS practices, explaining database folders and folder paths, and more! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Did you know that you can extract and analyze images from a PDF file with DynaPDF? For this you can use the function DynaPDF.GetImage. In the parameters you can specify which information you want to get for an image. You can choose between the following values: BufSize The size of the image buffer in bytes. BufSize The size of the image buffer in bytes. Buffer The image data as JPEG or FILE. Picture The image as a picture container. Either JPEG or TIFF. Filter The format of image: Required decode filter if the image…

Users often need to select an item from a large list. In such case it may be convenient to make the selection process hierarchical - for example, select a category first, then a subcategory in the selected category and finally an item in the selected subcategory. A popular solution is the use of conditional value lists. However, this requires adding relationships and table occurrences to the relationships graph in order to "filter" the value lists. Plus fields to hold the intermediate selections - fields that are otherwise not required, since only the final selection matters. Plus the value lists themselves. Here is an alternative method using a card window to …

XML External Entity Vulnerability in Claris FileMaker 49 minute read A couple of months ago I looked more deeply into the “Import Records” functionality in FileMaker, especially the XML parsing, and was wondering if any XXE vulnerability may exist and how one could exploit this in technically interesting ways. The vulnerability is/was indeed there and can lead to local file disclosure and server side request forgery in various components of the FileMaker platform. The following is a description of the vulnerability including potential exploitation paths. If you’re running FileMaker Server, make sure to install patch 19.4.1 to mitigate thi…

Not sure how to catch every last mistake you make when building your layouts? MrWatson shows us how to use fmCheckMate + the fmCheckMate-XSLT library to analyze layouts instantly and thoroughly. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Richard discusses the FileMaker certification test. The focus is on possible OAuth and ODBC questions and we skim over Claris' online study guide. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

In this livestream we show off two fantastic games made with Javascript in FileMaker, and then the same techniques are used to increase script execution speed! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

It is another Monkeybread Q&A! Christian Schmitz takes on questions about his plugin and shows off a fantastic new feature! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

MrWatson returns to discuss how to use fmCheckMate-XSLT. Some topics covered include how to analyse your code, get a list of fields, get a list of script calls, and list all fields referenced in a layout! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

For Day 3 of the UI/UX in depth livestreams, Nick Hunter returns to discuss value lists and their UI in detail. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

In this livestream, Claus Lavendt revists explaining SSL and the process of installing a custom SSL certificate on FMS, the basics and not least best practice. He also showed off a new hidden feature. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

https://youtu.be/imA92obcVwc Bill returns for Day 3 of his credit cards and FileMaker series. In this Livestream we discuss FileMaker Go and Webdirect. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Day 2 of MrWatson showing us his toolbox. We converted FileMaker code to/from fmxml, changed code with search and replace, and deployed patched code to another machine. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

MrWatson introduces us to his free toolbox for FileMaker developers. On Day 1 we took a close look at fmSyntaxColorizer to see how it - with the help of the MBS-Plugin - can help find bugs in your variables, highlight code smells and generally brighten up your code. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Nowadays we live in a connected world, so web services run on different computers and sometimes need to notify each other. They usually do that with sending a HTTP request to a given URL and pass on some data as part of the URL or e.g. a JSON block as payload. FileMaker has no built-in web hook feature and with FileMaker Server you can do some things with DATA API or a custom php script on the web server part. Our MBS FileMaker Plugin in version 11.5 comes with a new WebHook functionality. You can open a receiver to listen on a port for an incoming request and trigger a script to process the query. Our plugin provides maximum flexibility as you can create listeners as…

For MBS FileMaker Plugin version 11.5 we got a few new improvements for the syntax coloring. First, SyntaxColoring.AddTag can now do formula tags with wild cards. Just define a tag with stars on beginning and end to get that color rule applied on the end over all other rules: MBS( "SyntaxColoring.AddTag"; "formula"; "*deprecated*"; "red" ) This rule would mark everything with deprecated in a formula text with red color. Great if you have fields you want to get rid off. Rename the field to have deprecated in the name and then walk your way through calculations to easily spot the field name. We got a new way to color comments in calculations. When we detect a co…

Let's discuss what the main requirements of PCI compliance are as they pertain to small businesses. Let's also chat about what must be done to ensure PCI compliance within FileMaker, as well as other technologies and platforms. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

What is the actual cost of FileMaker solutions? In this livestream we discuss licensing costs, time investment, hiring developers, and the actual price of 'FREE'. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

This livestream is the beginning of a new UI/UX deep dive with Nick Hunter. In this one we discuss the ins and outs of building an item picker. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Calvin and Richard discuss their experiences at the Pause on Error conference. They briefly discuss lambda, third-party addon sites like PentagonFM, and more! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

A client got a bit xml file from Swiss government with a list of all registered/permitted medications. A huge XML file with thousands of entries. In order to import those easily, we use our XML.Import function in MBS FileMaker Plugin. We copied the XML Import example database included with our plugin to desktop. We copied the xml file to desktop and renamed it test.xml. Then we open the database and run the script. Since we didn't change it, it will simply look for a file named test.xml and import it. Since the XML file is 50 MB, this takes a while, but the XML.Import function creates 18 new tables with a lot of fields: The example has "Import2" as prefix for r…

Day 2 of Nick's UI-UX in-depth livestream. Nick continues to show you how to vastly improve FileMaker's out of the box UI for item pickers. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

This livestream is the beginning of a new UI/UX deep dive with Nick Hunter. In this one we discuss the ins and outs of building an item picker. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Hi everyone, I want to use a webviewer to play mp3 and mp4 files but I can't manage to construct the right path to the external drive where those files are stored. I have hundreds of records each with its own mp3 or mp4, so I guess the way to access the right mp3 or mp4 from the right record would be to use the ConvertFromFileMakerPath function in the webviewer calculation. Amongst other things, I've tried this calculation: ConvertFromFileMakerPath ( "filewin:/G:/VIDEOS/"; URLPath ), but it's obviously the right approach. And frankly I'm lost as to how to construct the right path. Could anyone help? Thanks.

Day 10, CEO Kevin Miller and LiveCode's product manager, Ali, answer a variety of questions on licensing, syncing, and a host of other topics! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Day 9 of our LiveCode for FM training series. In this Livestream, we had two customers give testimonials/use cases, and Kevin Miller discussed the future of LiveCode, including a Windows and Web runtime. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Day 8 of LiveCode for FM, we discuss runtimes, specifically how LCFM allows you to create runtime applications for your Mac! We also discuss the Mac App Store and differences between desktop and mobile runtimes. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Day 7 of our LCFM livestreams. In this one, we discuss the advantages of LiveCode for FM vs FileMaker Go and the FileMaker iOS App SDK. We also chat about deployment profiles and the Apple App Store. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Day 6 of our LiveCode Livestreams, we share the public link to our submitted/posted App and discuss app maintenance, how to roll out updates and talk about data retention. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

On Day 5 of our LiveCode livestreams, we discuss the Google Marketplace, how to sign up, what software you might need to install, Google submission rules and possible problems as well as any other hangups! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Day 4 of our LiveCode series. In this livestream, we focus on the ins and outs of syncing and discuss other sync options, as well as testing vs deploying. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com