I created an appsheet to capture orders from our sales agents. Basically, if an agent places an order, our office staff can approve or disapprove the order, depending on the stock availability and stated price.
I would like to know if there is a way to automate (bots/process/task) deletion of rows from "order" table which have been tagged "approved" under approval status for more than a month now.
I just want the sales agents to see latest orders. Orders from previous month have no bearing for them.
Solved! Go to Solution.
Instead of deleting orders because it is historical data and unless the old orders are causing performance issues because of large number of rows, you could use the concept of slices to show only current month's orders.
Your slice filter expressions could be something like
[Order Date]>=TODAY()-30
or
AND( [Order Date]>=TODAY()-30, [Status]<>"Approved")
Slices: The Essentials - AppSheet Help
Slice row filter conditions - AppSheet Help
Instead of deleting orders because it is historical data and unless the old orders are causing performance issues because of large number of rows, you could use the concept of slices to show only current month's orders.
Your slice filter expressions could be something like
[Order Date]>=TODAY()-30
or
AND( [Order Date]>=TODAY()-30, [Status]<>"Approved")
Slices: The Essentials - AppSheet Help
Slice row filter conditions - AppSheet Help
User | Count |
---|---|
43 | |
26 | |
24 | |
14 | |
12 |