rowData parameter

The rowData parameter represents the entire row's data (all the cell values, modifications, differences, etc.).

The rowData parameter is read-only and cannot be modified with import, export or display rules. There are two specific rules which does let you modify the rowData:

  • Export Manipulation

  • Comparison Rule

More on this later

The rowData object has some properties that can be considered stable (will never change, be renamed or removed by developers):

Property Name
Description

cells

The primary source cells as it arrives from the source

modifications

Any changes made to a row on screen of through import rules. The cell will have a green rectangle.

differences

Any values that are different to the primary source values. If Qty has a value of 5 in the primary, it is not the same as 5.0 from secondary. In the differences there will be a "Qty" : "5.0" value. The cell will have a blue rectangle.

primarySourceExportData

The data, after export rules have run, that will be sent to the Primary Data Source. You can see the exported value by hovering over a cell or opening the Cell Rules Panel

secondarySourceExportData

The data, after export rules have run, that will be sent to the Secondary Data Source. You can see the exported value by hovering over a cell or opening the Cell Rules Panel

Example

To access the rowData 's differences parameter in a script, use

if ('material' in rowData.differences)
{
  // do something
}

Last updated