# đ Set Column Action: Alter a DIFFERENT SHEET'S VALUES!
**URL:** https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342
**Category:** Project Showcase
**Created:** [November 13, 2020, 2:31am UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342 "2020-11-13T02:31:33Z")
**Posts on this page:** 9
**Page:** 5
### Author:  [@Azooga](https://community.glideapps.com/u/Azooga)
#### Post date: [September 3, 2021, 3:49pm UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/81 "2021-09-03T15:49:04Z")
Came across this post while looking for ways to delete/write the whole row (except for headers) in Glide. Does anyone know if thereâs a way of doing that without scripts?
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [September 3, 2021, 4:03pm UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/82 "2021-09-03T16:03:55Z")
If you can call an action, you can use an add row action or delete row action.
You might have to explain in more detail what you are trying to do.
---
### Author:  [@Azooga](https://community.glideapps.com/u/Azooga)
#### Post date: [September 3, 2021, 4:24pm UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/83 "2021-09-03T16:24:59Z")
Hi @Jeff_Hager
I have 1 tab with all products and I use a user-specific column that allows users to add products to the Quantity columns
Once the user places an order, I want to clear all values of this column so the user doesnât see the order/ can place a fresh order from zero again.
For context, the sum of the values (quantity and total order) are fed to the Cart tab
And by using a compound action I pass all values to the Orders sheet (which BTW was your tip to someone here in the community, so thanks đ)
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [September 3, 2021, 5:00pm UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/84 "2021-09-03T17:00:11Z")
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.
> [@Reset Multiple Rows At Once](https://community.glideapps.com/t/reset-multiple-rows-at-once/22211):
>
> 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âŚ
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [September 3, 2021, 8:27pm UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/85 "2021-09-03T20:27:00Z")
You might be able to do some sort of tricky logic that clears the quantity not upon submission but upon selecting the item when you have a new order so that it clears itself.
I imagine a conditional action on the inline list I assume youâre using:
- If user has open order \> view details
- If user has new order \> clear quantity \> view details
---
### Author:  [@Azooga](https://community.glideapps.com/u/Azooga)
#### Post date: [September 8, 2021, 2:13pm UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/86 "2021-09-08T14:13:17Z")
Thank you @Jeff_Hager and @Robert_Petitto for the prompt answer (and sorry for my delayed one)
I end up digging a bit more into the forum and found [this solution](https://community.glideapps.com/t/how-to-clear-an-entire-column-compound-action-trickery/18555/9) by Robert and does the trick!
---
### Author:  [@nadiernad](https://community.glideapps.com/u/nadiernad)
#### Post date: [September 10, 2021, 8:38am UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/87 "2021-09-10T08:38:32Z")
may i have a copy of this app?or a tutorial to make like this, how to make it
---
### Author:  [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)
#### Post date: [September 10, 2021, 11:24am UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/88 "2021-09-10T11:24:40Z")
You can follow this thread
> [@User and password](https://community.glideapps.com/t/user-and-password/17965):
>
> Good morning, I have a question, you can log in to the glide app, using a personalized username and password, without the need for an email. thanks
---
### Author:  [@nadiernad](https://community.glideapps.com/u/nadiernad)
#### Post date: [September 10, 2021, 11:36am UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/89 "2021-09-10T11:36:15Z")
Iâve tried to follow it but Iâm still confused where to place it and what component to use. Iâm new to this, can you help me with screenshots
[Previous page](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342.md?page=4)