Skip links

Extend FileMaker with plugins and custom functions.

FileMaker Plugin

FileMaker plugins and custom functionsToday, the FileMaker platform can be regarded as the most powerful Database-management system. In its current version 13, FileMaker offers an unprecedented range of functions and can be run on Mac OS X, Windows and iOS. Despite the wide range of functions, FileMaker has already been offering two powerful features for several versions that allow FileMaker's range of functions to be increased even further. Firstly, FileMaker has the option of integrating any number of plug-ins, which are available in large numbers and can extend FileMaker with countless additional functions. With the so-called "Custom Functions", FileMaker also offers the option of developing your own functions, which can be called in the formula editor like any other normal function and can also contain any parameters. In this article, we explain the differences between plugins and custom functions and show how these two functions can be used optimally together.

FileMaker plugins - old hat?

Troi pluginsOne Interface for external plug-ins has been part of FileMaker for well over 10 years. For example, the Dutch plug-in manufacturer Troi external plugins since 1997, such as the well-known Troi Dialog Plugin or also the Troi File Plugin for FileMaker. Today, external FileMaker plug-ins are available for almost every purpose - whether for displaying dialogs, controlling scanners, creating diagrams as vector graphics, creating PDF files, sending and receiving e-mails or queries via the web - there are no limits to the possibilities with FileMaker plug-ins.

MBS FileMaker pluginFor some years now, highly integrated FileMaker plug-ins have also been available, which have a very wide range of functions or can be extended, for example, by developing your own routines. For example, the MBS plugin by the German author Christian Schmitz from MonkeyBread Software now has more than 2,500 functions from a wide variety of areas. For example, the plugin allows you to send and receive (HTML) emails, SQL-Connection to External data sources, control of scanners, OCR text recognition, printer control, interface control for USB and MIDI or even the editing of images and PDF files. In addition to the extended range of functions, the plugin also offers improvements for developers: for example, the Syntax Coloring improves the readability of scripts and formulas, and the Script-editor has line numbers.

Plugins only under Mac OS X and Windows

FileMaker Plugins for Mac OS X and WindowsIt is often said that where there is light, there is also shadow. This is also true for FileMaker plug-ins, as they only run on Mac OS X and Windows. FileMaker Go under iOS and WebDirect in turn do not support external plugins. Some developers therefore refrain from using external FileMaker plugins, but often only for solutions that are primarily intended for mobile use with FileMaker Go.

For desktop solutions, plugins naturally offer a huge selection of new functions that can be used to extend FileMaker databases. For this reason, FileMaker plugins are by no means old hat, but provide unimagined flexibility in the development of FileMaker solutions. For solutions that are to be executed on the desktop as well as on iOS or WebDirect, however, it should be noted that no plugin functions are called in FileMaker Go or WebDirect. By the way, plugins are also called in Runtime-solutions that can be created with FileMaker Pro Advanced.

Custom Functions - your own workshop.

With Custom Functions, the developer version FileMaker Pro Advanced has the option of developing your own functions and calling them in the formula editor like a normal function. Any number of parameters can be used. In this way, for example, custom functions can be developed that accept a value, perform a calculation with it and return the calculated value. Frequently used functions can therefore be combined in a Custom Function and call them up in the formula editor.

FileMaker Custom Functions

Custom Functions for download

The option of implementing your own functions has been available for several FileMaker versions. For this reason, there are now a large number of custom functions available for FileMaker developers to download. Probably the most extensive and best-known archive of custom functions is the Web-Portal from Briandunning represent. However, custom functions are also provided by other sources, such as the FileMaker Magazine.

Encapsulate plug-in functions with custom functions

FileMaker plugins and custom functions can be combined perfectly for the sustainable development of FileMaker solutions. Because plug-in functions can also be called in a custom function, it is possible to encapsulate the functions of a plug-in or, if necessary, to combine them and optimize them for your own needs. The advantage of encapsulating plug-in functions is that the functions are easily interchangeable and work solution-wide even after replacement.

Imagine you have developed a FileMaker solution that uses a specific plugin in many functions and scripts. Now a new version of FileMaker or the operating system appears with which the plugin no longer works or the plugin is no longer developed further and you now have to fall back on another plugin. In this case, you would have to search your entire FileMaker solution for all places where functions of the plugin are called in order to convert them to use the new plugin.

You can prevent this tedious and error-prone work by outsourcing plugin functions to custom functions and calling the custom function in your scripts instead of the plugin function. In the event of a plugin replacement or function change, only the custom functions need to be changed and all functions will then work correctly again solution-wide.

Plugins and custom functions make FileMaker really flexible.

Even though FileMaker Pro 13 already has a very wide range of functions, it is worthwhile for developers to purchase FileMaker Pro Advanced, which offers other very helpful functions in addition to the Custom Functions, such as a script debugger or tools for creating runtime solutions or removing the administrator account in FileMaker solutions.

Plugins can be used to extend the functional scope of a FileMaker solution as required. This applies to FileMaker solutions under Mac OS X and Windows as well as runtime solutions, but plugins are not supported in FileMaker Go on iOS and WebDirect. For the sustainable development of FileMaker solutions, it is advisable to encapsulate required functions as custom functions.

If you like, you are welcome to leave your personal plugin recommendation as a comment.

Leave a comment

Share this page:

ERP software as flexible as your company.
We will be happy to advise you.

Customizable ERP software for Mac, Windows and iOS.

You are here: Extend FileMaker solutions with external plugins and custom functions.