Creating Custom Functions

A custom function is a developer-defined formula that is added to the library of available functions within the database it is installed. They add custom code alongside built-in functions, acting like extensions to the file’s calculation resources. Once defined, the function is globally accessible from the formula for any field definition, interface element, or script step. Unlike regular calculation formulas, custom functions can be defined to accept parameters and can be recursive. A well-designed, open-ended, reusable custom function can reduce redundancies in formulas, simplify calculations, and save enormous amounts of development time. In this chapter, we discuss the process of creating and using custom functions, covering topics such as the following: