How would you go about triggering an automation with an OR vs an AND. In this case I want it to trigger if the Status is PTO OR No Travel. The only options appears to be AND in which case it’ll never run because it will never be both…
I suppose you could do this with multiple autmations but seems silly to have to do that.
Rats. Really need some booleans in there to be able to do more complex automations.
1 Like
GCavin
(Gilles Cavin - Reinventing Formulas in monday.com)
4
HI Sean,
I know this is not necessarily what you have in mind, but if you need to create complex formulas, you may want to take a look at the Advanced Formula Boosters. You’ll get all the flexibility you need to create formulas (up to 100 lines of codes, the ability to cast results to any type of columns, the ability to use variables, etc.).
Indeed, there’s no OR option available. I have resolved this by using ‘is not’ for all the other options.
So basicly add ‘and only if category is not …’ for all the categories besides PTO and No Travel.
I can see a request for the “OR” operator in automation already from Jul 2021, it is interesting, that the devs never addressed this issue in the past 3 years.
If Monday wants more technical people to use the product, we need more built-in features. We struggle every day with the limitations of the Monday boards. Monday looks cool, but lacks lots of essential basic features to use it as a helpful dynamic presentation tool. Also, our company does not subscribe to paid automations and integrations, so we can only use built-in features, and we think twice before we start to use Monday for any complex tasks.
One very important feature would be an instant undo, as if we accidentally change a value, there is no way to restore it without knowing the original value. We cannot make board duplicates every minute to keep them safe.
The new Workflow Builder doesn’t even support it - it actually doesn’t seem to support multiple conditions together. You have to chain multiple conditions as branches. In this case you could put the first condition, and the yes path does what you want, and the no path then checks your “or” condition and then duplicates the actions. Might as well do two recipes in the regular automations at that point!
Hi,
Maor from Automations.
In the workflow builder, you can now select multiple values in the “If item in group” and “if status changes” conditions using the 'Is any of" field.
This is the first step of supporting ‘OR’ condition.
We familiar with the requirement. It is taking into account compare to other priorities.