Action: Write to one or more fields

Modify or populate one or more fields of an existing row on the fly.

Prerequisite

Detailed steps

1️⃣ Add the action

Click + then select Write to one or more fields.

➡️ Choose → Write to one or more fields

1️⃣ In Value: enter a fixed text or

2️⃣ In Field: select the field to be modified.

3️⃣ For multiple fields, click on + Add field.

Or delete with the icon:

Insert a dynamic value in the field, type the '$' character.

Select the desired column in the table or linked table.
The dynamic value is inserted automatically.

Or combine the two, this allows you to contextualize your models with specific data from your table.

Example: [$Field] or concatenate the two: a dynamic value + text: [$field1 - test]

In an automation, you can insert a dynamic value in a date field.

now (French: maintenant) automatically inserts the exact date and time when the automation is executed into a field of type date.

When you modify a status (or any other trigger field), you can:

Automatically fill in a date field with the exact moment of the action.
Ensure event traceability, without relying on the "last modified" field, which may be updated too late in some cases.

This guarantees precise timestamping of changes in your workflows.

➡️ Validate and activate the automation

Test it: the field(s) will update immediately after the trigger fires.