How to Filter a list with a few logical operators? like (and and )or I want to filter by signed User and date Or if no sign up then don’t filter

Just add additional conditions! [Glide_·_Create_Apps_from_Google_Sheets-2]

Hello. I understand what you are talking about. It seems to me that it is impossible now. I can suppose this solution: Make two inline lists, one of them will be visible only for signed user and it will be filtered specifically for them. The other one will be visible for those who is not signed and it will not be filtered. Maybe there are more elegant solutions but it is the one that I came up with right now.

Hey Robert, If you add another condition it will have the same operator as the previous one. As you can see in my question i need to use both “or” & “and”. Is there a way to do that? I I should use a sheets formula?

Yes, I do it that way also. I have an app with 2 types of users and I need to make each time 2 inline lists with visibility conditions for each.

Ah…gotcha. Yeah…You might need to use a template column that combine the “ands” and then use that as one of your conditions. Then use the OR in the actual filter. If that doesn’t work, create two lists and set the visibility conditions to only display for signed in user or not.

Read from this post to the end of the thread. [image] BUG in visibility Report a Bug It’s kind of limiting, but I think that’s how it’s designed right now. How are you attempting to check your conditions: (When Color is Blue AND When Switch1 is TRUE) OR When Order isn’t EMPTY It is it like this: When Color is Blue AND (When Switch1 is TRUE OR When Order isn’t EMPTY) I suppose it’s limited to only ANDs or ORs because there is no way to differentiate order of operations with parenthesis. In programming languages, the OR always takes priority it it’s True and no paren…

It crossed my mind the issue is that you cant use logical operator in a template column So no Combinations as you proposed. Im trying the second idea. I made a new tab and made it detail layout. Added a list to this layout The source of this list is a sheet the using the ARRAYFUNCTION to copy columns and data from other sheet. The problem is when i try to condition the visibility of the list he retrieves the properties from a category sheet and not the one I intended to(items). How to fix it?

[image] Double feed button discovery Ask for Help Enabling favorites will do this automatically, but if you want your own version to work the way you want, then check out https://6pbvq.glideapp.io/. For you it comes down creating a sheet and then creating a user specific column in that sheet to hold the choice component value. You will display this sheet as your tab. Based on the the selected choice value you will show one of 2 lists. One that’s filtered and one that’s not. My example app uses a complicated set of relations, lookups and fo…

Filter Inline list with 3 Conditions

Ask for Help

Jeff_Hager April 29, 2020, 8:05pm 8

Read from this post to the end of the thread.

Topic		Replies	Views
Filter combination of ands/ors Ask for Help	3	430	October 21, 2020
Logical Math Column Feature Requests	1	564	September 29, 2020
Visibility conditions - AND/OR Ask for Help	2	57	November 27, 2024
Visiblity Conditions Ask for Help	3	192	November 16, 2021
We cannot create filters that are AND as well as OR, correct? Ask for Help	9	781	August 21, 2020

Filter Inline list with 3 Conditions

Related topics