Skip to main content

Add Row

Adds a new row to a table with specified values.

Common Properties​

  • Name - The custom name of the node.
  • Color - The custom color of the node.
  • Delay Before (sec) - Waits in seconds before executing the node.
  • Delay After (sec) - Waits in seconds after executing node.
  • Continue On Error - Automation will continue regardless of any error. The default value is false.
info

If the ContinueOnError property is true, no error is caught when the project is executed, even if a Catch node is used.

Inputs​

  • Table - The input table to which the row will be added.
  • Row - The values for the new row to be added.

Options​

  • Output Type - Specifies whether to pass the table by reference or by value. Options are:
    • Pass By Reference
    • Pass By Value

Output​

  • Table - The resulting table with the new row added.

How It Works​

The Add Row node adds a new row to an existing table with the specified values. When executed, the node:

  1. Validates that the input table is not empty and is valid
  2. Checks if the table is a reference table and handles it appropriately
  3. Validates that the row data is not empty
  4. Adds the new row to the table
  5. Returns the updated table

Requirements​

  • A valid input table
  • Valid row data to add to the table

Error Handling​

The node will return specific errors in the following cases:

  • Empty or invalid input table
  • Empty row data
  • Invalid table structure

Usage Notes​

  • The Output Type option can be set to "Pass By Reference" for handling large datasets more efficiently
  • The new row will be added to the end of the table
  • The row data should be provided as an object with keys matching the column names of the table