My data updates every day, but there are about 5,500 records each day - assuming I don’t expand the site, which I would like to.
We really really really desperately need a way to delete all the records from a collection at once, or at least a more convenient way of deleting multiple records, to make this work for me.
Thanks
I agree.
Can Wix develop a more efficient way for us to delete multiple records, or all the records, from a collection at one time?
Additionally, can Wix come up with a way for us to delete collections as well?
I agree… I have over 5000 records that require deleting.
ONE AT A TIME??? Nooooo.
Hey guys,
You can select multiple rows in your collection by holding down the Ctrl key (command key on a Mac). Then just right-click one of the selected rows and click “Delete”. The image below shows you where you should right-click.
Same problem here. By the way, holding control key (on windows) select only one other row. I need a shift holding key that will select 5K entries.
If you click and drag in the left (row_number) column, you can select all the records visible on the screen. Zooming out in my browser I’m able to select up to around 50 at a time.
It’s kind of a cheesy approach, but it works okay if you have less than a few hundred records to delete. For 5,000 records, it’s still gonna be a drag.
A solution guys is to import a whole new CSV file with a different name each day and just adjust the query call in the wix code such as wixData.query(“cltDataSet1”), wixData.query(cltDataSet2"), wixData.query (“cltDataSet3”) etc . This will make your task much faster if its just text you are changing. If pictures I am not sure how to import those and have asked this specific question in the community forum.
We are facing the same issue. We are required to upload new rows every week (1000’s of them) and delete old rows (1000’s of them). We are using this for dynamic pages and so we cannot change the collection name (every week) as it results in changing the URL of the dynamic page. Any update on this thread. Any Command line option to add 1000’s of rows and delete 1000’s of rows from a collection ? Help will be much appreciated as we are now in a deadlock
See the bulkRemove() function.