Help

Customizing files with FileMaker Pro Advanced
F
ILEMAKER PRO HELP 571
• To change the way functions are sorted in the Edit Custom Function dialog box, choose a
category from the View list.
• The content of a custom function is protected even if it is set to be available to all users with
Full Access privileges. To edit or view the custom function content, you must have Full
Access privileges and be editing the database in FileMaker
Pro Advanced.
• When a custom function is deleted, it is no longer available for use. Calculations that were
using it will return an error when they attempt to call it. If you have Full Access privileges to
a database and are editing a calculation that uses a deleted custom function, the name of
the function is replaced with the string <Function Missing>.
• 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.
• If you have previously created custom functions and the names are identical to new
FileMaker software functions, the FileMaker functions will override your custom functions.
Verify your custom function names against the FileMaker functions, and change your
custom function names if needed.
• The characters $ and } can no longer be used in a custom function name or a parameter
name. If you used these characters in custom function or parameter names in FileMaker
Developer, you must rename them in FileMaker
Pro Advanced.
• You can’t use a script to copy and paste or import custom functions.
Related topics
About custom functions (FileMaker Pro Advanced)
Importing custom functions (FileMaker Pro Advanced)
Functions reference (category list)
Functions reference (alphabetical list)
Importing custom functions (FileMaker Pro Advanced)
You can import custom functions from other FileMaker files. You can also copy and paste custom
functions within a file or between files. See Using custom functions (FileMaker Pro Advanced).
When you import a custom function, FileMaker Pro automatically resolves dependencies when
custom functions call other custom functions.
To import custom functions:
1. Open the file in which you want to import the custom functions.
2. Choose File menu > Manage > Custom Functions.
3. In the Manage Custom Functions dialog box, click Import.
4. Open the file that contains the custom functions you want to import.
5. If you’re asked to enter an account name and password when the file opens, type them in
the Password dialog box, then click OK.
For more information, see Opening files protected with passwords.
6. In the Import Custom Functions dialog box, select the custom functions you want to import.
Tip You can press Ctrl-click (Windows) or Command-click (OS X) to select non-contiguous
functions, or press Shift-click to select contiguous functions.