Using custom functions (FileMaker Pro Advanced)
1.
3. In the Edit Custom Function dialog box, for Function Name, type a name for the new function.
4.
5. If the formula requires parameters, for Function Parameters, type the parameter name and click Plus . You can edit or delete a parameter name by selecting it in the list and clicking Edit or Delete .
For Operators, choose an operator from the list.
7. All accounts is the default option for Availability and allows all users of the current database to see and use the custom function. If you want the custom function to be available only to those with Full Access privileges, select Only accounts assigned full access privileges.
8. Click OK to close the Edit Custom Function dialog box.
9. Continue creating custom functions, or click OK to close the Manage Custom Functions dialog box.
1.
For Function Name, select the custom function and click Edit. In the Edit Custom Function dialog box, make your changes, then click OK.
1.
5. The custom function you copied appears at the bottom of the list. If FileMaker Pro determines this function is invalid in the context of the target file (for example, a dependent function, field, or calculation is missing from the target file or the function contains an invalid field type reference), the pasted function is enclosed in comment characters (/*<function_definition>*/). For more information, see Custom Function dependency rules (FileMaker Pro Advanced).
7. Click OK.
•
• If you do not have Full Access privileges and attempt to edit a calculation that uses a custom function restricted to Full Access accounts, you see the string <Private Function> instead of the custom function. You cannot change the calculation as long as the <Private Function> declaration appears in the formula.