Skip to main content

Table Record

Table Record reads or changes one row in a workspace table.

Use it when process data should become shared structured data, or when the workflow needs to look up, create, update, or delete a table record.

Settings​

Action chooses what the node does:

  • Get: Look up one row.
  • Add: Create one row.
  • Update: Update one row.
  • Delete: Delete one row.

Table selection:

  • Get and Add choose a table directly.
  • Update and Delete require an upstream single-select form field backed by a table. This ensures the node targets one row.

Get Settings:

  • Filters: Combined with AND logic.
  • Filter Field: Active table column to evaluate.
  • Operator: Depends on field type.
  • Value Source: Static or Variable, unless the operator does not need a value.
  • Sort Field: Optional sort column.
  • Sort Direction: Ascending or descending.
  • No-match behavior: Either fail the node or continue without a match.

Get returns the first row after sorting when multiple rows match.

Column Mapper:

  • Used by Add and Update.
  • Each active table column can be skipped, set from a static value, or mapped from a compatible workflow variable.
  • Plain text columns can use variable-aware text templates.
  • Delete does not expose the column mapper.

Outputs​

Table Record has one output path.