We cannot create filters that are AND as well as OR, correct?

[Deena]

For example:

email is signed in user OR
email is team manager
AND
archived is not true

I have not found a way to do this and I really want to! Just checking to make sure I’m not missing anything!

[Jeff_Hager]

You are correct, but you can get creative by creating your AND’s in the data editor and just use the OR’s in the filter.

[Deena]

Thank you Jeff! How would I put the and’s in the data editor? sorry haha- I am still learning every day!

[John_Cabrera]

You’d just create a column in the data editor that creates all the conditions you need with AND. Then that column would be one of the OR columns in the component you’re filtering.

[John_Cabrera]

For example:

I want the component to filter when Color 1 is Red AND Color 2 is blue OR Color 3 is green.

In the Data Editor I create an IF - THEN - ELSE column called “Colors 1_2” that checks the Color 1 and Color 2 columns and IF Color 1 is Red THEN true, IF Color 2 is not Blue THEN false, IF Color 2 is Blue THEN true, IF Color 1 is not Red THEN false.

That column will check each condition one after the other and should give you “true” if Color 1 has Red AND Color 2 has Blue… but “false” if either of them doesn’t have its Red or Blue respectively.

Great.

Now go back to your component and filter it as such: Color 1_2 is true OR Color 3 is Green.

[_eric]

John what about when you have tiered and/or conditions?

And this image just involves two tiers…

[Deena]

Ah, okay, now I get it. Thank you so much for the detailed explanation. I have used If/Then/Else but I didn’t think about it for this use case.

[John_Cabrera]

Having trouble understanding what you mean and I could probably get it if I could see the image, but it’s tiny and my eyes just aren’t what they used to be lol

[Robert_Petitto]

New containing screen context for conditions

https://www.youtube.com/watch?v=gP2MWN0udU0&t=320s If you need to have an AND and an OR condition, use an if-then-else column first. For example, let’s say you want to a list of events that can only be edited by the event owner OR any app Admin AND only if the event hasn’t happened. Here’s how: Create an if-then-else column in the data table from where the component resides (let’s name this column “Editors”) Create your OR condition within this if-then-else column. For example, if you wa…

[Deena]

Ah, I knew I saw this somewhere. Thank you!