Automatically add a new row in a table using data from an existing row or fixed values.
Prerequisites
- Upstream trigger field (e.g. field modification)
- Target table and destination view
Detailed Steps
1️⃣ Add the action
Click +, then choose Add a new record
➡️ Choose → Add a new row
➡️ Configuration window
Select table and view
1️⃣ Table: Select the table where the new row will be created.
2️⃣ View: Choose the (filtered) destination view.
3️⃣ Map the fields
In the Values and Fields section, for each new field:
→ On the Value side: use $FieldName to reuse the value from the triggering row, or enter a fixed text, or even combine both: a dynamic value + text like [$field1 - copy]
→ On the Select field side: link it to the target field in your table.
4️⃣ Add a new field / value
Note: the date, selection, and link fields offer a drop-down selection list in addition to the usual entry of free text and field values.
➡️ Use the special value now
In an automation, you can insert a dynamic value into a date field.
now(French:maintenant) automatically inserts the exact date and time when the automation runs into a field of type date.
Click Validate and activate the automation.
4️⃣ Test
Run a test: the new row should appear with the mapped values.