Which row is deleted in automation triggered by "Row added or deleted"

[Zden-1074]

Hi, I am trying to find answer how I could identify row, which is beeing deleted when automation on table is triggered by "Row deleted" followed by action "Add row". In the context row is not value of deleted row. It is probably the new row in anbother table ... I would like to write some information from deleted rows to other record.
In summary. I have automation on table1 on delete, which have value in field [tbl1id].
When on-delete is triggered and action Add row to table2 is started, I would like to put there value of [tbl1id] to some column in tbl2, but it seems not to be existing ...
Is it possible to read values of record, which is beeing deleted from somewhere?

[Evelyn]

Hi @Zden-1074,

Thanks for your post and welcome!

Here's an older post that might relate to the issues you've been running into:

Delete row

Hello @KaiT-2f69, welcome to the community! You can delete a row in a table based on the oldest date in a given column by using the combined power of builder automations and the FINDROW function. For example: =FINDROW(Parts,"Parts[Date]=MIN(Parts[Date])") [image] And here it is in action: [2020-07-09_23-33-57 (1)] Hope this helps!

Here is an article you might find helpful, as well:
Classic experience:

Triggers & Actions

Summary An automation is a self-operating series of actions that you can configure in Honeycode. Automations can help your team to stay in sync—in real time—and put repetitive, manual tasks on autopilot. A trigger determines when an automation should start An action determines what Honeycode should do Adding automations First, open a workbook. In the left nav, click the [+] next to Automations. [Add automation] Here you will see the area where you can choose your triggers and create …

Thank you,
Evelyn