Skip to main content

Mutations

Insert, update, or delete records in a collection. Add it from Add Condition, Record or Action → Action → Mutation.

Target and operation​

FieldRequiredDescription
TargetYesThe collection to modify.
OperationYesInsert, Update, or Delete.

The rest of the panel depends on the operation:

  • Insert and Update show Fields mapping.
  • Update and Delete show Conditions.

Fields mapping​

Map a value to each target field. Each row is a Field (with its type shown) and a Value. The value control matches the field type — text, number, a True/False switch, a date picker, or a choice dropdown — and the + picker inserts a {{alias.field}} token.

note

On Insert, a required field with no default that is left unmapped shows Required — map a value and blocks the automation from being activated.

Conditions​

For Update and Delete, add conditions to select which records are affected. Each row is a conjunction (Where, then AND / OR), a Field, a Comparison, and a Value.

Comparison operators: Equals, Not equal to, Greater than, Less than, Greater than or equal to, Less than or equal to, Contains, Includes, Is empty, Is not empty. (Is empty and Is not empty take no value.)

Example​

Trigger: Record event — Created · Employees (alias: employee)

Action: Mutation
  Operation: Update
  Target: Departments
  Conditions: Where id Equals {{employee.departmentId}}
  Fields: headcount = {{department.headcount}} + 1