Chapter 7. Custom Functions Primer

Custom functions are without a doubt one of the most powerful features in FileMaker; we cannot advocate their use strongly enough.

Simply described, custom functions become available in the calculation dialog as additional functions for use within expressions. They are snippets of code that, just as FileMaker’s pre-established functions do, accept parameters and produce output. One example might be

    fnCommission (unitPrice; quantity; discount)

This function would then presumably return a dollar amount based on some formula that multiplied unitPrice and quantity, subtracted a discount from the total, and then applied a percentage or some internal factoring to arrive as a sales commission.

Note that as a developer ...

Get FileMaker® 8 Functions and Scripts Desk Reference now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.