> ## Documentation Index
> Fetch the complete documentation index at: https://developers.myhero.so/llms.txt
> Use this file to discover all available pages before exploring further.

# Batch update column

> Apply a transformation to all cell values in a column. Supports operations: "set" (set all to a value), "add" (add a number), "subtract" (subtract a…

`batch_update_column`

Apply a transformation to all cell values in a column. Supports operations: "set" (set all to a value), "add" (add a number), "subtract" (subtract a number), "multiply", "divide". Works with number, money, and checkbox columns.

## Parameters

<ParamField path="tableId" type="string" required />

<ParamField path="columnName" type="string" required>
  Column name to update.
</ParamField>

<ParamField path="operation" type="string, enum: 'set' | 'add' | 'subtract' | 'multiply' | 'divide'" required />

<ParamField path="value" required>
  The value to use in the operation.
</ParamField>