# Set Column
**URL:** https://community.glideapps.com/t/set-column/24939
**Category:** Ask for Help
**Created:** [March 30, 2021, 6:57pm UTC](https://community.glideapps.com/t/set-column/24939 "2021-03-30T18:57:09Z")
**Posts on this page:** 8
**Page:** 1
### Author:  [@mrt224](https://community.glideapps.com/u/mrt224)
#### Post date: [March 30, 2021, 6:57pm UTC](https://community.glideapps.com/t/set-column/24939/1 "2021-03-30T18:57:09Z")
I have created a form.
On submit, I have Set Column with a value but the value is not being incorporated into my gsheet. Any suggestions?
---
### Author:  [@drascon](https://community.glideapps.com/u/drascon)
#### Post date: [March 30, 2021, 7:19pm UTC](https://community.glideapps.com/t/set-column/24939/2 "2021-03-30T19:19:20Z")
The intended action of the form is to set the provided information into a column… what are you trying to do?
---
### Author:  [@mrt224](https://community.glideapps.com/u/mrt224)
#### Post date: [March 30, 2021, 7:33pm UTC](https://community.glideapps.com/t/set-column/24939/3 "2021-03-30T19:33:47Z")
I am try to set a value (like 400) into a column when the user submits their form. This value is different based on their information but I can’t get anything to set into the column.
---
### Author:  [@drascon](https://community.glideapps.com/u/drascon)
#### Post date: [March 30, 2021, 7:42pm UTC](https://community.glideapps.com/t/set-column/24939/4 "2021-03-30T19:42:56Z")
From my understanding, Set Column only works on an action - like a button press (I could be way off but in my experience using it, that’s what I’ve seen), and it can only change the value of a cell that already has existing data in it. The easiest way to enter static information into a form is to use a text component (NOT a Text Entry component) and in the Data section, enter the number you want. Then, change the visibility so that it isn’t seen by the end user. It will still submit into the row that you want but they won’t know that it’s there
---
### Author:  [@mrt224](https://community.glideapps.com/u/mrt224)
#### Post date: [March 30, 2021, 7:54pm UTC](https://community.glideapps.com/t/set-column/24939/5 "2021-03-30T19:54:27Z")
I will give it a try.
Thank you.
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [March 30, 2021, 11:10pm UTC](https://community.glideapps.com/t/set-column/24939/6 "2021-03-30T23:10:36Z")
Are you trying to write into the same destination sheet or is it another one?
---
### Author:  [@mrt224](https://community.glideapps.com/u/mrt224)
#### Post date: [March 30, 2021, 11:22pm UTC](https://community.glideapps.com/t/set-column/24939/7 "2021-03-30T23:22:20Z")
Same
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [March 30, 2021, 11:28pm UTC](https://community.glideapps.com/t/set-column/24939/8 "2021-03-30T23:28:15Z")
There are many cases that set column doesn’t work with an “on submit” action, I believe @drascon’s recommendation works best. A text/number entry would both work, have a default value and hide it using a condition that will never be true.
If that value won’t be changed going forward, you can just have a template column in the destination sheet.