Geekless 0 Posted August 30, 2016 Report Share Posted August 30, 2016 HI All, I'm looking to create something that automatically deletes a record after a certain number of days. Essentially: If ITEM is marked as FOO, delete after XXXX days. Anyone know if it's possible to do this? Quote Link to post Share on other sites
0 ezIQchad 67 Posted August 30, 2016 Report Share Posted August 30, 2016 That wouldn't be possible with Caspio alone, and wouldn't be great design regardless of platform. Filter records that are older than XXXX days old with a view or datapage Quote Link to post Share on other sites
0 Geekless 0 Posted August 30, 2016 Author Report Share Posted August 30, 2016 So filtering is possible, just not deleting? Quote Link to post Share on other sites
0 ezIQchad 67 Posted August 30, 2016 Report Share Posted August 30, 2016 Deleting is possible, but not on a timeline like that. Filtering is not only possible, but paramount for a functional app. (I can't say deleting like that is NOT POSSIBLE, but I don't know how to do that without a lot of engineering, building, and rebuilding) It will launch your data usage through the roof, be hard to build, and adversely affect the user experience by slowing down login. Quote Link to post Share on other sites
0 MayMusic 113 Posted September 1, 2016 Report Share Posted September 1, 2016 This is possible by server-side programming. You can hire Caspio to customize it Quote Link to post Share on other sites
0 LittleMsGinger 25 Posted March 21, 2019 Report Share Posted March 21, 2019 Hi @Geekless, Just to give an update, we have a new feature which is Task. Tasks are operations that you can create in your application and run them manually or automatically based on a predefined schedule. On your table, you must have an additional field and set the DataType to Timestamp. This should stamp on Update. On your Tasks, the record will delete if Item is equal to "FFO" and Current date is equal to Item_Updated plus your XXXX days. Just like the screenshot below: You can run the task daily so it will check if the record meets the condition. For more information about Tasks, please refer to this link: https://howto.caspio.com/tasks/ Hope this helps. -kristina Becca37 1 Quote Link to post Share on other sites
0 Becca37 3 Posted March 30, 2019 Report Share Posted March 30, 2019 On 3/20/2019 at 8:28 PM, kristina said: Hi @Geekless, Just to give an update, we have a new feature which is Task. Tasks are operations that you can create in your application and run them manually or automatically based on a predefined schedule. On your table, you must have an additional field and set the DataType to Timestamp. This should stamp on Update. On your Tasks, the record will delete if Item is equal to "FFO" and Current date is equal to Item_Updated plus your XXXX days. Just like the screenshot below: You can run the task daily so it will check if the record meets the condition. For more information about Tasks, please refer to this link: https://howto.caspio.com/tasks/ Hope this helps. -kristina This example is exactly what I was needing today. So glad to find it! It would be great, fabulous, wonderful if this example could be added to the referenced How To page for Tasks as, in my opinion at least, time-based pruning of records is as common a need as sending automated emails. :0) Quote Link to post Share on other sites
Question
Geekless 0
HI All,
I'm looking to create something that automatically deletes a record after a certain number of days.
Essentially: If ITEM is marked as FOO, delete after XXXX days.
Anyone know if it's possible to do this?
Link to post
Share on other sites
6 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.