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.