Deleting all data in my tables

Need help Database
1

Is there a way of deleting all of my data in one of my tables?

I have a customer table that has Customer values that are in various cases (Upper/Lower), they are email addresses. I have a purchases table that was not formatted BUT they have different cases for different purchases. I am finding that XXXX@gmail.com and XxXx@gmail.com are NOT the same thing. So I’m getting tons of errors when I am trying to load the table.

What I was going to do is export my data, change the email addresses to all lower case, then re-import them. Painful but easier than correcting them one by one.

Problem is that I don’t know how to bulk erase my tables and start from scratch.

Any insight?

2

Depending on how may records you have, you might be easier to set up a workflow to change the email addresses, say 100 at a time. Or you could run an API workflow?

1 Like
3

I’m fairly new to Bubble so I am not sure how to do that. But I have 60K records so if I can set up a workflow to do that, I would do it in a heartbeat. I’d then run the flow now to do it and wait till its done before I start importing my 700K purchases.

Can you give me a bit more detail? Thanks for the quick feedback!