Jump to content
  • 0

Delete Record After a Period of Time


Question

6 answers to this question

Recommended Posts

  • 0

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.

Link to post
Share on other sites
  • 0

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. 

image.thumb.png.f39f3f2732b09a62026e304e674bb205.png

 

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:

image.thumb.png.777838a6aa8d03fa308e61a9653d9c90.png

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

Link to post
Share on other sites
  • 0
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. 

image.thumb.png.f39f3f2732b09a62026e304e674bb205.png

 

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:

image.thumb.png.777838a6aa8d03fa308e61a9653d9c90.png

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)

Link to post
Share on other sites

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.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...