# Action after submitting a form
**URL:** https://community.glideapps.com/t/action-after-submitting-a-form/26224
**Category:** Ask for Help
**Created:** [April 30, 2021, 1:39pm UTC](https://community.glideapps.com/t/action-after-submitting-a-form/26224 "2021-04-30T13:39:10Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@MemBo](https://community.glideapps.com/u/MemBo)
#### Post date: [April 30, 2021, 1:39pm UTC](https://community.glideapps.com/t/action-after-submitting-a-form/26224/1 "2021-04-30T13:39:10Z")
I created a form that will let users add a row to a sheet. I have a checkbox in the sheet that writes a boolean character (true/false). Based on this item I now either want to write either a 1 or a 0 into the next column.
I tried to do this with an action on submit. First I use the if-function to check the boolean condition. This seems to work. Then I tried the increment function and also the set column function to write directly into the column by setting a costume value in “This Row” and then under the column name. But I do not see the value in the sheet.
Any ideas how to solve this?
Thanks
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [April 30, 2021, 1:51pm UTC](https://community.glideapps.com/t/action-after-submitting-a-form/26224/2 "2021-04-30T13:51:50Z")
Couldn’t you just create an IF column in the sheet to give you a 1 or 0 based on the boolean value?
Also, a boolean column usually recognizes 0 or 1 as well as false or true. Not sure what your use case is, but may be unnecessary depending on what you are trying to do.
---
### Author:  [@MemBo](https://community.glideapps.com/u/MemBo)
#### Post date: [April 30, 2021, 1:56pm UTC](https://community.glideapps.com/t/action-after-submitting-a-form/26224/3 "2021-04-30T13:56:00Z")
That would be an idea. But as these rows are created through the app I did not know how to add the if function. Furthermore, I need it in the google sheet, not only in the glide-function as I use a function in the google sheet (summewenn in German = sum up if condition). I tried to use the glide sheet-functions for that first but then I did not see these columns in the google sheet and could not use them further.
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [April 30, 2021, 2:06pm UTC](https://community.glideapps.com/t/action-after-submitting-a-form/26224/4 "2021-04-30T14:06:06Z")
OK, yeah glide columns only stay in glide. Many people have had different results when using actions on submit. I honestly haven’t done actions on submit enough to know what does and doesn’t work. I think a lot of times it’s just timing and how fast the actions run. If a row isn’t finished writing then sometimes the On Submit actions don’t work right.
You could either do the IF in the google sheet instead, or maybe use a horizontal choice component that writes 0 or 1 to a column instead of using a checkbox or switch.
There’s a lot of other things you could do, like creating a custom form that temporarily writes values to user specific columns, then transfers them to your real columns. Then you could use and IF column to get your 0 or 1 and move that to the proper destination column. But doing it inside of an actual Form or Add screen can get tricky.
> [@How do I create a custom form?](https://community.glideapps.com/t/how-do-i-create-a-custom-form/25014):
>
> I’m just dropping this here so I have something to refer people to when they ask. This is a simple concept app (copyable), that demonstrates the following techniques: Building custom forms for adding and editing list items (as an alternative to the native forms provided by Glide) Preventing duplicate new entries using [User Specific Columns](https://docs.glideapps.com/all/reference/data-editor/user-specific-columns) and [Relations](https://docs.glideapps.com/all/reference/data-editor/computed-columns/relation-column) Enforcing mandatory input items The use of visibility conditions and user specific booleans to control user flow There is nothing particula…
---
### Author:  [@MemBo](https://community.glideapps.com/u/MemBo)
#### Post date: [April 30, 2021, 2:18pm UTC](https://community.glideapps.com/t/action-after-submitting-a-form/26224/5 "2021-04-30T14:18:17Z")
That was very helpful, Thanks. I solved it with a choice box as I can have a different label to the value that I will write down. So I could label it yes or no and then write 1 or 0 as value! That works, thanks a lot!