It looks like right now it is not possible to create nested conditions in Automations for the Trigger.
For instance, my trigger would say:
Either part 3a or 3b will fulfil the point # 3.
I know this can be done by adding the OR conditional field (for 3a and 3b) right in the table and then reference the # 3 condition here without using OR statement.
Just wanted to confirm this is currently a limitations, correct?
Correct, you can’t nest AND/OR filters, but you can do that inside a Formula field and use that as the trigger.
IF(AND(1, OR(2, 3)), "true", "false")
I think adding in nested conditions to automations would be a powerful addition - right now, the workaround of building formulas is a little non-intuitive and particularly difficult if you are passing on an automation to a new team member!
In general, it would be valuable if the automations in Airtable were able to use more advanced formulas like the formula field.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.