šŸ†• 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:

  1. Create an if-then-else column in the data table from where the component resides (letā€™s name this column ā€œEditorsā€)
  2. 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:
    1. if Admin column is True then ā€œtrueā€
    2. if Email is signed-in user then ā€œtrueā€
    3. else ā€œfalseā€
  3. 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.
7 Likes