Update Row

The Update Row action allows you to update a row or multiple rows in a table by a given condition.

First, you need to specify the filter condition to find the row to update.

// id = 23
{{ui.table.updatedRow.data.id}}

Then you can specify the values to update, you can do it field by field:

// name = 'John'
{{ui.table.updatedRow.data.name}}

send the updated values as an Object by clicking on the JS button above the right corner of the field:

{{ui.table.updatedRow.data}}

or as plain js Object:

{
  name: "John",
  age: 30
}

This object will be sent to the server and converted to an UPDATE statement like this:

UPDATE users SET name = 'John', age = 30 WHERE id = 23

You can check the Payload section to see the actual object sent to the server.

Note: If any conditions are specified as null or undefined, they are removed from the conditions list. If all conditions are removed, it may result in updating all rows in the table if the Bulk Update setting is enabled.

Note: the unset fields will be presented as undefined and will not be used in the UPDATE statement.

{
  id: 23,
  created_at: "2022-10-21",
  // this value will not be sent to the server
  required_at: undefined,
}

You can always adjust the data before sending it.

Add additional values

const values = {{ui.form.value}};

return {
  ...values,
  updated_at: new Date(),
}

The created_at column must exist in the table schema, otherwise it will not be sent.

Change the values

const values = {{ui.form.value}};
return {
  ...values,
  name: values.name.toUpperCase(),
}

Delete unwanted values

const values = {{ui.form.value}};
delete values.age;
return values;

alternatively:

const values = {{ui.form.value}};
const { updated_at, ...rest } = values;
return rest;

Join array values

const values = {{ui.form.value}};
return {
  ...values,
  tags: values.tags.join(','),
}

Use default values

const values = {{ui.form.value}};
return {
  ...values,
  // if the value is not set, use the default value
  created_at: values.created_at || new Date(),
}

Additional settings

If you need to update multiple rows, you can use the Bulk update setting.

Note: be careful with this setting, it can update all rows in the table.