🚀 Set Column Action: Alter a DIFFERENT SHEET'S VALUES!

That gets really tricky. I tend to avoid giving advice on e-commerce style apps because everybody’s app is set up differently. The problem is that there is no way to clear an entire column. I came up with a way to give the illusion of clearing a column by using setting a unique ID on a parent sheet and then setting that same ID on each item row. To effectively clear the selections, you change the parent ID, which is brought in as a single value into the products sheet, and then compared to the ID that was set on the row. If it matches, it’s a selected item, and if it doesn’t match, it’s not selected… The problem here is that you are setting a quantity on each product. My solution works great for selecting an item only once, but when you have multiple of the same item, then it becomes a whole new challenge. I’d have to think about this, but off the top of my head, you could maybe use some variation of the solutions attached below. You would maybe have to set a unique ID on each product to “select” it, but also reset the quantity if you are selecting it for the first time. I’m sure something like that could be done in a custom action. But in the end, you would also have an IF column that would first check if the unique ID on each product matches the parent unique ID. If it doesn’t, then return zero. If it does, then return your quantity amount. That IF column would be what you use to determine your quantities and amounts that get sent to your order sheet. It’s hard to explain without having a working example, but I think it would be possible. But if a user completes their order, or decides to clear their cart, then you can update the parent ID. It wouldn’t clear the quantities in the entire column, but the ID would no longer match and the IF column would return zero or blank for each item instead. That’s probably the best idea I have without sitting down to make an example app.

2 Likes