You can use AND/OR logic for triggering automation in Airtable, so your 1. and 2. suggestion can be done.
As for number 3. I agree it would be really nice and useful addition to add ability to combine AND & OR, it would help a lot, and in our case reduce the number of separate automation we need to build to cover all use cases. Would make life simpler and also provide opportunity to construct some more advanced automation.
@Marko.Petrovic Airtable only allows one trigger per automation, so how is it possible to use AND/OR logic? Perhaps I missed something?
Well I might have not been specific enough, not all trigger types support this (although for some like when record is created and enters the view kinda doesn’t make sens i guess, although there are workarounds you can do with custom views for those) but if you use when record matches condition, where this makes most sense, you can use AND or OR logic

Ohh I see what you mean, that makes sense. Thanks for your quick response. I’ll update my question at some point.
YES!!!! I have maxed out automations because I need conditional triggers. I do not need up to 25 actions per scenario trigger, I just need more scenarios (conditional triggers) to cover all my bases and keep my data straight.
You can use AND/OR logic for triggering automation in Airtable, so your 1. and 2. suggestion can be done.
As for number 3. I agree it would be really nice and useful addition to add ability to combine AND & OR, it would help a lot, and in our case reduce the number of separate automation we need to build to cover all use cases. Would make life simpler and also provide opportunity to construct some more advanced automation.
Unfortunately, I need both AND & OR in one trigger, and in what I'm doing, it's not allowed. So I have had to make more separate automations and have run out.
bring this feature please!!
Why is it not possible to set a trigger like:
when a new record is updated and matches a condition...