I am working on an app to capture data from field technicians. Everything is sorted by Date. I only need to keep a few weeks worth of data and am wondering if I can create an action or behavior that deletes rows that are 2 weeks old.
You can use a โData: execute an action on a list of rowsโ type of action. Point it to the delete action, and use a SELECT() statement to pull in the appropriate rows keys from older records.
I thought they had added in the ability to execute actions via Reports, but Iโm not seeing it. That would have allowed you to run the action, say, once a day. In absence of that, you can run the action manually via a button press. Or perhaps setup a Workflow that runs on additions to the same table, so everytime a new record is added to the table, itโll clear out the old records.
User | Count |
---|---|
43 | |
34 | |
27 | |
23 | |
15 |