Community Videos, Tips, & Techniques, Articles.

Years ago we added OCR functions to MBS FileMaker Plugin. We decided to go with the Tesseract engine, which was available as C++ library with an open source license. We integrated Tesseract in version 3.02 and stayed with that version for a long time. Since each version requires compatible data files, we could not easily change the library without you guys changing data files. That brings us to the version 4.11 of Tesseract. We had plans to use the new version and looked for a way to make the transition easy for our plugin users. But since the newer tesseract library exports a C interface, we can load it dynamically at runtime. This way we can give you a OCR.Load func…

Is there a sub forum on here for system architecture brain food? For example I will build a new system now and would like to have some input on the KPIs in which are On-Prem Operations have a preference for High Sierra on their workstations; due to the obvious cover flow view in Finder. I would prefer to use FileMaker 5.5 and 19 Server on linux Which versions of FileMaker will work in combination with High Sierra and FileMaker 19 Server? Is this page up to date? https://ithelp.brown.edu/kb/articles/high-sierra-macos-10-13-what-works Also do you know of any good sync between FileMaker 5.5 Server and FileMaker 19 Server? I have not yet fo…

You may know that our MBS FileMaker Plugin has functions for barcode generation and recognition. The Barcode.Detect function is based on the open source zxing library can recognize various types, but sadly not all QRCodes recently. To solve this we add support for the zbar open source library with our new Barcode.Scan function. Since the library is GPL, you have to include the library file with the application and load it at runtime with Barcode.LoadLibrary function. You may get a zbar library from the project website or from our Libs folder in download section. Our example project shows how to load the library at startup of application. On Linux you may just be able t…

Joe Martin will demonstrate how you can extend FileMaker by writing your own custom functions in Groovy or Java! Plus, we will demo how you can use ScriptMaster to trigger a scanner and scan documents into FileMaker.Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

In this Livestream, we cover digital document management with the use of Containers in FileMaker! We’ll discuss Internal versus External storage, encrypted versus non-encrypted and handing user interface buttons. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

In Day 2, Nick discusses transferring Table Occurrences between FileMaker files! Future live streams:https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Merging two FileMaker files together is a huge challenge! In Day 1 of this Livestream, Nick will begin to execute a complete transplant of one FileMaker file into another, showing you all of his tips and techniques! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Richard and Nick discuss Custom Themes and Shared Styles for your FileMaker databases! They also discuss naming conventions! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

We like to show you what you can do with our DynaPDF features in our MBS FileMaker Plugin. Please see the topics below and take a look on the relevant example projects once you downloaded our plugin. Create New PDF from scratch Start a new blank PDF and add content to it. Just call DynaPDF.Append to add a new page and then while the page is open, draw some content on it. This may involve setting color with DynaPDF.SetFillColor or DynaPDF.SetStrokeColor functions and calling drawing functions like DynaPDF.MoveTo and DynaPDF.LineTo to draw a line. With DynaPDF.Rectangle, DynaPDF.DrawArc, DynaPDF.Bezier123 and our other drawing functions, you may build complex ve…

Nick Hunter is back to show off how to juggle multiple tables in complex reports! He also discusses the advantages and disadvantages of multi-table reports in FileMaker! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Nick Hunter is back to discuss reports for advanced users! Learn to build reports using a new approach and perspective, and how to achieve your ideal report with simplicity! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

FileMaker Trivia time! Our first trial run for a JackBox Episode where we have fun, and also learn important skills with the FileMaker Platform! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

What are the mechanical advantages and disadvantages of FileMaker? We discuss what's easy and difficult to execute in the FileMaker platform on this stream! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Using our OAuth knowledge from the previous livestream, Joe Martin is here to take us on an in-depth tour of the fantastic 360works email plugin! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Have an Excel file you want to convert into a FileMaker one? Richard discusses the complexities of dragging and dropping your excel file onto FileMaker, and what to do with converting multiple related tables! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

With Claris FileMaker 19.3.1 you can install the MBS FileMaker Plugin 11.2 for the Data API process. To install our plugin manually, just copy the plugin to /FileMaker Server/Web Publishing/publishing-engine/wip/Plugins/ folder. Then check in Admin Console to make sure you have plugins enabled for the Data API. The Admin Console doesn't list plugins for Data API. If the plugin is not yet available, you may need to restart the wip process or the whole server to recognize the new plugin. The exact location is for macOS: For Windows: And for Ubuntu Linux: If you have no toggle for Data API plugins in your Admin Console, you may need to get …

Jacob and Richard are back to discuss more advanced database crash restoration techniques in FileMaker! In this Livestream they discuss log analysis and how to deal with split container data restoration scenarios! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Today Jacob and Richard cover emergency restoration procedures! How do you safely restore your database from a backup after your server crashes? Learn how to here! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Want to know how OAuth works? Thankfully Joe Martin from 360Works has you covered! This one-day extravaganza will bring you up to speed! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Nick Hunter is back to discuss the "Copy Record/Request" script step and how to use it to your advantage! We also take a look at setting up a database for archiving (instead of deleting records) without adversely affecting your performance! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Recently a client contacted us for a problem they have. A solution hosted via FileMaker Server with Web Direct shows a layout with a container. Users can click on a button to upload an image, which uses Insert from Device script step. But if the user has an iPhone, the uploaded image may be an HEIF one. The High Efficiency Image File Format is great to preserve images in high quality, but other tools may not be able to read it. And we run into the problem, that the container is marked to be of type JPEG, which confuses other scripts (see Container.GetTypes function). Here is a script to look on the inserted image and convert it to PNG with our Container.ReadIm…

Do you have a customer still on FileMaker Server 14? Are you stuck on FMS 13? In this Livestream, we discuss the ins, outs, and pitfalls of upgrading your server across several versions at once! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

We're back with more Anchor Buoy relational design! In Day 2 of this Livestream, we do a deep dive into what "context" means and how it affects your relationship graphs in FileMaker! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

In this Livestream we discuss our new performance videos! We have taken 20 years of Devcon sessions and created one coherent set of performance videos for Beginners through Intermediate developers! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

We saw a presentation at dotfmp conference from Philipp Puls about him storing his custom functions in a table inside the database. With help of one custom function in FileMaker itself, he can run them all. This dispatcher function would use execute SQL functions in MBS FileMaker Plugin to query the expression by name, then add the parameter inside and evaluate it. Quite convenient to have all custom functions stored in one database. Based on that idea we developed two new ways at MBS to do custom functions in JavaScript and later without. Custom Functions in JavaScript Since MBS FileMaker Plugin comes with a built-in JavaScript engine, which works without web viewe…

In FileMaker 19.2.2, Claris has made HUGE improvements, specifically for intermediate and advanced level developers! In this Livestream, RCC staff highlight and discuss all these fantastic additions! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

In this Livestream, we're discussing containers! Discover the different ways to optimize your external container data storage on the server side, as well as how to do a "split" container data setup! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Our special guest this episode is Bob Shockey, one of the FileMaker™ communitys best known developers. Bob came on to talk about Process Driven Design but, as usual, we went off in tangents for a fascinating two hour conversation from somebody who has an enormous depth of experience and knowledge https://firesidefilemaker.podbean.com/e/a-shockey-to-the-system/

https://youtu.be/e_kuNITZ5SI Jacob and Richard are here to discuss the FileMaker Server Data API, or DAPI! Today they walk through basic integration with DAPI and how to use RCC's PHP-based Data API library! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Every Monday to Friday, I have an open Zoom session from 9am to 10am PST to answer questions about NautilusFM or chat about all things FileMaker. https://zoom.us/j/3033031234

NautilusFM - A framework for FileMaker™ Stupidly simple, ridiculously powerful - in just over 2 minutes https://youtu.be/lMa7hgzdgWw

For dotfmp 2021 we present what is new this year in MBS FileMaker Plugin: MBS FileMaker Plugin, June 2021 News (English) 36:32 minutes Watch on Youtube Subscribe to our podcast feed Some links for the video: 00:00 Welcome 01:08 Introduction 05:29 SharingService functions 06:10 Apple Silicon 07:20 Linux 07:47 WebView functions 08:40 CLibrary functions and CFunction functions 09:22 Audit functions 10:12 CURL functions 11:44 Encryption functions 12:26 Java functions 13:04 Toolbar functions 14:21 JSON functions 16:07 TextView functions 16:48 Versiontra…

"Same procedure as… nearly every year": Right in time for #d21: The new FileMaker Icon Replacements https://herrfriedrich.com/goodies

Below are details of the first three scheduled NautilusFM Workshops Times: Wednesday May 26, 2021 08:00 PM Madrid (11am PST) Tuesday Jun 1, 2021 08:00 PM Madrid (11am PST) Tuesday Jul 6, 2021 10:00 AM Madrid https://us02web.zoom.us/j/3033031234 Please let me know which one you plan on attending? To do so, just hit Reply and give me the date that you want. If there are too many people signed up for any one of them, I’ll schedule another one The starter file (NautilusFM_Shell) can now be downloaded from: https://www.dropbox.com/s/0sft9rsrxp8tuzm/NautilusFM_Shell.zip?…

https://michaelrocharde.medium.com/if-you-never-leave-home-how-can-you-ever-get-lost-c2fab6fa742d

Join a completely FREE one-hour workshop with Michael Rocharde to learn the fundamental principles of NautilusFM, the single screen FileMaker solution/framework that has been released under an Open Source license (BSD) and which has already been downloaded in 38 countries. All you have to do is register at: www.nautilusfm.com

For our MBS FileMaker Plugin we have the first linux only function: SystemInfo.LinuxSystemInfo. This function provides some system information for Linux and returns it as a JSON block. You may query such a block regularly and do your own decisions based on the numbers, e.g. only do something on the server if load counts are small. Or you may check how much memory is available on the computer. Let's look in the values. First the UpTime value shows how long the server is running already, in our example 708 seconds, which is about 11 minutes. The loads array gives you the load averages for last 1, 5 and 15 minute. The load value is how many processes had to wa…

Confused on how you should set up your relationships in FileMaker? In Day 1 of this Livestream, we slowly and methodically cover Claris' officially recommended relational design process, Anchor Buoy! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

We're back with day 3 of Nick Hunter's discussion on reporting for beginners! In this final day, Nick goes over more advanced techniques and shows off what more complex reports are capable of! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

https://firesidefilemaker.podbean.com/e/learn-something-every-day/ Including our regualr guest, Marc Larochelle, all 3 of us have extensive experience in the FileMaker training market including teaching classes, creating videos, writing books, speaking at conferences and much more. Whether you are a student or a budding trainer, this fascinating discussion about all things training will help you become a better trainer or student. Come listen as we discuss so many different aspects of training, it’s impossible to list them all here.

We're back with Day 2 of reporting with Nick Hunter! This stream discusses techniques to improve the readability of your reports! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com

Watch Nick Hunter as he discusses reports for beginners! Learn how to avoid making serious mistakes right out of the gate and improve your reporting game! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Berlin, 19. April 2021 - herrfriedrich.com, a long-time FileMaker Certified Developer and Claris Platinum Partner is pleased to announce that registration for dotfmp.berlin 2021 is open and can be accessed here: https://dotfmp.berlin dotfmp.berlin is an effort of various European FileMaker Developers and takes place in Berlin, Germany each year starting at the first Thursday in June. dotfmp.berlin is a 3 Day-Unconference and as such by definition an informal and self-organized effort to meet on a personal base. It is meant to bring all kinds of higher level developers together to share knowledge, educate and challenge each other. And to have a gorgeous time at a s…

Learn how to use Cross Reference Tables to improve your scripts and your database speed! Future live streams:https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Join Nick Hunter as he discusses Cross Reference Tables in FileMaker! For the first day he discusses the why, when, and where of using Cross Reference Tables! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.fmstartingpoint.com

On Thursday, April 29, my friend and speaking coach, Al Jensen, is putting on this webinar, at my request,. specifically and specially for the FileMaker™ Community. https://on.zoom.us/ev/AGDuLn5sN3sKNxoKIo-Fkdnw7MwhtMri6LGeFYY5_f-50fI3MVWG5LE2BgNexE8MorpB_Os I'm always looking for ways to improve my presentation skills and being able to communicate effectively to groups of any size is an essential asset for any developers who want to stand out from the crowd. Sign up today, seats are limited.

David Knight is one of the FileMaker community's best known developers, running a successful consulting firm, speaking at DevCon and holding a board member position at the Chamber of Commerce in Burbank. Listen as we explore how David started his business from scratch and ended up as one of the most successful FileMaker development firms in the world. You might be surprised how he started his career in the FileMaker market and how it could spur you to think outside the box like David. And, did we forget to mention he helps manage the largest FileMaker developers group in the world? There’s so much to summarize from this chat so let’s just let the PodCast do the talking. …

A brief explanation of relationships. This video is for newbies/intermediates to FileMaker™ and is the 3nd in a series explaining key concepts in an entertaining and easy-to-understand way. (Part 2 of this video will be released shorly).

It's another Dead Bird Friday - more Q&A and more free sample files! This time, Richard discusses FileMaker Server backups and how to deal with crashed files! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Jesse Barnum from 360Works joins the stream to spotlight their Safety Net product and give us a demo of how it works with your FileMaker Files! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

When using MBS FileMaker Plugin, you may need to combine a lot of functions together to get some work done. That makes our toolbox of functions so flexible to use for your needs. Let us show you four examples: Regularly import files from hot folder First you start with Schedule functions to run a script regularly every few minutes in FileMaker Pro. Independent of SetTimer script step, so you can have multiple of them. You look into a file path with Files.List to get a list of file names in the folder. By using our List functions you compare the current file list to the one from last run. For example List.And would find similar files in both files, …

Performing searches on the web, on the operating system or in your FileMaker file can be slow! But it doesn't have to be that way. Join Nick Hunter as he discusses the Search function on an advanced level. Future live streams:https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Performing searches on the web, on the operating system or in your FileMaker file can be slow! But it doesn't have to be that way. Join Nick Hunter as he discusses Searches and Relationships in FileMaker! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

FileMaker novices learn to make HIGH PERFORMANCE relational database with the assistance of this manual! https://amzn.to/3w8PqLk

Performing searches on the web, on the operating system or in your FileMaker file can be slow! But it doesn't have to be that way. Join Nick Hunter as he breaks down the Search function! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Explore our new add-on manager, pre filled with some useful FileMaker add-ons from Kristian Olsen! Day 3 discusses the six elements of making an add-on and an in-depth look at slide tabs! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Explore our new add-on manager, pre filled with some useful FileMaker add-ons from Kristian Olsen! Day 2 discusses Developer Mode and sharing add-ons to Wolfpack! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Let us show you a few things to use in MBS FileMaker Plugin and add to your solutions quickly today. Give your users a few new possibilities. From easy to complex, you may be able to copy a few scripts and adjust them to your field and layout names and get instantly new functionality for your solution. Let us show you a few things related to container fields in your solution: Continuity Camera If you have containers fields on a layout for images or PDF containers, how about adding a little button next to the field to let the user take a picture with their iOS device and insert it to the container? The button may be hidden, if it's not FileMaker Pro on a Mac. But …

The recording of the MBS Plugin presentation from FMDiSC meeting from 12th March 2021: FileMaker Developers in Southern California (English) 55:08 minutes Watch on Youtube Content 00:00 Introduction to developer goodies and syntax coloring. 30:30 fmSyntaxColorizer database 35:50 FileMaker Snippet Storage database 36:40 Script WorkSpace Context Menu Commands database 39:20 JSON functions like JSON.Colorize 41:00 XML functions like XML.Colorize 42:40 WIA functions, DynaPDF functions and GraphicsMagick functions together. 44:40 OCR functions and DynaPDF functions together 45:30 R…

When you use our MBS FileMaker Plugin, you will make a lot of calls to the plugin. Most will succeed, but some will fail. Do you notice when something fails? IsError function We see a lot of clients coding without checking for error state. But not all function calls succeed and our MBS FileMaker Plugin keeps a last error state for you. Even on server with multiple scripts running in parallel, we keep an error state per script. You can query it with MBS("IsError") to see if the last function call returned an error. You may do an error check each time you call a function with an If script step and handle the script. You may even write a log entry in a text fi…

Explore a new add-on product that is a package of useful FileMaker add-ons with Kristian Olsen! Day 1 will discuss how to use WolfPack and unveil its capabilities! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

'Transfer of Found Set' is an essential tool to have in your arsenal! In day 2, Nick discusses searching in related records and how important the transfer of a Found Set is with PSoS! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

'Transfer of Found Set' is an essential tool to have in your arsenal. In this first day, Nick defines found sets and discusses different found set techniques! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

In this article I want to introduce you the new functions from the MBS FileMaker Plugin in version 11.1. Archive With the new Archive.CompressContainer function you can compress the content of a container into an archive. In the parameters you can specify in which format your archive should be. The following formats are available for this purpose: 7zip, ar, arbsd, argnu, arsvr4, bsdtar, cd9660, cpio, gnutar, iso, iso9660, mtree, mtree-classic, newc, odc, oldtar, pax, paxr, posix, raw, rpax, shar, shardump, ustar, v7tar, v7, warc, xar and zip. Then you can additionally specify a filter at e.g. for zip format it can be store or deflate. We also need to specify the desti…

Let us show you a few of the new features in the version 11.1 of our MBS FileMaker Plugin: MBS FileMaker Plugins 11.1 (English) 17:23 minutes Watch on Youtube Some links for the video: 00:15 Installation 00:50 Preferences dialog 01:30 RegEx.DataDetector 02:30 QuickLook functions with new Markup 06:00 EPC Barcode project and Barcode functions 07:20 Enhancements for Calculation Dialog 09:00 Enhancements for Custom Functions Editor 12:15 Enhancements for Debugger Please do not hesitate to contact us if you have questions.

Richard and junior engineer Andy discuss vertical charts! Andy shows off his demo he’s worked on to explore the various charts usable in FileMaker! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

A brief explanation of primary keys. This video is for newbies/intermediates to FileMaker™ and is the 2nd in a series explaining key concepts in an entertaining and easy-to-understand way.

It's Day 3 of discussing PSoS with Nick Hunter! This video discusses fine-tuning your PSoS scripts and how to export records on the server! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Time for Day 2 of covering PSoS with Nick Hunter! For the second day, we talk about actually building a PSoS script, how to debug it, and when you should use it! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

In this 3-day Livestream, Nick Hunter discusses the ins and outs of PSoS! In this session, he covers PSoS from a beginner's perspective! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

It's an open Q&A with Nick and Richard! This time they discuss pie charts, donut diagrams, and more neumorphism questions! FREE sample file included! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Richard and Nick discuss FileMaker's latency by showing a demo file from the community as well as a bonus demo, Magnifier Glass. FREE sample files included! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Unfortunately we can't give you that new book smell through the LiveStream but you still won't want to miss this book review party! Join us as we walk through the 2021 edition of the “FileMaker Manual for Novices”. Learn more at: https://fmtraining.tv/#BOOK [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Jonathan Ray explains how to do custom FileMaker portal sorting with just a web viewer, a touch of JavaScript, and a teaspoon of magic. FREE sample file: https://bit.ly/37rgL0I. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

We may not be able to take the FileMaker Certification Test for you but we can make sure you're properly prepared to pass it! Richard wraps up the study tips in the final day of this 2-day event. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

If you are at all interested in hearing where Brad Freitag is taking Claris and how the Developer Community fits in to those plans, then you are not going to want to miss this podcast. It may well be the best use of 75 minutes in your professional life. https://firesidefilemaker.podbean.com/e/a-conversation-with-brad-freitag-1614645756/

For a few years we have worked on integrating the LibXL library and making functionality available for FileMaker. Beside all the standard built-in features from LibXL to read/write Excel files, we have some extra functionality developed ourselves: Copy Cells LibXL comes with a copy cell command, see XL.Sheet.CopyCell. Beside that we added XL.CopyRow to copy content of a row. Similarly XL.CopyColumn copies a column. As you can pass different book reference numbers, you may even copy from one document to another one or copy from one sheet to another sheet within the same document. The XL.CopySheet function can copy the content of a sheet to another document, great…

Just when you thought tests were a thing of the past, the FileMaker Certification test comes along. Not to worry though, we're here to make sure you're properly prepared to pass it in this two-day event! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Calvin joins us to give alternate techniques for filtering value lists and sorting a dynamic value list in a custom order. But wait there's more! Check out the description for a couple of FREE sample files! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

This video explores ways to get around FileMaker web viewer limitations! Learn about Headless Chrome - an awesome service that allows your web viewer to work with older versions of Internet Explorer! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

It's another Dead Bird Q&A with Richard Carlton! If you want some free sample files, or you're curious to see if someone has the same questions as you do, give it a watch! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Richard discusses the latest and greatest happenings of the FileMaker platform! He also fields questions about installation, upgrading, and purchasing! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

You may have seen the earlier blog post about Custom Function Tools for FileMaker Pro. Once we showed this to people, we got a few ideas and one request was to include those buttons for the calculation dialogs in FileMaker in various places: As you see we added a white box for the result and put a place holder text inside. And we had to do code to dynamically look for what controls FileMaker places there and measure their size to place our box between controls on the left and controls on the right. Let us know if we got it wrong in your FileMaker version or language. Check 11.1pr4 to try this feature. Looks like the features work even in lots of older FileMaker …

Today we're covering the PerformScriptWithOptions JavaScript function with Calvin Mosiman. Learn about this new option for calling a FileMaker script from a web viewer! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Did you know that iOS 11 introduced a feature to markup images and PDF documents right into the iOS system software? A client asked for adding annotations to a PDF right on the iPhone or iPad with their custom FileMaker iOS SDK based application. We through first to use our PDFKit or DynaPDF functions. Those can do things like merge or render PDF documents. And DynaPDF has quite a few functions to create annotations via script. Great if you automatically want to do things, like adding clickable links via script. (see older blog posts). But this is all via script and the user wants to annotate manually with his finger (or a pencil). Recreating all the markup tools with …

With latest pre-release we added the WebView.SetInternetExplorerHiDPI function to switch on the HiDPI aware more for FileMaker application (or runtime). See comparison picture: In your start script you can just call this function once to enable it: MBS( "WebView.SetInternetExplorerHiDPI"; 1 ) When this option is active before web viewer is created, the web control will display the content high-dpi aware and zoom to 100% independent of the DPI of the display. In earlier blog post we recommended to use JavaScript to zoom the website: MBS( "WebView.RunJavaScript"; "web"; "document.body.style.zoom = \"200%\"; ") But this is no longer needed on Windows o…

It's our final day of UI/UX design with Nick Hunter! This extra long session covers Card Style Windows, limiting the role of your layouts, and how to think outside the box with FileMaker! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

When using other development tools, we frequently have a feature to inspect values for variables or fields. Just move the mouse over the variable or field and see what's inside. This is very convenient for debugging a script to quickly see values, especially if all the local variables and object properties don't fit a single variable viewer window. We got an idea for FileMaker. The macOS NSView class allows an application developer to register a function to provide a tooltip on demand. Instead of filling tooltips earlier, you can later decide on the value and generate it on the fly. To implement tooltips, we register for providing tooltips. When you move mouse …

You may have seen Safari, Mail, Notes or other applications highlighting information in some text and they may offer to do something with the data, e.g. take a date and make a new event in your calendar or take an address and add it to your contacts. Have you wondered how this works? Apple provides data detectors in their frameworks to identify those data bits. We just added a new function RegEx.DataDetector to use those in FileMaker. While you can do a lot with regular expressions yourself, these pre-built detectors are convenient to use as they are. Here is our new function: MBS( "RegEx.DataDetector"; CheckingType; Text ) You tell what to look for, either…

We're back with another day of Nick Hunter's UI/UX livestreams! In day 9, Nick discusses the Find functionality in FileMaker, dedicated Find layouts, dealing with Finds in related tables, and much more! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Starship Captain Nick Hunter is back to tell you how to get your UI design federation approved! Learn how to deal with navigating through layouts; the advantages of the hamburger menu; and how to get your design to the next gen...I mean, level! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

It's another day of Nick Hunter's UI/UX tips and tricks! Learn about planning your UI, adding mandatory fields, and simplifying your interface! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

We're back with Day 6 of this FileMaker UI/UX event with Nick Hunter! We hope that with each LiveStream, you get one day closer to achieving your dream interface! Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

We were honored to be joined by the most influential person in the FileMaker community, Brad Freitag, Claris' CEO. It was a very open and interesting discussion and Brad shared his vision for FileMaker moving forward as well as part that the developer community have to play in this new, but familiar, sandbox we call home. You won't want to miss listening to this one.

https://firesidefilemaker.podbean.com/e/can-you-hear-me-running-faster/ Our guest today is Nick Lightbody from the UK, who you may not be familiar with but, behind the scenes, Nick has had and continues to have enormous influence on the work we do, because he is intently focused on getting FileMaker to perform better and faster. In Nick's words "Performance is the most underdiscussed subject and yet it is the object of most complaints." In this fascinating discussion, Nick talks about the work he does and its implications, and it will give anybody who listens some really powerful strategies for having your solutions work better and insights on things that w…

Congrats! You made it half way through this FileMaker UI/UX event! On Day 5, Nick teaches how to deal with lists and how to properly give feedback to your users. Future live streams: https://fmtraining.tv/#LIVE [email protected] www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com