WorkFlo Designer - Set Value Node

This node is used to set a spreadsheet cell to a specific value. It allows for a configurable number of set operations with a value source and a value destination.

The value source can be one of three values: a hardcoded value, a value from a cell in the spreadsheet, or a spreadsheet address that supplies a spreadsheet address to read the value from (also known as indirection).

The value destination can be one of two values: a spreadsheet address to write the value to, or a spreadsheet address that supplies a spreadsheet address to write the value to (also known as indirection).

Indirection is a powerful capability which enables the workflow process designer to build lists of values from blockchain information. To build a list, a spreadsheet formula can be constructed to define the next position to where a value can be written, e.g. the formula ="A"&(COUNT(A1:A5)+1) will write the next value to the next available cell in column A. This list of values can for example be fed into your aggregation calculations to drive the rest of your WorkFlo process.

Properties

• Node ID

  Auto-generated node ID. Read only.

• Node Label

  The label of the node to be displayed on the workflow canvas.

• Values Count

  The number of values which need to be set by this node.

• Set Operations

  A list of field groups will be displayed with the list length defined by the Field Count property. This group of fields is used to define the set value operation.

  • Source

    The source of the value, as defined by the Source Type

  • Source Type

    The source type can be one of three values:

    • ASIS - As-is. The value configured will be written to the destination as is.
    • CAASIS - Cell Address, as-is. The value will be interpreted as a spreadsheet address and the value at that address will be written to the destination.
    • CAINDIRECT - Cell Address, indirect. The value is a spreadsheet address to be used to retrieve the spreadsheet address from which the source value will be read. This will allow a spreadsheet formula to be used to determine the source address, which can be useful for dynamic data, lists, etc.

  • Destination

    The destination of the value, as defined by the Destination Type

  • Destination Type

    The destination type can be one of two values:

    • CELLADDRESS - Cell Address. The value is a spreadsheet address and the source value will be written to this address in the spreadsheet.
    • CAINDIRECT - Cell Address, indirect. The value is a spreadsheet address to be used to retrieve the spreadsheet address to which the source value should be written. This will allow a spreadsheet formula to be used to determine the destination address, which can be useful for dynamic data, lists, etc.