Share via

Custom Function Properties Dialog Box

  • Article

Use this dialog box to specify additional information and default values for your custom function. The Custom Function Properties dialog box appears when you:

  • select an existing custom function when the Toggle properties display button is selected on the Formula Workshop toolbar.
  • click Enter More Info on the Extract Custom Function from Formula dialog box
  • click More Info in the Formula Expert (in this case, the content of the Custom Function Properties dialog box is only for reference).
Name This field is only for reference. It displays the name specified when the custom function was created.
Summary Use this area to add additional information about your custom function to help identify its purpose, intended use, and so on.
Category Use this area to define a category for your custom function. Categories are a way of grouping certain custom functions; they appear as subfolders in the Report Custom Functions folder of the Formula Workshop tree view and in the Functions window of the Formula Editor dialog box.

If you want to create further levels, use a forward slash in the category definition.
Repository This field is only for reference. It displays the name of the repository to which the custom function is connected or was last connected, if any. The custom function must be connected to the repository for this field to contain information.
Display in Experts Select this option if you want your function to be displayed in the Custom Function Supplying Logic list of the Formula Expert.
Author Use this field to add the name of the creator of the custom function.
Return Type This field is only for reference. It displays the data type of the argument.
Help Text Clicking this button opens the Help Text dialog box. Use the dialog box to specify a message to help others use the function. Help text is available only in this dialog box.
Arguments The fields in this area display the definition of your custom function.
Name This field is only for reference and shows the argument name.
Type This field is only for reference and shows the data type of the corresponding database field.
Description This field lets you add an optional description for an argument. This description appears in the Formula Expert.
Default Values This field lets you define default values for an argument. Clicking a Default Values field opens the Default Values for dialog box. Default values created here can be used in the Formula Expert.

You cannot create default values for range, array, or range array argument types.

For information about creating a set of default values, see Defining default argument values for custom functions.

See Also