# Empty Boolean field issue

**URL:** <https://community.glideapps.com/t/empty-boolean-field-issue/8509>\
**Category:** Report a Bug\
**Created:** [May 5, 2020, 12:14pm UTC](https://community.glideapps.com/t/empty-boolean-field-issue/8509 "2020-05-05T12:14:41Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![ugm](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ugm/32/530_2.png) [@ugm](https://community.glideapps.com/u/ugm)\
**Post date:** [May 5, 2020, 12:14pm UTC](https://community.glideapps.com/t/empty-boolean-field-issue/8509/1 "2020-05-05T12:14:41Z")

</div>

My app’s URL: None

Consider a Sheet (called Display) with two Columns - Content, Private?  
Assume I have populated the “Content” column with some text  
The functionality I am implementing is to make “Content” visible if “Private?” is FALSE  
and that is how the visibility condition is set:

**VISIBLE IF Private? is FALSE**

This will not work (Content wont be visible) if Private? is EMPTY but works if I set the condition as

**VISIBLE IF Private? is not TRUE**

implying an empty BOOLEAN is = NOT TRUE but not equal to FALSE!

Don’t know if this is a BUG or an unintentional feature but certainly is ODD!

---

<div class="post-metadata">

**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:** [May 5, 2020, 12:41pm UTC](https://community.glideapps.com/t/empty-boolean-field-issue/8509/2 "2020-05-05T12:41:25Z")

</div>

To me that’s normal. Blank is neither true, nor false. I always use ‘not True’ when checking for a false condition as it’s a catch all.

---

<div class="post-metadata">

**Author:** ![ugm](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ugm/32/530_2.png) [@ugm](https://community.glideapps.com/u/ugm)\
**Post date:** [May 6, 2020, 3:23am UTC](https://community.glideapps.com/t/empty-boolean-field-issue/8509/3 "2020-05-06T03:23:09Z")

</div>

Thanks Jeff.  
This was not normal for me - discovered it accidentally after many hours on this specific issue.

May be worth mentioning this in the documentation. It could save someones time!

---

<div class="post-metadata">

**Author:** ![Killko](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/killko/32/39538_2.png) [@Killko](https://community.glideapps.com/u/Killko)\
**Post date:** [August 23, 2020, 11:41am UTC](https://community.glideapps.com/t/empty-boolean-field-issue/8509/4 "2020-08-23T11:41:13Z")

</div>

I don’t think this a normal behavior, in Google Sheet FALSE is either FALSE or empty. Since cells in new rows are empty by default, I think Glide should adopt the same logic…

---

<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 23, 2020, 12:25pm UTC](https://community.glideapps.com/t/empty-boolean-field-issue/8509/5 "2020-08-23T12:25:10Z")

</div>

You can add data validation for the whole column and then delete empty rows so new rows adopt the FALSE by default.

---

<div class="post-metadata">

**Author:** ![Killko](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/killko/32/39538_2.png) [@Killko](https://community.glideapps.com/u/Killko)\
**Post date:** [August 23, 2020, 1:20pm UTC](https://community.glideapps.com/t/empty-boolean-field-issue/8509/6 "2020-08-23T13:20:21Z")

</div>

No, that doesn’t work because data validation is seen by Glide as a not empty cell, so when adding a new row it will create a new one sheets, leaving a bunch of empty rows in between, and the new row won’t have the data validation. In the example I did data validation until row 69 and then added a new row…

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/6/674858a0f2a4411917b60519abf5d9762299fccb.png)

---

<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 23, 2020, 1:39pm UTC](https://community.glideapps.com/t/empty-boolean-field-issue/8509/7 "2020-08-23T13:39:21Z")

</div>

What did you have in the data validation range?

---

<div class="post-metadata">

**Author:** ![Killko](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/killko/32/39538_2.png) [@Killko](https://community.glideapps.com/u/Killko)\
**Post date:** [August 23, 2020, 2:05pm UTC](https://community.glideapps.com/t/empty-boolean-field-issue/8509/8 "2020-08-23T14:05:56Z")

</div>

Check Box standard

---

<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 23, 2020, 2:15pm UTC](https://community.glideapps.com/t/empty-boolean-field-issue/8509/9 "2020-08-23T14:15:47Z")

</div>

I mean the range, what did you specify for the range?

---

<div class="post-metadata">

**Author:** ![Killko](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/killko/32/39538_2.png) [@Killko](https://community.glideapps.com/u/Killko)\
**Post date:** [August 23, 2020, 2:44pm UTC](https://community.glideapps.com/t/empty-boolean-field-issue/8509/10 "2020-08-23T14:44:25Z")

</div>

E2:E69 for the example.  
Obviously I could have chosen E2:E62 and it would have worked, but then when a new line gets created in Row 63, it wouldn’t have the validation.

---

<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 23, 2020, 3:57pm UTC](https://community.glideapps.com/t/empty-boolean-field-issue/8509/11 "2020-08-23T15:57:47Z")

</div>

Shot a quick video here, can you confirm if this applies to your case? I tried adding new rows and it does honor that.

Is the behaviour the same with a Glide added row?

I have faced this case before and this data validation was honored, sorry I didn’t have time to test it with a form.
