Table Update

Update rows in a workspace table.

Type

table.update

Block Tool Table

Foldertable

Channels

Any

Pipe

Value

Scope

Any

Table Update changes existing rows in a table. Target one row by Row ID, or match rows with By Query. Only the fields you map are written.

Configure

Setting	Description
Table	Workspace table to update (required)
Mode	By Row ID or By Query
Row ID	Shown in By Row ID — the row to change
Filters	Shown in By Query — which rows match
Update One / Update Many	Shown in By Query — update the first match or every match
Fields / Field values	Columns to change and their new values

Handles

Handle	Role
In (target)	Incoming connection
Out (source)	Continues after the update

Pipe schema

The next block reads this on the data pipe (pipe.value). The value is an object:

Key	Type	Description
`success`	boolean	Whether the update ran
`matchedCount`	number	Rows that matched the target
`modifiedCount`	number	Rows that actually changed

Use case

Set a status after Request Approval.
Patch fields collected from Request Information onto an existing row.