Delete all rows in a table?

[S_W]

I am creating a calculator of sorts where the user picks different items along with a quantity. I am using Rollup formula to calculate the total. Is there a way for all the rows to be deleted after the user has copied the total? Here is a screenshot of what it looks like.

[Jeff_Hager]

I think I would approach the problem differently. Instead of writing a bunch of rows and then deleting them, I would do all of the work in the list of items, and have another table relate to those items to summarize them. Better to read through this and look at this example. It’s a shopping cart style app, but does the same thing and allows you to clear the cart instantly, or edit your selections and quantities.

Shopping Cart Concept for demonstration purposes

First of all, I want to say that I’m personally not a big fan of ecommerce type apps with Glide. There’s a lot of complexity to them and everybody has a different view for how they should work. Because of that, I generally don’t give advice on how to do things with them. Glide has said that ecommerce is not the direction they are focused on and I think Glide is short on some logic and functionality to properly handle the purchase and inventory side of things. With that said, I still made an …

The shopping cart was designed around the same concept of resetting multiple rows at once, but it also handles quantity as well.

Reset Multiple Rows At Once

There have been several requests for people to find a way to clear a value in multiple rows. I was thinking about that and came up with a quick example of a way to handle that. Instead of trying to clear a value in an entire column, I realized we could just change one value on a parent column, load it as a single value in our sheet and then compare that parent value to a column that we set or unset for each row. It’s not about clearing an entire column, it’s about making a value in each row n…