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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
