Possible To Delete Data Entry From AppSheet Without Removing Data From The Google Sheet As Well?

[anthonype]

I'm looking to see if it's possible to delete/remove a data entry from the AppSheet without removing that data from the original Sheet. I'm no stranger to custom coding a solution. I haven't come across anything in my searches to hint towards a solution. Any help would be appreciated

[Suvrutt_Gurjar]

You may want to elaborate what you mean by 

---

@anthonype wrote:

if it's possible to delete/remove a data entry from the AppSheet without removing that data from the original Sheet.

---

---

---

Have you taken a look at the security filters or slice filters depending on your need? 

Scale using security filters - AppSheet Help

Security filters: The Essentials - AppSheet Help

Slices: The Essentials - AppSheet Help

Slice row filter conditions - AppSheet Help

[Markus_Malessa]

It would seem to me that maybe you need a column true/false whether to include the data row in your Appsheet application. Then either set a security filter or use slices to show the row or not. Depending on how many rows of data need to be hidden in the app this may not be a worthwhile solution. Alternatively you could move the data row to another table that is not shown within the application itself, this would only work though if your setup allows for these rows to be stored in a different sheet.

[AleksiAlkio]

One workaround is to create your own "Delete" action button and use that. That action actually change the above proposed Y/N column's value to false instead of deleting that row itself.  Then add a condition rule to the security filter like [Column]<>FALSE.