Delete Record After a Period of Time

[Geekless]

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?

[LWSChad]

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

[Geekless]

So filtering is possible, just not deleting?

[LWSChad]

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.

[MayMusic]

This is possible by server-side programming. You can hire Caspio to customize it

[cheonsa]

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]

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)