Empty Boolean field issue

Report a Bug
1

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!

2

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.

3

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!

1 Like
4

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…

5

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

6

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
image1440×1096 164 KB

7

What did you have in the data validation range?

8

Check Box standard

9

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

10

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.

11

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.