User-Defined Function Definition Window

With this window, you can configure your own custom functions to be used in calculated field, filter and find expressions.

To display this window, select the Functions from the Table Design ribbon.

To display the properties of an existing function, select the function from the Functions selector.

Options

Field	Description
Name	Use this field to specify a name for a new user-defined function (or to edit the name of an existing one). Note: The name specified here will appear in the Functions list on the Formula tab of the Filter Definition dialog, the Formula tab of the Field Properties dialog for a Calculated Field, and the Find Expression Builder.
Comment	Use this drop-down to supply comments about the user-defined function. These comments may help to remind you (or other users of the model) of important facts about the user-defined function.
Description	Use this field to provide a description of the user-defined function. This description will appear in the bottom box of the Formula tab when configuring a calculated field, filter or find expression.
Forms	Displays the return type and parameters for the form(s) of the function that you specify via the Edit Form dialog. To access this dialog you must click the Add button.
Return Type	Displays the return type (either character, numeric, or date/time) of the available form(s).
Parameters	Displays the parameter(s) of the available form(s).
Add	Click to add a new form via the Edit Form dialog.
Edit	Click to edit the selected form via the Edit Form dialog.
Delete	Click to delete the selected form.
Categories:	Use the following check boxes to specify the categories in which the function will appear in the Functions list of the Formula tab. You may select multiple boxes. String: Select to assign the function to the list of String functions. Numeric: Select to assign the function to the list of Numeric functions. Date: Select to assign the function to the list of Date functions. Conversion: Select to assign the function to the list of Conversion functions. Special: Select to assign the function to the list of Special functions. Report: Select to assign the function to the list of Report functions.
Comment	Displays the Documentation Comment dialog, which you can use to supply comments about the user-defined function. These comments may help to remind you (or other users of the model) of important facts about the user-defined function.
Manage External Functions	Displays the External Functions Library Dialog that allows you to add external models and their corresponding external functions.

Intellectual Property Rights Notice | Technical Support