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)

[Jarmizee]

Hello guys, 

            As far as record deletion based on that task method, if there is an attachment on with that record. Will it delete those files as well? We want it to delete the record and any files that are linked to keep the storage utilization at the minimum. Please advise. Thank you!  

[Tubby]

On 5/19/2023 at 8:58 AM, Jarmizee said:

Hello guys, 

            As far as record deletion based on that task method, if there is an attachment on with that record. Will it delete those files as well? We want it to delete the record and any files that are linked to keep the storage utilization at the minimum. Please advise. Thank you!  

No. It will not delete files as the record itself does not contain the file but rather only its path. It will just be kept in All Assets > Files. If you want, you can try requesting Orphan File Cleanup. This deletes any Files that are not associated in any tables or objects.  Here is an article about it:  https://howto.caspio.com/files-and-images/orphan-file-cleanup/