Developer’s Guide

Using FileMaker Developer features 15
1 If you do not have full access privileges and attempt to edit a
scripting or field calculation that uses a custom function that is
restricted to full access accounts, you will see the string
<Private
Function> instead of the custom function. You cannot change the
calculation when <Private Function> appears in the formula.
Creating custom functions
You must have Full Access privileges to the currently active
database to use the Custom Functions feature.
To create a custom function:
1. Choose File menu > Define > Custom Functions.
2. In the Define Custom Functions dialog box, click New.
3. In the Edit Custom Function dialog box, for Function Name, type
a name.
Custom function names have the following qualifications:
1 The name must be unique
1 The name cannot contain spaces
1 Names cannot exceed 100 characters in length.
1 Names cannot contain spaces; be sure to replace spaces with
underscores or running the parts of the name together.
4. Build a formula.
For more information about building formulas, see Help.
5. If the formula requires parameters, type the parameter name in
Function Parameters and click the Plus button.
You can edit or delete a parameter name by selecting it in the list and
clicking the
Edit or Delete buttons.
6. Click where you want an item to appear in the formula box.
7. Perform one of the following actions.
To add a Do this
Reference to a
parameter
In the parameters list, double-click a parameter name.
Mathematical or
text operator
In the keypad, click an operator.
Comparison or
logical operator
For Operators, choose an operator from the list.
Edit Custom Function dialog box
Function list
Formula box
Parameters list
Your custom parameters
appear in this space
View menu (opened)