# Check box: Values depending on checked/not checked **URL:** \ **Category:** Feature Requests\ **Created:** [November 8, 2019, 4:53pm UTC](https://community.glideapps.com/t/check-box-values-depending-on-checked-not-checked/1801 "2019-11-08T16:53:45Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Pedro\_Gomes](https://avatars.discourse-cdn.com/v4/letter/p/8edcca/32.png) [@Pedro\_Gomes](https://community.glideapps.com/u/Pedro_Gomes)\ **Post date:** [November 8, 2019, 4:53pm UTC](https://community.glideapps.com/t/check-box-values-depending-on-checked-not-checked/1801/1 "2019-11-08T16:53:45Z")
Dear Glide Community, I have an app in which I use a form with check boxes. I would like to be able to set different values ​​in the spreadsheet instead of just putting true or false. For example: If the box is checked = “Correction required” If the box is not checked = “leave the cell empty” Is there any way? Thanks in advance for your help ---
**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\ **Post date:** [November 8, 2019, 4:58pm UTC](https://community.glideapps.com/t/check-box-values-depending-on-checked-not-checked/1801/2 "2019-11-08T16:58:53Z")
Have you tried the If Then Else column in the data editor? There’s a video that explains it on your app dashboard. ---
**Author:** ![Karim](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/karim/32/13974_2.png) [@Karim](https://community.glideapps.com/u/Karim)\ **Post date:** [November 9, 2019, 1:57pm UTC](https://community.glideapps.com/t/check-box-values-depending-on-checked-not-checked/1801/3 "2019-11-09T13:57:02Z")
Hey Pedro, The IF Then Else column in the data editor works great for that purpose. Otherwise if it’s not a fit, what I did for an app was having a column in the Google sheet with an IF() function where the logical expression refers to the checkbox column being TRUE or FALSE. Hope that helps! ---
**Author:** ![Pedro\_Gomes](https://avatars.discourse-cdn.com/v4/letter/p/8edcca/32.png) [@Pedro\_Gomes](https://community.glideapps.com/u/Pedro_Gomes)\ **Post date:** [November 9, 2019, 10:41pm UTC](https://community.glideapps.com/t/check-box-values-depending-on-checked-not-checked/1801/4 "2019-11-09T22:41:13Z")
Hi Karim, Thanks for your answer. I agree with you, but unfortunately by unchecked box there is no value in the spreadsheet cell. So I can’t use the if then else function as only checked boxes return TRUE and unchecked boxes don’t return any values. I don’t know if there is an syncro issue (by unchecked boxes) or if this is a normally working Thanks again and best regards ---
**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\ **Post date:** [November 9, 2019, 11:18pm UTC](https://community.glideapps.com/t/check-box-values-depending-on-checked-not-checked/1801/5 "2019-11-09T23:18:30Z")
@Pedro_Gomes Check this app [https://zkxhb.glideapp.io](https://zkxhb.glideapp.io) It is a sample of what you asked for. The spreadsheet only has one sheet and one column. I set it so you can copy it and take a look. I created an IF-ELSE Glide field as David said to accomplish what you wanted. You can add rows and set the flag (logical true false) and based on that you can see those two text strings. ---
**Author:** ![Karim](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/karim/32/13974_2.png) [@Karim](https://community.glideapps.com/u/Karim)\ **Post date:** [November 10, 2019, 2:41am UTC](https://community.glideapps.com/t/check-box-values-depending-on-checked-not-checked/1801/6 "2019-11-10T02:41:33Z")
Hi Pedro, I struggled with checkboxes aswell in the beginning. The syntax of the IF() function is different. Let’s imagine you have a checkbox in glide that returns a checked or unchecked box in cell A1 of your sheet and you want to return the text “Check on” or “Check off” depending on if the checkbox is TRUE or FALSE. In this case the function is as follows: =IF(A1 , “Check in” , “Check off”) The logical expression is just about referencing the cell where the checkbox is. Hope this helps ---
**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:** [November 11, 2019, 7:50pm UTC](https://community.glideapps.com/t/check-box-values-depending-on-checked-not-checked/1801/7 "2019-11-11T19:50:12Z")
Just remember, in an IF statement: “is not TRUE” gives you the same result as “is FALSE” @George_B demonstrates well using the ELSE, which covers any value that is not TRUE, such as “blank”, “false”, “bob”. In @Karim example using the formula inside the sheet instead, A1 is checked for TRUE and the next argument (check in) in the statement displays if the result is true. If it is not true, then the third argument (check off) is displayed. ---
**Author:** ![Victor\_Olawuni](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/victor_olawuni/32/5361_2.png) [@Victor\_Olawuni](https://community.glideapps.com/u/Victor_Olawuni)\ **Post date:** [December 29, 2019, 8:31pm UTC](https://community.glideapps.com/t/check-box-values-depending-on-checked-not-checked/1801/8 "2019-12-29T20:31:04Z")
Hi guys, Slightly off tangent but is there a way to make checkbox’s a ‘required’ element before form submission? Many thanks, Victor ---
**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\ **Post date:** [December 29, 2019, 8:35pm UTC](https://community.glideapps.com/t/check-box-values-depending-on-checked-not-checked/1801/9 "2019-12-29T20:35:13Z")
The checkbox as far as Glide is concerned it either checked or unchecked. By its nature it is a required field as far as I look at it. Whether you check it or leave it unchecked that state will be saved to the sheet. Maybe I’m not understanding what you are trying to accomplish. ---
**Author:** ![Victor\_Olawuni](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/victor_olawuni/32/5361_2.png) [@Victor\_Olawuni](https://community.glideapps.com/u/Victor_Olawuni)\ **Post date:** [December 29, 2019, 8:58pm UTC](https://community.glideapps.com/t/check-box-values-depending-on-checked-not-checked/1801/10 "2019-12-29T20:58:02Z")
Thanks George, sorry should have been a little clearer… I’m after user’s having to check the box first before they can proceed. (i.e. check to agree with ‘terms and conditions’ ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [December 29, 2019, 9:39pm UTC](https://community.glideapps.com/t/check-box-values-depending-on-checked-not-checked/1801/11 "2019-12-29T21:39:56Z")
Hi everyone It´s a litle late but maybe, someone in the future could need what @Pedro_Gomes wanted. Here is the way to do it inside Google sheet: 1. Go to **Data Validation** menu. 2. Choose **Criteria** option and later, select **Checkboxes** as your choice. 3. Customize your answers to be something other than TRUE/FALSE. Here is where you put your text. I attached an image of an example based on you request, it´s in spanish but I think you will understand what I try writting you. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/4/4975e49210a8a22334e77b2acfea655c9d62acf3.png) I hope it helps! Saludos y feliz año 2020! Gavp ---
**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\ **Post date:** [December 29, 2019, 10:20pm UTC](https://community.glideapps.com/t/check-box-values-depending-on-checked-not-checked/1801/12 "2019-12-29T22:20:04Z")
Got it. I separated that functionality with a Form Button and a separate sheet, for a few reasons but mainly so I could save a date/time stamp of when they agreed. I then do a lookup from the users record (using their email) to see if they have agreed to the terms. Based on that true false lookup result I then use the control visibility to show or not show certain components based on that true false. It’s a bit complex but is what was worked out with the client to assure that they have agreed to the terms, when they agreed, and then also can’t “un-agree” at a later date. It is a permanent record of them agreeing. ---
**Author:** ![John\_Cabrera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/john_cabrera/32/2066_2.png) [@John\_Cabrera](https://community.glideapps.com/u/John_Cabrera)\ **Post date:** [December 30, 2019, 9:07pm UTC](https://community.glideapps.com/t/check-box-values-depending-on-checked-not-checked/1801/13 "2019-12-30T21:07:29Z")
I’ve done something similar as @George_B describes. I have a checkbox and an invisible Required Choice Component right after it. When the person clicks the checkbox, I have all the other elements of the form turn on. I also make the checkbox disappear when it’s checked so that they can’t uncheck the box after filling out the rest of the form. In the place of the checkbox I have a Rich Text component appear that has been styled with CSS to look exactly like the checkbox and its corresponding text but filled in. It’s just for aesthetics. It can’t be unchecked obviously, but gives the effect of a checked box. Once the box has been checked, they can only cancel out the entire form and subsequent submission. Alternatively, you could just use the Choice Component instead of the checkbox to require agreeing to terms and conditions, since that component can be Required. Just have the Choice Component point to a column with only one row of data: “Yes” or “I Agree”. But I’m guessing that was just an example and you have another reason for wanting your checkbox’s ‘TRUE’ state required. I would love to see this come to Glide as well. For app flow purposes, Checkboxes are just much smoother than Choice Components when used in this way. ---
**Author:** ![HeddaBO](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/heddabo/32/8531_2.png) [@HeddaBO](https://community.glideapps.com/u/HeddaBO)\ **Post date:** [July 9, 2020, 9:57pm UTC](https://community.glideapps.com/t/check-box-values-depending-on-checked-not-checked/1801/14 "2020-07-09T21:57:51Z")
Hi guys, trying to get the hang of check boxes and whether or not they can be used on an individual basis. E.g. I’m doing an app where I want every user to have access to a checklist of things they should think about and then check these items once done. I don’t want this to check the box for all other user just for this specific user. Is it doable? Thanks! ---
**Author:** ![eltintero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eltintero/32/76520_2.png) [@eltintero](https://community.glideapps.com/u/eltintero)\ **Post date:** [July 9, 2020, 9:58pm UTC](https://community.glideapps.com/t/check-box-values-depending-on-checked-not-checked/1801/15 "2020-07-09T21:58:25Z")
In your data editor, mark that column as user specific. ---
**Author:** ![HeddaBO](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/heddabo/32/8531_2.png) [@HeddaBO](https://community.glideapps.com/u/HeddaBO)\ **Post date:** [July 9, 2020, 10:11pm UTC](https://community.glideapps.com/t/check-box-values-depending-on-checked-not-checked/1801/16 "2020-07-09T22:11:48Z")
Ah, that’s cool. Will try it! Thanks 🙏 ---
**Author:** ![HeddaBO](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/heddabo/32/8531_2.png) [@HeddaBO](https://community.glideapps.com/u/HeddaBO)\ **Post date:** [July 9, 2020, 10:15pm UTC](https://community.glideapps.com/t/check-box-values-depending-on-checked-not-checked/1801/17 "2020-07-09T22:15:20Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/6/6432e20e5edcc167a12d6a35d646030c344c09dc.png) It’s actually not possible. Why is that? ---
**Author:** ![Glider](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/glider/32/9699_2.png) [@Glider](https://community.glideapps.com/u/Glider)\ **Post date:** [July 9, 2020, 10:28pm UTC](https://community.glideapps.com/t/check-box-values-depending-on-checked-not-checked/1801/18 "2020-07-09T22:28:01Z")
It is because you cannot edit columns only their names so create a new column and make it user specific > Hope that helps @HeddaBO ---
**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:** [July 9, 2020, 10:30pm UTC](https://community.glideapps.com/t/check-box-values-depending-on-checked-not-checked/1801/19 "2020-07-09T22:30:30Z")
User profiles have no bearing on user specific columns. You can not make a sheet column user specific. It will only work if you create a new column in the glide data editor and assign it as user specific. This will keep the column only within Glide and will not be part of the Google sheet. ---
**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:** [July 9, 2020, 10:32pm UTC](https://community.glideapps.com/t/check-box-values-depending-on-checked-not-checked/1801/20 "2020-07-09T22:32:08Z")
As Jeff said, it’s likely you created the column in Sheets rather than the Editor, so you can’t mark it user-specific. Go to the data editor inside Glide and create a new one. [Next page](https://community.glideapps.com/t/check-box-values-depending-on-checked-not-checked/1801.md?page=2)