# Stuck :( on if/else; because of lack of AND

**URL:** https://community.glideapps.com/t/stuck-on-if-else-because-of-lack-of-and/68759
**Category:** Ask for Help
**Created:** [December 16, 2023, 8:06am UTC](https://community.glideapps.com/t/stuck-on-if-else-because-of-lack-of-and/68759 "2023-12-16T08:06:26Z")
**Posts on this page:** 7
**Page:** 1

<div class="post-metadata">

### Author: ![Tomasz\_Winiarski](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tomasz_winiarski/32/66783_2.png) [@Tomasz\_Winiarski](https://community.glideapps.com/u/Tomasz_Winiarski)
#### Post date: [December 16, 2023, 8:06am UTC](https://community.glideapps.com/t/stuck-on-if-else-because-of-lack-of-and/68759/1 "2023-12-16T08:06:27Z")

</div>

Hi!  
Three days of looking for some workaround.And the only I found is to build separate tables… But this is A LOT of work in my case… Maybe I miss something…

I have one table with different series of tools. I want to hide from displaying in collection some series based on column value. But only particular ones…

Here is a screenshot what I want to achieve (more less):

 ![howtohide](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/f/af455f2abeef5fa8c120cbff40f238c10417cb7d.png)

I play with glide two months. I love it, I can build almost every my idea, and…  
… lack of AND in IF/THEN is the only one but SUPERHUGE drawback. To be honest this is the only reason that I look around still in no-code world.

For any help HUGE THANKS in advance 🙂  
regards, warm as usual!

---

<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: [December 16, 2023, 8:09am UTC](https://community.glideapps.com/t/stuck-on-if-else-because-of-lack-of-and/68759/2 "2023-12-16T08:09:54Z")

</div>

Try this:

- If tag is not big, then true
- If value is greater than x, then true
- Else false

---

<div class="post-metadata">

### Author: ![Tomasz\_Winiarski](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tomasz_winiarski/32/66783_2.png) [@Tomasz\_Winiarski](https://community.glideapps.com/u/Tomasz_Winiarski)
#### Post date: [December 16, 2023, 8:15am UTC](https://community.glideapps.com/t/stuck-on-if-else-because-of-lack-of-and/68759/3 "2023-12-16T08:15:02Z")

</div>

Huh it was fast! 💪  
Give me couple of minutes, I’m going to test 🙂

---

<div class="post-metadata">

### Author: ![Tomasz\_Winiarski](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tomasz_winiarski/32/66783_2.png) [@Tomasz\_Winiarski](https://community.glideapps.com/u/Tomasz_Winiarski)
#### Post date: [December 16, 2023, 8:37am UTC](https://community.glideapps.com/t/stuck-on-if-else-because-of-lack-of-and/68759/4 "2023-12-16T08:37:01Z")

</div>

THANK YOU! I don’t know, I’m pretty sure that I tried this… I draw a lot ot diagrams, I tested 100 variants… And it was so EASY! Thanks…

BUT question: in IF/ELSE window is an order of conditions important of ot doesn’t matter? I didn’t think about it… Maybe this is it??!

In other words: every next condition is ELSE for previous condition???

---

<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: [December 16, 2023, 8:41am UTC](https://community.glideapps.com/t/stuck-on-if-else-because-of-lack-of-and/68759/5 "2023-12-16T08:41:14Z")

</div>

The if-then-else column will test each condition, starting from the top, and return the first one that passes.  
If none pass, then it will return the else, if one is given. Otherwise it will return null.

So yes, the order of the conditions is significant.

When you need to mix and/or, the best approach is to test for all the failing conditions first.

---

<div class="post-metadata">

### Author: ![Tomasz\_Winiarski](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tomasz_winiarski/32/66783_2.png) [@Tomasz\_Winiarski](https://community.glideapps.com/u/Tomasz_Winiarski)
#### Post date: [December 16, 2023, 8:51am UTC](https://community.glideapps.com/t/stuck-on-if-else-because-of-lack-of-and/68759/6 "2023-12-16T08:51:49Z")

</div>

This is the missed key - conditions order! Still and/or would be easier 🙂 but I can imagine that proper order can change a lot.

Darren, huuuuuuuuge thank you!

---

<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, 2023, 8:52am UTC](https://community.glideapps.com/t/stuck-on-if-else-because-of-lack-of-and/68759/7 "2023-12-23T08:52:28Z")

</div>

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