Bulk Deletions

[itlopatin]

My first Caspio application is a simple search and report form with one table that I need to repopulate weekly. I figured I would delete all records in the table, then upload the weekly extract from my production database (not in Caspio). I have searched for documentation on performing bulk deletions and found nothing. Can someone point me in the right direction?

[bahar_vm]

If you want to populate it with the new data every week you can use import and replace option on the import wizard. This way the new data will be replaced with the old ones.

To delete all records also you can go to the Edit menu when the table is open and use Delete All option.

Let me know if this solves yours problem.

Best,

Bahar M.

[NailDyanC]

Hi,

Just want to update this post. Now, Caspio has a feature that can delete bulk of data or information.  Bulk delete is available in all report types, user can select any number of displayed records and delete them at once. You can refer to this link for documentation:

https://howto.caspio.com/datapages/reports/data-editing-options-in-reports/

[JolliBeng]

Hi itlopatin,

Just an additional info, you may also set up a scheduled task wherein you can periodically import a file and you can use a "Replace" action.

 

-JolliBeng