# Checkbox/switch enhancement request

**URL:** <https://community.glideapps.com/t/checkbox-switch-enhancement-request/14057>\
**Category:** Feature Requests\
**Created:** [August 16, 2020, 11:00am UTC](https://community.glideapps.com/t/checkbox-switch-enhancement-request/14057 "2020-08-16T11:00:25Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**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:** [August 16, 2020, 11:00am UTC](https://community.glideapps.com/t/checkbox-switch-enhancement-request/14057/1 "2020-08-16T11:00:25Z")

</div>

Would anyone want a checkbox/switch enhancement?

I usually face the situation that when I collect “preferences” from users, they want a checkbox/switch style but the only supported value is True/False. To show the right preference content to users I have to make multiple columns in an array column style to take the “text” value back, then make appropriate relations.

It would be nice if we can specify the “True” and “False” value, so let’s say when I check a “Music” preference, it would write Music to the data instead of True.

---

<div class="post-metadata">

**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\
**Post date:** [August 16, 2020, 12:24pm UTC](https://community.glideapps.com/t/checkbox-switch-enhancement-request/14057/2 "2020-08-16T12:24:59Z")

</div>

That’s a cool idea!

I also have a switch/checkbox suggestion ---- have it completely left out of the sheet (as an option). Sometimes I just want to use a checkbox to show/hide a field or group of fields and the checkbox value has zero meaning in the sheet. It would be great to be able to use checkboxes or switches as independent fields simply used to show or hide other fields (like an accordion-style component that just shows or hides other field without writing anything back to the sheet).

---

<div class="post-metadata">

**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:** [August 16, 2020, 2:58pm UTC](https://community.glideapps.com/t/checkbox-switch-enhancement-request/14057/3 "2020-08-16T14:58:41Z")

</div>

@ThinhDinh

you can do it in GS very easy, let me find my last example with this trick to help you.

A screenshot will help you to understand my idea.

Saludos

---

<div class="post-metadata">

**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:** [August 16, 2020, 3:09pm UTC](https://community.glideapps.com/t/checkbox-switch-enhancement-request/14057/4 "2020-08-16T15:09:58Z")

</div>

Here you can read my idea in an old post months ago:

> [@Check box: Values depending on checked/not checked](https://community.glideapps.com/t/check-box-values-depending-on-checked-not-checked/1801/11):
>
> 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: Go to Data Validation menu. Choose Criteria option and later, select Checkboxes as your choice. 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. I hope it hel…

Saludos

---

<div class="post-metadata">

**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:** [August 16, 2020, 3:10pm UTC](https://community.glideapps.com/t/checkbox-switch-enhancement-request/14057/5 "2020-08-16T15:10:44Z")

</div>

Ahhh that’s genius. Gotta try it tomorrow. Thanks for the idea man, have a nice Sunday!

---

<div class="post-metadata">

**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:** [August 18, 2020, 2:33am UTC](https://community.glideapps.com/t/checkbox-switch-enhancement-request/14057/6 "2020-08-18T02:33:28Z")

</div>

Mission accomplished, thanks a lot!

Edit: Ah actually premature celebration, when I checked the checkbox it actually puts TRUE to the cell instead of my value, so it doesn’t work ☹

---

<div class="post-metadata">

**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:** [August 18, 2020, 1:49pm UTC](https://community.glideapps.com/t/checkbox-switch-enhancement-request/14057/7 "2020-08-18T13:49:56Z")

</div>

What a sheet!! 🤨

I saw the problem: a forced value written from an external source (Glide) destroys the cell validation!

I used to use it working with manual inputs but haven’t tested with all scenarios.

It’s a shame, the trick looked great!

Bye @ThinhDinh
