I could only delete one or several rows by highlighting them and delete. But how if i want to delete a number of rows that my screen cannot show, like, a hundred?
Hi,
If you want to delete rows one time you can manually hold the “control” button and select the rows you want to delete. Another way is to overwrite the sandbox collection from live.
If you want to repeat the deletion please clarify exactly what you are trying to do.
Thanks a lot, I think I did not mention my problem clear enough.
I know the “control” button. But what I need is more be like using “shift” to select a large amount of continues item and delete them or copy it out.
But as I tried, I was not able to use “shift”.
Hello,
Currently it is not possible to select multiple collection rows at once using the Shift key.
Feel free to post your request in our Feature Request forum .
If your site requires you to constantly manage collections manually consider adding a special admin page and write functions to automatically delete/manage records according to your site needs.
In the absence of a proper way to delete, if you have hundreds of rows of data to delete, I zoom out to 25%, this allows me to select and delete about 50 rows per time. I managed to delete 700 rows in about 2 minutes
Hi all!
It is possible to choose multiple rows in the databases (for deletion for example).
Notice that the picking is manually (with the cursor) of single lines and not for picking from x ----> z.
With PC hold your ‘Ctrl’ button.
With Mac hold your ‘Command’ button.
Try it!
Doron. 
Doron, that may not be a very good way when you need to delete thousands of rows…
Unfortunately wix does not support in this feature at the moment.
I urge you to submit a feature request here and help to make it happen!
Doron. 
There is no way to delete all records easily, so you have to highlight 2000 records at a time and delete. This is not obvious how to do because you have to trick the UI. You can do more than 2000, but it is exponentially slower.
To select many records to delete, click on the first number (1 - first column), hold the mouse button down, drag the mouse down a few numbers and hold there. Then keeping the mouse still and the button pressed, use your other hand to scroll the mouse wheel. Do this until you get to 2000 rows. Once there, release the mouse button, press and hold the Control key and click and any line number. Release control key. Then right click any highlighted number and select delete, and wait until it says loading data. Repeat for the next 2000. Its kind of silly but works.
You can probably do this using Wix Code on a special admin page. For example you can set up a repeater that you load in pages and create your own controls to select pages or selections of data to delete. Check out the wix-data/wix-dataset. remove() function. A bulk delete option would be more efficient (so worth requesting this) but this would give you more control without too much manual work.
To delete all data from a collection/database add a new page to your site, put a button on the page, set an onClick for the button, add a dataset to the page, connect the dataset to the collection that you want to delete all the data from, change the dataset from read only to read/write, and then type the below code into the code section of the new page you have created. Then preview the new page and click the button, give it a few seconds, you should now have all data deleted from you collection. (not my code, this code was written by Yisrael Hersch)
export function button1_click(event, $w) {
let dataset = $w(“#dataset1”); // or whatever name for your dataset if different
dataset.onReady( async () => {
while (dataset.getCurrentItem()) {
console.log(‘x’);
await dataset.remove();
}
});
dataset.refresh();
}
For those looking for the simple answer to this even though this post is a year old, you can delete multiple rows at a time by going into the data collection, clicking on EDIT LIVE DATA (it has to be published first) and then selecting the checkbox for each row → cntrl click → delete rows.
I copy data collections to re edit quickly and keep the same format, but sometimes empty rows get left behind leaving leftover unwanted data. Hope this helps.
this is cool and quite easy, I tried out, done in a few minutes. THANK YOU