Support for Logic Gates (AND/OR Combinations)

[Maazsaeed]

I would like to request support for mixed AND/OR logic

At the moment, Glide allows you to build a group of either:

• All AND conditions
• Or all OR conditions

But there is no way to combine AND and OR inside the same condition block — unless you build computed columns as workarounds.

---

Example of current limitation:
I want to show items when:

(Category is "B" OR Category is "C") AND Supplier is "D"

This type of logic is not possible directly in Glide today — you would have to precompute columns for each sub-condition, or duplicate screens. This gets very cumbersome as the app grows.

---

Why this matters:
Many real-world conditions require mixed AND/OR logic
Reduces the need for workarounds with computed columns
Saves screen duplication
Allows business users to model their processes more naturally
Common in many filter engines and UI builders

---

Workarounds do exist (using multiple columns with IF/Else or template columns), but true built-in support for this would dramatically improve Glide’s expressiveness and reduce complexity in larger apps.

[Darren_Murphy]

@Maazsaeed

I want to show items when:

(Category is "B" OR Category is "C") AND Supplier is "D"

This type of logic is not possible directly in Glide today

Yes it is. You just need to approach things a bit differently. Observe:

• If Supplier is not D, then null
• If Category is B, then true
• If Category is C, then true

That said, see below:

Better and more consistent IF THEN logic

I’ve spent the past few days trying to work out some IF/THEN logic for a side project. The problem is that this is something I could have worked out in a matter of a few minutes with actual code. I’m running into several limitations with the current IF/THEN logic we currently have in Glide. First of all there are inconsistencies between what’s possible with an IF/THEN column, and what’s possible with If/Then logic in visibility conditions or actions. Most importantly, an IF/THEN column only…

[Maazsaeed]

Yes, it is possible but it is a workaround not a built-in feature. I was just saying that if that would be a built-in feature it would be much cooler.

[Darren_Murphy]

Why do you consider my example a workaround?
I don’t.

[Mazen]

It’s a solution for his problem, but it would be nice if Glide’s native filters were a bit more advanced. I’ve worked with systems built in 2009 and had this feature, and I’m sure that it would help and be used in hundreds, if not thousands, of apps.

[Maazsaeed]

I am sorry if my words were not the best, your solution is great sir

[Darren_Murphy]

I don’t disagree with the feature request, in fact I voted for it (although it probably should be merged into Jeffs original feature request, so the votes aren’t diluted).

The point I was trying to make (not very well) is that the native if-then-else column is a lot more powerful than it might appear. And it is in fact possible to create quite complex matching logic within a single column.

[Mazen]

I do agree on merging it.

[Maazsaeed]

Thank you

[Maazsaeed]

Thanks

[gvalero]

@Maazsaeed

Example of current limitation:
I want to show items when:

(Category is "B" OR Category is "C") AND Supplier is "D"

This type of logic is not possible directly in Glide today — you would have to precompute columns for each sub-condition, or duplicate screens. This gets very cumbersome as the app grows.

Hola!

Here we talked about this topic and the workaround as well Filtering data with AND and OR - #7 by gvalero