Skip to main content

Saved Functions

Saved Functions allow reusable JavaScript code that can be referenced in Calculated Columns and Power Scripts. To create or modify a Saved Function, go to the Administration page and click the Saved Functions icon in the navigation panel.

The Saved Functions page lists all custom functions created within the system. To modify an existing function, double-click it in the list, change the fields as necessary, then click Save.

Note: To find a function in a specific namespace, click Namespaces in the left panel to list the available namespaces, then select the one containing the function.

Adding functions​

Click the New Function button in the top-left corner to add a new Saved Function. This opens a form to enter the information needed to create the function:

  • Name - Name of the function, used in Calculated Fields and Power Scripts.
  • Namespace - Container that stores similar functions. This is the function name under a namespace as used in a script, for example informer.myFunction().
  • Description - Tells users what the function does.
  • Parameters - Values passed to the function when called. To add a parameter, click the Add Parameter button, select a data type, and enter a variable name with a label. The - icon to the right removes parameters that are not needed.
    • Sample - A sample of data to use in testing the function.
  • Function body - Procedures carried out by the function.
  • Test Results - After clicking the Test button at the bottom of the window, a sample of the function results displays based on the Sample field.
The New Function form with Name, Namespace, Description, Parameters, Function body, and a Test button, calculating a fiscal quarter for a date
A Saved Function to calculate the fiscal quarter for a given date.

Using a Saved Function​

After adding a Saved Function to Informer, it can be used in Queries. To add a Saved Function to a Query:

  1. From the Query Edit page, click the + button next to Flow Steps in the left panel.
  2. Select either Calculate Field (under Add Field) or Java Calculated Field (under Advanced).
  3. Enter the required information.
  4. Click the calculator button on the right side of the editor and select the desired function to add it.
  5. Click Done to save the Flow Step and add the function to the Query results.

See Flow Steps for more information.

A Calculated Field flow step using a Saved Function in a Query
Using a Saved Function in a Query.
Also available through the REST API
Everything on this page is built on Informer's public REST API, the same one the product uses, so your scripts and integrations can do it too. Developer reference: Functions.