If you are looking for some ideas for handling a shopping cart, this is how I would approach it. All tracking of selected products stays within the products table. The cart is a single row shared among all users, and only the orders table has a row added once an order is completed. There is no delay a everything is contained in glide tables and uses glide logic. Items can be added, removed, and quantities update in the cart. There probably a couple of things I could update in my app, but this is generally how I would do it.
3 Likes