Edit Table Column

Updates specific columns in table rows.

Overview

The Edit Table Column node modifies column values for items that came from a Get Table node. 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

Parameter	Description	Required
Table Row	The table row item to update	Yes
Column Name	The column to update	Yes
Cell Value	The new value for the column	Yes
Lido Spreadsheet URL	Override the default spreadsheet	No

Table Row

The item containing table row data. Typically use:

{{$item}}

This must be an item from Get Table 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 a Get Table node. 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:

[Get 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 Get Table (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