Skip to main content

Process Outputs

Process Outputs define which calculated results the platform reads from the Process Logic workbook and writes back to the database after a Process…

Process Outputs define which calculated results the platform reads from the Process Logic workbook and writes back to the database after a Process runs. Each output maps a named range in the workbook to a target object, and specifies the order in which the results are written.

When the Process executes, the workbook recalculates using data from Process Inputs and any parameter values supplied at runtime. The platform then reads each configured output range and writes the records it contains to the specified object. Each row in the output range becomes one record in the database. Blank rows are ignored.


Before you begin

Ensure the following are in place before configuring Process Outputs:

  • The Process record already exists.

  • The Process Logic workbook contains named ranges for each result set you intend to write.

  • The column structure of each output named range matches the attribute structure of the target object exactly — same number of columns, same order.

  • The target objects already exist.

Although there is a standalone Process Outputs screen that lists outputs across all Processes, configure outputs from the individual Process screen to keep all configuration for one Process together.


Configure Process Outputs

  1. Open the Configuration application and navigate to Process Configuration \> Processes.

  2. Select the relevant Process.

  3. In the Process Output section, click Detail to display all available fields, then click Edit.

  4. Enter the number of Process Outputs to create and click Add.

  5. For each output:

Location — enter the named range in the Process Logic workbook that contains the results to write. This must exactly match the named range defined in the workbook.

Object Specification — select the object that will receive the results.

Output Order — set the sequence in which outputs are written. The lowest number is written first. Output Order matters when one object depends on another — for example, if you are writing both a parent record and a child record in the same Process, the parent must be written first so the child's reference is valid.

  1. Enter an Audit Comment explaining the purpose of the outputs.

  2. Click Save and Refresh.


Column and format requirements

The number and order of columns in the output named range must exactly match the attribute structure of the target object. Extra columns are not permitted. The platform is strict about data formats — see Process Logic Workbook for the required date, DateTime, number, and boolean formats.

If a record in the output range has a blank first cell, the entire row is ignored and not written to the database. This is how you conditionally exclude records from being written — use a formula in the first column that returns blank when the record should not be stored.


Special output objects

Some outputs write to special built-in objects rather than user-defined objects. The most common are:

These are configured as outputs in the same way as any other object. See Special Platform Objects for a full description of each.

Did this answer your question?