Solved: Generating file of deleted rows - Page 2

Nishit · 09-12-2022 02:42 AM

In my app I have a table called "Master Sheet". Users can delete rows from this table.

I want to manage this process better so that if any user deletes a record. I am able to know what the record was that was deleted.

I am trying to create a file everyday (using BOTS) that is generated every day using bots that lists all the deleted rows. I am generating a file because I want to look at daily/weekly data and don't want notification/email for every delete individually.

To do this I found this link related to appsheet which I have modified to meet my requirements. I am entering the following in the "Condition" field of the Event with event type as "Data Change"

AND(
  ("" = [_THISROW_AFTER].[Key]),
  ([_THISROW_AFTER].[Key] <> [_THISROW_BEFORE].[Key])
)

The problem is that it will generate a file for each delete while I want to collate all deletes done for say a day in the file. How to achieve that?

Aurelien

Hi @Nishit

I did not test such use case, but what about:

1) one bot to keep track of your deleted data:

With a data action that will have expressions such as:

 [_THISROW_BEFORE].[yourColumnToKeepTrackOf]

So you make a copy of your deleted data in another table.

2) one bot to run a report on a daily/Weekly period, on this copy_table:

View solution in original post