Modify or populate one or more fields of an existing row on the fly.
Prerequisite
- Target fields.
Detailed steps
1️⃣ Add the action
Click + then select Write to one or more fields.
➡️ Choose → Write to one or more fields
➡️ Configuration window
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]
➡️ Use the special value now
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.
💡 Typical use case
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.