# Limited elements in Basic table

**URL:** <https://community.glideapps.com/t/limited-elements-in-basic-table/36239>\
**Category:** Ask for Help\
**Created:** [December 22, 2021, 4:59pm UTC](https://community.glideapps.com/t/limited-elements-in-basic-table/36239 "2021-12-22T16:59:36Z")\
**Posts on this page:** 13\
**Page:** 1

<div class="post-metadata">

**Author:** ![Vladivostock](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vladivostock/32/37144_2.png) [@Vladivostock](https://community.glideapps.com/u/Vladivostock)\
**Post date:** [December 22, 2021, 4:59pm UTC](https://community.glideapps.com/t/limited-elements-in-basic-table/36239/1 "2021-12-22T16:59:36Z")

</div>

Hello Gliders !  
Happy to have an opportunity of receiving your help!  
I have tried to avoid features which give issues, but there are some imperative ones I can’t skip.  
This time it’s basic table. The list of details only shows three lines, although more lines are set. Please see my screenshots.

Thanks and have a Happy Holiday!

 ![screenshots123](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/c/6c240fc9904b00cafeef9a925889576b263775e4.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:** [December 22, 2021, 5:04pm UTC](https://community.glideapps.com/t/limited-elements-in-basic-table/36239/2 "2021-12-22T17:04:35Z")

</div>

The basic table will only show items when the column is not empty. You’ll either need to populate the empty columns, or use a series of IF columns that will either return the value in the column if not empty, or return something like an empty character.

> **[Empty Characters, Whitespaces & Blank Unicode Characters](https://emptycharacter.com/)**
>
> Empty Characters, Whitespaces & Blank Unicode Characters

---

<div class="post-metadata">

**Author:** ![Vladivostock](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vladivostock/32/37144_2.png) [@Vladivostock](https://community.glideapps.com/u/Vladivostock)\
**Post date:** [December 22, 2021, 5:04pm UTC](https://community.glideapps.com/t/limited-elements-in-basic-table/36239/3 "2021-12-22T17:04:44Z")

</div>

Just after posting my question, I have found out that if any of the elements don’t have a value, the element is not shown. Pity.  
So here is another question: Can this issue be fixed ?

---

<div class="post-metadata">

**Author:** ![Vladivostock](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vladivostock/32/37144_2.png) [@Vladivostock](https://community.glideapps.com/u/Vladivostock)\
**Post date:** [December 22, 2021, 5:13pm UTC](https://community.glideapps.com/t/limited-elements-in-basic-table/36239/4 "2021-12-22T17:13:03Z")

</div>

Thanks a lot for this lightning-like answer, Jeff!  
Where and how should I apply IF? I have tried it in Glide-Basic table-options, it didn’t work.

---

<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:** [December 22, 2021, 5:24pm UTC](https://community.glideapps.com/t/limited-elements-in-basic-table/36239/5 "2021-12-22T17:24:06Z")

</div>

You can create IF columns in your table. For example, set one up like this:  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/5/65f83657b5fb29b3a12ab99e5e51f68020c10218.png)

Notice, the Else looks empty, but that is where I pasted the empty character. It’s a valid character that’s invisible, so the returned value from the IF will never be truly empty.

Then you can display the IF column in your basic table instead of the Model column.

---

<div class="post-metadata">

**Author:** ![Vladivostock](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vladivostock/32/37144_2.png) [@Vladivostock](https://community.glideapps.com/u/Vladivostock)\
**Post date:** [December 22, 2021, 5:39pm UTC](https://community.glideapps.com/t/limited-elements-in-basic-table/36239/6 "2021-12-22T17:39:57Z")

</div>

Thanks, I have tried this, but it didn’t help. The empty elements stayed empty and therefore haven’t appeared in the app (I have used empty tag, as in the link, as well as 0 for mileage)  
The Workspace disappears every time I add If-then-else and there is a record of the conditions added on the left, is there a way to remove some of the conditions?It only lets me delete all elements of the screen. Is it normal?

---

<div class="post-metadata">

**Author:** ![Dilon\_Perera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilon_perera/32/85652_2.png) [@Dilon\_Perera](https://community.glideapps.com/u/Dilon_Perera)\
**Post date:** [December 22, 2021, 5:48pm UTC](https://community.glideapps.com/t/limited-elements-in-basic-table/36239/7 "2021-12-22T17:48:31Z")

</div>

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

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/2/5222bb75b344c5e24944c1be3f3dd45a0b969ea2.png)

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

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

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

Here’s how I did it.

Thank you

---

<div class="post-metadata">

**Author:** ![Vladivostock](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vladivostock/32/37144_2.png) [@Vladivostock](https://community.glideapps.com/u/Vladivostock)\
**Post date:** [December 22, 2021, 6:01pm UTC](https://community.glideapps.com/t/limited-elements-in-basic-table/36239/8 "2021-12-22T18:01:24Z")

</div>

Thank you Dilon!  
If I understood correctly, I can not add IF function to the existing cells. The only way to do it is to create the cells using IF function.

---

<div class="post-metadata">

**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\
**Post date:** [December 22, 2021, 6:34pm UTC](https://community.glideapps.com/t/limited-elements-in-basic-table/36239/9 "2021-12-22T18:34:36Z")

</div>

If function will not change existing column/cell. It will add a new conditioned column. So there will be two series columns. You just move the basic table to the If-then-else column, it will definitely appear.  
Maybe the link below can explain in more detail.

> **[If → Then → Else Column](https://docs.glideapps.com/all/topics/computed-columns/primary/if-then-else)**
>
> Compute different values depending on other data in your sheet

---

<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:** [December 22, 2021, 6:36pm UTC](https://community.glideapps.com/t/limited-elements-in-basic-table/36239/10 "2021-12-22T18:36:44Z")

</div>

The way @Dilon_Perera set it up looks exactly like how I would do it. You keep your existing data columns, but in addition to each of them, you add a matching IF column. The IF column is what you display in the basic table.

> [@Vladivostock](#):
>
> The Workspace disappears every time I add If-then-else and there is a record of the conditions added on the left, is there a way to remove some of the conditions?It only lets me delete all elements of the screen. Is it normal?

I’m not sure I understand your problem here. Do you have screenshots or a video showing what’s happening?

---

<div class="post-metadata">

**Author:** ![Vladivostock](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vladivostock/32/37144_2.png) [@Vladivostock](https://community.glideapps.com/u/Vladivostock)\
**Post date:** [December 22, 2021, 10:19pm UTC](https://community.glideapps.com/t/limited-elements-in-basic-table/36239/11 "2021-12-22T22:19:02Z")

</div>

Thanks Himaladin!  
I have created few required conditional cell, added lines in the basic table, which consist of text and value.  
Text had to be typed in on the left side and on the right side I have chosen the If-then cells.  
It all worked out!  
Now I can sleep well ! )

 ![Screen Shot 2021-12-22 at 22.09.18](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/e/0ecbc2a8fab2e859daaba1ad933ea148c9c2ee96.png)

---

<div class="post-metadata">

**Author:** ![Vladivostock](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vladivostock/32/37144_2.png) [@Vladivostock](https://community.glideapps.com/u/Vladivostock)\
**Post date:** [December 22, 2021, 10:23pm UTC](https://community.glideapps.com/t/limited-elements-in-basic-table/36239/12 "2021-12-22T22:23:03Z")

</div>

Jeff, thanks a lot for the help!  
It’s my first app and I’ve just started it.  
Have a great evening!  
👍

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [December 23, 2021, 10:23pm UTC](https://community.glideapps.com/t/limited-elements-in-basic-table/36239/13 "2021-12-23T22:23:08Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.
