Automatically remove expired data.

Hello, so Im trying to make an app where you can apply for medical leave. The user will be able to choose the date when they will started take the leave and when will it end. So the data collected will be transferred to a google sheet.  One day after the leave expired, I want the data to be automatically removed. How to do it?

0 4 197
4 REPLIES 4

Create a slice that includes all the rows to be deleted at any given time and a scheduled automation that deletes all rows in the slice.

Would you care to elaborate more? Thanks.


@xakic wrote:

One day after the leave expired, I want the data to be automatically removed. How to do it?


My reply addressed this specific question. If you're already familiar with slices and automations but encountering some challenge in using those features, elaborate your question.

If "How to do it?" actually is in reference to how to make your entire app, then the place to start is App design 101 - AppSheet Help

As @dbaum said. It is simple but u should know automation and slicing of a table