Custom Function

What is a custom function in FileMaker?

A Custom Function in FileMaker is a custom function, which is also called “custom function” in the German FileMaker version. Custom Functions a FileMaker database can be extended by any number of own additional functions. The call of a custom function is done in the formula editor just like any other FileMaker function. Custom Functions can only be created and edited in FileMaker Pro Advanced; calling an existing Custom Function is also possible with FileMaker Pro.

Custom Functions are always valid for the database file in which they were created. In a solution with several FileMaker files, the custom function must be created separately in each file if it is to be used in other files.

Creating a new custom function

To create or edit a custom function, an installed version of FileMaker Pro Advanced is required. The area for creating and editing custom functions is located in the German FileMaker Pro Advanced under the menu item [File > Manage > Custom Functions].

Dialog for creating and editing FileMaker Custom Functions

To edit an existing custom function, simply click on the function and press the [Edit] button or double-click on the desired function. To create a new custom function, the dialog contains the button [New]. In both cases, the editing window for custom functions opens:

Edit FileMaker Custom Function

The field [Function name] contains the name under which the own function can be called in FileMaker. The field [Function parameters] can be used to define any number of parameters for the function, which can be used in the custom function as a basis for calculation.

The example shown above contains a custom function to display a Google Maps map with a function in a Webwiever. The function contains the parameters [Address; City; State; Zip; Zoom], which can be used to pass the address and the desired zoom level for displaying the map to the function.

This function and all other custom functions can now be called and used in any function within the entire FileMaker file.

More questions about FileMaker? Faster is personal.

As part of our coaching and training services, we would also be happy to inform you personally about the functions in FileMaker that you need to develop your FileMaker solution. Of course, we are happy to address your individual wishes. The billing is individual and fair in steps of 15 minutes each. Pay comfortably by bank transfer or PayPal.

Related entries

Diesen Beitrag bewerten:

About Author

Markus Schall
Development of FileMaker databases since 1994, modification and extension of FileMaker solutions, conversion of FileMaker databases from .fm, .fp3, .fp5 (FileMaker 2-6) or .fp7 (FileMaker 7-11) to .fmp12 (FileMaker 12-17), interfaces to third-party systems such as online shops, CMS or other databases. Development of individual FileMaker database systems based on the gFM business framework with personal advice from Oldenburg. Operator of the online specialist portal, developer of the CRM and merchandise management system gFM-Business. Member of FileMaker Business Alliance, FileMaker Developers Subscription and FMM Expert. Winner of an FMM Award 2011, awarded by the FileMaker Magazine.