Skip to main content

Edit Table Column

Updates specific columns in table rows.

Overview​

The Edit Table Column node modifies column values for items that came from an Import Table node configured with the Lido Table source. It uses the row position information to update the correct cells in the source spreadsheet.

Use it to:

  • Update status columns after processing
  • Write calculated values back to source rows
  • Modify specific fields without affecting others

Parameters​

ParameterDescriptionRequired
Table RowThe table row item to updateYes
Column NameThe column to updateYes
Cell ValueThe new value for the columnYes
Lido Spreadsheet URLOverride the default spreadsheetNo

Table Row​

The item containing table row data. Typically use:

{{$item}}

This must be an item from Import Table (with Lido Table source) that includes columnNameToPosition data.

Column Name​

The name of the column to update. Must match a column header in the source table exactly (case-sensitive).

Cell Value​

The value to write. Supports expressions:

Processed                          // Static value
{{$item.data.calculatedField}}     // From item
{{$item.data.price * 1.1}}         // Calculated

Output​

The input item passes through with the column value updated in the spreadsheet.

Requirements​

This node requires items with position metadata from an Import Table node configured with the Lido Table source. The item must include columnNameToPosition data to locate the correct cell.

Examples​

Mark Rows as Processed​

After processing table rows:

  1. Connect after your processing nodes
  2. Set Table Row: {{\$item}}
  3. Set Column Name: Status
  4. Set Cell Value: Processed

Write Calculated Results​

Save a calculation back to the table:

  1. Set Table Row: {{\$item}}
  2. Set Column Name: Total
  3. Set Cell Value: {{\$item.data.quantity * \$item.data.unitPrice}}

Conditional Status Update​

Combined with an If node:

[Import Table (Lido Table)] → [Process] → [If: success] → [Edit Table Column: Status = "Complete"]
                                      ↘ [Edit Table Column: Status = "Failed"]

Update with Timestamp​

Record when processing completed:

  1. Set Column Name: ProcessedAt
  2. Set Cell Value: {{new Date().toISOString()}}

Tips​

  • Only works with items from Import Table using the Lido Table source (needs position metadata)
  • The column must exist in the source table
  • Use for updating source data after processing
  • Combine with Filter to update only specific rows
  • Multiple Edit Table Column nodes can update different columns
  • Access item data fields through \$item.data.fieldName