The way I normally handle deletions is as follows:
- I have a column in my table called “Is Deleted?” (for simplicity, I just use a number column)
- I present a “Delete” button to the users
- When a user taps on delete, I increment the value of “Is Deleted?” by 1
- I then use a visibility condition to immediately remove the item from view
In some cases, I’ll have a trigger function running in the background that removes any “Is Deleted?” rows from the GSheet.
In other cases, I’ll actually leave the row intact and include a “Deleted At” timestamp and “Deleted By” email address/user ID to identify the user that deleted the item, and when. Both of these get set in the same custom action as the “Is Deleted?” increment.