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 want where Admin is True OR where email is signed in user, then create two if-then-else conditions:
- if Admin column is True then ātrueā
- if Email is signed-in user then ātrueā
- else āfalseā
- In your component conditions, create your AND conditions. In the Details > Edit > Conditions, you can now create the AND/OR logic by stating Allow Editing where āEditorsā is ātrueā AND where eventDate is after Today.