Trouble with comparison in the "only when" field of workflow

I need to execute a workflow only if two value ranges overlap.

I have a Wish with a Min and Max values. And a Good with also Min and Max values. The workflow must be executed when the following formula evaluates to Yes:

max(Wish Value Min, Good Value Min) < min(Wish Value Max, Good Value Max)

In Bubble, the formula should be like this:

Souhait’s Valeur’s ValeurMin ← max → Bien’s Valeur’s ValeurMin < Souhait’s Valeur’s ValeurMax ← min → Bien’s Valeur’s ValeurMax

But the field doesn’t allow me to enter this formula. Im not able to enter the second part of the formula. The ← min → doesn’t appear. See screenshot.

The only when is kind of all over the place…

and you can’t just type < and have Bubble recognize it.

Here’s how I would do it (there are a couple of different ways), this is the easiest, and I hope I spell everything right:

souhaitmin (less than or equal to sign) bienmax AND bienmin (less than or equal to sign) souhaitmax

this should work

This topic was automatically closed after 70 days. New replies are no longer allowed.