Purge the Data

Laup20 · 01-04-2021 07:57 PM

Hi everyone, Im new here in appsheet can someone help me on how to automatically remove/delete the row with approved or cancelled application in master file every week then after that i want the remove or deleted row to be save automatically in another google sheet.

Thats only my biggest problem in my app created. Thank you so much

LeventK

Firstly read this:

You can do that in many ways…Actions, Workflow Rule, Scheduled Report, Webhook…

There are 2 ways to do this:

Create the backup gSheet and assign it as a source to your app and then you can use AppSheet API to copy the rows to this backup sheet before deleting with a single Scheduled Report consisting 2 actions:
Action#1 - Move records to another sheet | Action#2 - Delete the records from the source table
You can use Google Apss Script

OptimiX_XcrY

Is your end goal to just clear those rows from app ? Because there are app options so you can hide or even securely filter those rows out

Laup20

I want also to clear it also on my database. I’ve already done the deletion of data/row but the problem is this what if i fill up a new data in my app does it fill on the blank row?

JuneCorpuz

Nope.

Laup20

Is there away to delete the blank row using app i created? without deleting it on gSheet?

LeventK

@Laup20
You can create a slice with the ISNOTBLANK([KeyColumn]) conditional rule.

Laup20

Thank you so much everyone for the help much appreciated this one.