Purge the Data

[Laup20 (John Paul Armisa)]

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 (Levent Kulacoglu)]

Firstly read this:

Guide on How To Create a Community Post

Dear valuable members and users, For a long time I’m seeing a lot of multiple and concurrent posts, posts like novels seeming to aim the Pulitzer Price, exactly the same questions by the same user but paraphrased/re-phrased etc. Being a dedicated community member and an AppSheet developer who is reading around 2.5K posts per day, I urged myself to tip on some good advice and best practice BEFORE posting something in the community: #1 - APPSHEET DOCUMENTATION AppSheet has a very good help do…

@Laup20

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…

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

Actions: The Essentials

Search results for: scheduled report

Search results for: webhooks

@Laup20

…then after that i want the remove or deleted row to be save automatically in another google sheet.

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

How to create an automated gSheet backup within your app

Dear valuable members of the AppSheet Community, I would like to share and explain, how it’s possible to create an automatic backup feature for your app’s back-end. This post will cover the details of a “HOW-TO” and include: Google Sheet Structuring Google Drive Structuring Google Apps Scripting Google Apps Script - Installable Trigger Setting Part 1 | Google Sheet Structuring Step1: Add an extra tab to your back end and name it as you like i.e. Backup, Backup Settings etc. Step2: Struct…

[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 (John Paul Armisa)]

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?

[June_Corpuz]

@Laup20

what if i fill up a new data in my app does it fill on the blank row?

Nope.

[Laup20 (John Paul Armisa)]

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

[LeventK (Levent Kulacoglu)]

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

[Laup20 (John Paul Armisa)]

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