# Clearing Data in "Note" and "Adjustment" Columns After Button Click **URL:** \ **Category:** Ask for Help\ **Created:** [June 6, 2024, 6:36am UTC](https://community.glideapps.com/t/clearing-data-in-note-and-adjustment-columns-after-button-click/73919 "2024-06-06T06:36:35Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![smprod](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/smprod/32/75887_2.png) [@smprod](https://community.glideapps.com/u/smprod)\ **Post date:** [June 6, 2024, 6:36am UTC](https://community.glideapps.com/t/clearing-data-in-note-and-adjustment-columns-after-button-click/73919/1 "2024-06-06T06:36:35Z")
I have a problem with my Glide app that I’m hoping someone can help me with. In my “Staff” table, I have several columns containing employee data, but most importantly, I have two columns named “Note” and “Adjustment”. I have a button in my layout that, when clicked, transfers employee data to another table. However, I want the “Note” and “Adjustment” columns to be cleared (set to be empty) after clicking this button. What are some possible solutions to achieve this? Thank you for your assistance! ---
**Author:** ![Pratik\_Shah](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pratik_shah/32/12416_2.png) [@Pratik\_Shah](https://community.glideapps.com/u/Pratik_Shah)\ **Post date:** [June 6, 2024, 8:24am UTC](https://community.glideapps.com/t/clearing-data-in-note-and-adjustment-columns-after-button-click/73919/2 "2024-06-06T08:24:17Z")
You can add Custom action having Set Column action which clears values for this two columns. ---
**Author:** ![smprod](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/smprod/32/75887_2.png) [@smprod](https://community.glideapps.com/u/smprod)\ **Post date:** [June 6, 2024, 9:26am UTC](https://community.glideapps.com/t/clearing-data-in-note-and-adjustment-columns-after-button-click/73919/3 "2024-06-06T09:26:13Z")
I need to clear values for this columns in each row ---
**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\ **Post date:** [June 6, 2024, 10:29am UTC](https://community.glideapps.com/t/clearing-data-in-note-and-adjustment-columns-after-button-click/73919/4 "2024-06-06T10:29:28Z")
One way to do it is with a bit of smoke and mirrors. > [@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:** ![smprod](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/smprod/32/75887_2.png) [@smprod](https://community.glideapps.com/u/smprod)\ **Post date:** [June 6, 2024, 11:47am UTC](https://community.glideapps.com/t/clearing-data-in-note-and-adjustment-columns-after-button-click/73919/5 "2024-06-06T11:47:51Z")
In my app “Note” and “Adjustments” aren’t ID’s, so I don’t this this way is possible ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [June 6, 2024, 8:01pm UTC](https://community.glideapps.com/t/clearing-data-in-note-and-adjustment-columns-after-button-click/73919/6 "2024-06-06T20:01:57Z")
Can you explain your process in more detail? Does the button transfer only one staff row, or several? If several, how are you accomplishing that? Are you wanting to clear those two columns in the original table or the table the data was transferred to? Are you trying to clear the values in those two columns for all rows at once or just a single row? ---
**Author:** ![smprod](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/smprod/32/75887_2.png) [@smprod](https://community.glideapps.com/u/smprod)\ **Post date:** [June 7, 2024, 4:50am UTC](https://community.glideapps.com/t/clearing-data-in-note-and-adjustment-columns-after-button-click/73919/7 "2024-06-07T04:50:42Z")
The button transfers all values in the table. I use API Call and joined list to do it. I want to clear the in original table. I want to clear the values in all rows. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [June 7, 2024, 11:29pm UTC](https://community.glideapps.com/t/clearing-data-in-note-and-adjustment-columns-after-button-click/73919/8 "2024-06-07T23:29:25Z")
Can you explain why do you want to move those rows? I’m not getting why you should do it like that, is it something like a log? Also, are those “Note” and “Adjustment” columns user-specific or not?