Hello Gliders! My component is COLLECTION and in OPTIONS I would like to filter like this: 1)TYPE is EXPENSE AND 2) UserID is RowID OR UserID is EMPTY But apparently you can only use AND or OR throughout. Can´t you mix AND and OR?

Yes! The if-then-else column solves the issue. Thanks!

No you can’t mix both unfortunately.

Your If-Then-Else would look like this I believe. If TYPE is not EXPENSE then false. If UserID is EMPTY then true. Is UserID is not RowID then false. Else true.

Hola Martín, When this case gets complicated due to new conditionals appearing, I prefer to use this short JS code to handle the logic and use the value “true” as a filter parameter in Glide components. Something like this: if ((p1 == "EXPENSE") && (p2 == "yourRowID" || p2 == "")) return …

I didn’t think about that. You are right, this is so much more powerful!

Please beware of running JavaScript on bigger tables though. If there’s a “native” solution like If-Then-Else, I would prioritize that.

Ok, so this Filtering data with AND and OR - #3 by MaximeBaker is better native solution then.

Again … all will depend on the size of your table and the amount of columns you have to create to get a simple result when you have many OR/AND as conditionals in an ITE column. If I have more than 5-6 conditions and a rare mixture of ON/AND, visually is a little complex understand the logic and wo…

Filtering data with AND and OR

Ask for Help

MaximeBaker December 10, 2024, 9:45pm 3

But, as a workaround, you can make multiple if else then else columns with specifics conditions, negation conditions to make it possible to use only AND or only OR. That is what I usually do!

Topic		Replies	Views
Multiple (IF AND), and multiple (IF OR), How to do that? Ask for Help	6	2646	May 5, 2022
Support for Logic Gates (AND/OR Combinations) Feature Requests	11	193	July 6, 2025
Multi conditions on filtering tables Feature Requests	3	50	January 20, 2025
What's up with Glides AND and OR logic? Feature Requests	1	50	August 13, 2025
Filter combination of ands/ors Ask for Help	3	412	October 21, 2020

Filtering data with AND and OR

Related topics