Add a delete List button

[Joe_McNee]

Hi people,

I am looking to add a delete list button but struggling to figure out how.

I added a ‘add to shopping list button’ but had to do some workaround work in my sheets (image attached) so now i think i have made to difficult to create a delete list button.

I am happy for any tips or recommendations on what i can do. I am not married to the ‘shopping list’ set up so happy to change it

The above image shows that when i click the add to shopping list button it adds a cell to this sheet and then i sue the transpose formula to separate the data in the cell.

This image is a pivot table i ave created from column B in the data from the above image.

I am happy to answer any questions or pay for time if needed

[Jeff_Hager]

See if these examples give you ideas for building and modifying a list.

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…

[ThinhDinh]

@Joe_McNee

I added a ‘add to shopping list button’ but had to do some workaround work in my sheets (image attached) so now i think i have made to difficult to create a delete list button.

I’m not sure about what you have for the whole flow, but I think you can simplify it by having two Sheets.

“Shopping List” sheet: List name, Notes, List ID
“Shopping List Items” sheet: List ID, Item Name, Quantity

Then in Glide use a relation based on the list ID in the Shopping List sheet, you will be able to return a joined list of items.

If you want to delete the list, add a button in the Shopping List level that uses the delete row action, or use the delete button inside the edit screen.