# Basic table displaying "False" instead of just being empty

**URL:** <https://community.glideapps.com/t/basic-table-displaying-false-instead-of-just-being-empty/50442>\
**Category:** Ask for Help\
**Created:** [September 29, 2022, 1:45pm UTC](https://community.glideapps.com/t/basic-table-displaying-false-instead-of-just-being-empty/50442 "2022-09-29T13:45:38Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![Katelyn\_Alberts](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/katelyn_alberts/32/44421_2.png) [@Katelyn\_Alberts](https://community.glideapps.com/u/Katelyn_Alberts)\
**Post date:** [September 29, 2022, 1:45pm UTC](https://community.glideapps.com/t/basic-table-displaying-false-instead-of-just-being-empty/50442/1 "2022-09-29T13:45:38Z")

</div>

I have a bunch of basic tables, and none of my others ones do this? I can’t figure out how to get rid of the “false”. I thought maybe it was because i have visibility conditions but my other tables have some as well - albeit different conditions. Any advice?

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/0/e0cf141e356b63a4347fde0cfd38f9a5de51c777.jpeg)  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/2/e281737d86ca89fe3d85c7bcfa123b40299b5ad0.png)  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/c/7cdacb256127af80bf94fab98641828a2965ef79.jpeg)

---

<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:** [September 29, 2022, 1:55pm UTC](https://community.glideapps.com/t/basic-table-displaying-false-instead-of-just-being-empty/50442/2 "2022-09-29T13:55:41Z")

</div>

Why does your table have a bunch of basic text columns with ‘false’ written to them? How did those columns get ‘false’ written in there?

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [September 29, 2022, 1:58pm UTC](https://community.glideapps.com/t/basic-table-displaying-false-instead-of-just-being-empty/50442/3 "2022-09-29T13:58:13Z")

</div>

Looks like that table is attached to a Google Sheet - have you looked at the Google Sheet?  
Seems like your basic table is (correctly) reflecting the values in the table.

---

<div class="post-metadata">

**Author:** ![Katelyn\_Alberts](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/katelyn_alberts/32/44421_2.png) [@Katelyn\_Alberts](https://community.glideapps.com/u/Katelyn_Alberts)\
**Post date:** [September 29, 2022, 1:58pm UTC](https://community.glideapps.com/t/basic-table-displaying-false-instead-of-just-being-empty/50442/4 "2022-09-29T13:58:57Z")

</div>

they just showed up when i created the columns! It’s so weird, they are just basic text columns!

and it’s random which ones say false, I couldn’t find a connection in the database

---

<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:** [September 29, 2022, 2:00pm UTC](https://community.glideapps.com/t/basic-table-displaying-false-instead-of-just-being-empty/50442/5 "2022-09-29T14:00:19Z")

</div>

Weird. What happens when you clear out the column value?

---

<div class="post-metadata">

**Author:** ![Katelyn\_Alberts](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/katelyn_alberts/32/44421_2.png) [@Katelyn\_Alberts](https://community.glideapps.com/u/Katelyn_Alberts)\
**Post date:** [September 29, 2022, 2:06pm UTC](https://community.glideapps.com/t/basic-table-displaying-false-instead-of-just-being-empty/50442/6 "2022-09-29T14:06:59Z")

</div>

You can see in the database picture I attached above that all of them are empty except the brand new demo row i just tested. Half stayed empty upon column creation, half just popped up false.  
I’m pulling from choice options table

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/e/2e1a7cbce9f355a7a9ceb7632d6576366f3bd163.jpeg)

and allowing salon owners to select from choice drop down

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/8/7851835a8fe404c40ca1b3bb208b5ec17301a46b.png)

so that it will display here

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/a/aa84ff1ca8de847f5cbc6ead2ea8baaae0078690.jpeg)

none of my other tables have done this with blank selections

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [September 29, 2022, 2:13pm UTC](https://community.glideapps.com/t/basic-table-displaying-false-instead-of-just-being-empty/50442/7 "2022-09-29T14:13:43Z")

</div>

Can you show me the configuration of your choice components, including any filtering that is used?

---

<div class="post-metadata">

**Author:** ![David\_Gabler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david_gabler/32/44332_2.png) [@David\_Gabler](https://community.glideapps.com/u/David_Gabler)\
**Post date:** [September 29, 2022, 2:14pm UTC](https://community.glideapps.com/t/basic-table-displaying-false-instead-of-just-being-empty/50442/8 "2022-09-29T14:14:39Z")

</div>

I’ve seen that happen when a table is connected to Google _and_ the column is first created as Boolean and later changed to Basic Text. For some reason, Google retains the column setting of Boolean for rows that had been interacted with even after the column is changed to “Text” in Glide later.

And for some reason, I cannot upload an image right now to demonstrate what I am talking about. It just churns: “Uploading 0%”

Uploading: image.png…

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [September 29, 2022, 2:16pm UTC](https://community.glideapps.com/t/basic-table-displaying-false-instead-of-just-being-empty/50442/9 "2022-09-29T14:16:25Z")

</div>

> [@Katelyn\_Alberts](#):
>
> they just showed up when i created the columns! It’s so weird, they are just basic text columns!

What is the column type that is immediately to the left of those columns?  
I’ve found that when you add a column to a Google Sheet, the new column will “inherit” the formatting of the one immediately to the left.

---

<div class="post-metadata">

**Author:** ![David\_Gabler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david_gabler/32/44332_2.png) [@David\_Gabler](https://community.glideapps.com/u/David_Gabler)\
**Post date:** [September 29, 2022, 2:18pm UTC](https://community.glideapps.com/t/basic-table-displaying-false-instead-of-just-being-empty/50442/10 "2022-09-29T14:18:16Z")

</div>

> [@Darren\_Murphy](#):
>
> add a column to a Google Sheet

Weird. I suppose it’s when the column is added through the Glide data editor? Or just added from anywhere?

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [September 29, 2022, 2:22pm UTC](https://community.glideapps.com/t/basic-table-displaying-false-instead-of-just-being-empty/50442/11 "2022-09-29T14:22:00Z")

</div>

Not sure about the GDE, but it definitely happens when done inside the Google Sheet.

Here, observe…

---

<div class="post-metadata">

**Author:** ![Katelyn\_Alberts](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/katelyn_alberts/32/44421_2.png) [@Katelyn\_Alberts](https://community.glideapps.com/u/Katelyn_Alberts)\
**Post date:** [September 29, 2022, 2:25pm UTC](https://community.glideapps.com/t/basic-table-displaying-false-instead-of-just-being-empty/50442/12 "2022-09-29T14:25:54Z")

</div>

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/1/71ef0d1958860736bd37e5e52e360e00cafab4a5.jpeg)  
just plain text column  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/d/7d3f20dd98f8d26475eabc9d398ae6f0fa1de3f0.jpeg)  
is this the other thing you wanted to see?

---

<div class="post-metadata">

**Author:** ![David\_Gabler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david_gabler/32/44332_2.png) [@David\_Gabler](https://community.glideapps.com/u/David_Gabler)\
**Post date:** [September 29, 2022, 2:41pm UTC](https://community.glideapps.com/t/basic-table-displaying-false-instead-of-just-being-empty/50442/13 "2022-09-29T14:41:38Z")

</div>

We would like you to click on the link “KatelynAlbertsApp” under “data sources” in the lower left and then screenshot the “salons” tab so we can see the order of the columns in your Google Sheet. It will typically not be in the same order as displayed in the Glide Data Editor.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [September 29, 2022, 3:28pm UTC](https://community.glideapps.com/t/basic-table-displaying-false-instead-of-just-being-empty/50442/14 "2022-09-29T15:28:39Z")

</div>

> [@Katelyn\_Alberts](#):
>
> is this the other thing you wanted to see?

 ![Screen Shot 2022-09-29 at 11.23.16 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/c/7c927f03037f544b2eb4156603290db47379d217.jpeg)

---

<div class="post-metadata">

**Author:** ![Joe\_Gabriele](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/joe_gabriele/32/57595_2.png) [@Joe\_Gabriele](https://community.glideapps.com/u/Joe_Gabriele)\
**Post date:** [September 29, 2022, 4:58pm UTC](https://community.glideapps.com/t/basic-table-displaying-false-instead-of-just-being-empty/50442/15 "2022-09-29T16:58:38Z")

</div>

I can confirm this happened in my app as well, which is connected to a Google Sheet. I did notice when I opened my Google Sheet that it had boolean boxes for empties… I believe they were created in GDE using plain text as well. Might have duplicated a boolean and changed to Text, cant remember.

---

<div class="post-metadata">

**Author:** ![Katelyn\_Alberts](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/katelyn_alberts/32/44421_2.png) [@Katelyn\_Alberts](https://community.glideapps.com/u/Katelyn_Alberts)\
**Post date:** [September 29, 2022, 6:34pm UTC](https://community.glideapps.com/t/basic-table-displaying-false-instead-of-just-being-empty/50442/16 "2022-09-29T18:34:26Z")

</div>

sorry for the delay, i was wrangling goats.

I removed all of them and still there

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/3/d30f35ad8449db8356d52eccc6e2225c65143e93.jpeg)  
no blank spaces  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/5/e510f1c73ef4a0935f090324298f285cbc8e45a0.png)

---

<div class="post-metadata">

**Author:** ![Katelyn\_Alberts](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/katelyn_alberts/32/44421_2.png) [@Katelyn\_Alberts](https://community.glideapps.com/u/Katelyn_Alberts)\
**Post date:** [September 29, 2022, 6:41pm UTC](https://community.glideapps.com/t/basic-table-displaying-false-instead-of-just-being-empty/50442/17 "2022-09-29T18:41:23Z")

</div>

I made a new column without duplicating and named it ‘sample column’  
then made a second one duplicating from one of the false columns, named it ‘sample column 2’ and BOTH created the false label

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/7/a761a7760f03b6465ad4d5acd048374fd87ee0ad.jpeg)  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/5/55e9b3c02bdad7456c6af6024807e71a9acf1889.jpeg)

---

<div class="post-metadata">

**Author:** ![Katelyn\_Alberts](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/katelyn_alberts/32/44421_2.png) [@Katelyn\_Alberts](https://community.glideapps.com/u/Katelyn_Alberts)\
**Post date:** [September 29, 2022, 7:50pm UTC](https://community.glideapps.com/t/basic-table-displaying-false-instead-of-just-being-empty/50442/18 "2022-09-29T19:50:38Z")

</div>

ok i think i figured out the source to the problem…sort of!! It’s jumlbing the information in all of these columns together. All of the ones that say false on my basic table are BL booleans minus the BN names. But none of these columns have anything to do with one another, or werent duplicated to create each other, and were created months apart.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/c/cc2c9680bbb48dacabdde6fe2d37a4097e0d5d0a.png)

the other columns besides BL are not booleans, they are just text, but appearing so on google sheet

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/2/522f2730b777203e58cf678fd9ab337ad2f9f88b.jpeg)

---

<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:** [September 30, 2022, 12:26am UTC](https://community.glideapps.com/t/basic-table-displaying-false-instead-of-just-being-empty/50442/19 "2022-09-30T00:26:02Z")

</div>

When the columns were created doesn’t matter, what matters is the column just before that contained booleans, and as @Darren_Murphy pointed out earlier, it took the boolean format as its initial state when Glide create a new column. It’s a known thing with Sheets.

---

<div class="post-metadata">

**Author:** ![Katelyn\_Alberts](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/katelyn_alberts/32/44421_2.png) [@Katelyn\_Alberts](https://community.glideapps.com/u/Katelyn_Alberts)\
**Post date:** [September 30, 2022, 1:22am UTC](https://community.glideapps.com/t/basic-table-displaying-false-instead-of-just-being-empty/50442/20 "2022-09-30T01:22:02Z")

</div>

So how do I fix it? And prevent it? I still don’t quite understand how a text column I created a year prior would be affected by a boolean I created a month ago?

So only the first one should be a boolean, and the rest should just be text entry columns, what do I do? And do i have to fix it on the sheet side as opposed to the Glide side?

[Next page](https://community.glideapps.com/t/basic-table-displaying-false-instead-of-just-being-empty/50442.md?page=2)
