Multi-option split workflow step: condition doesn't work

I have four conditions with different workflow steps:

This is the formula:

quote_id is null (Supabase)

The correct result would be the third option, i.e. “quote_id=null and quote”.

However, the split always uses the last option.
I also tried to use quote_id != null but this doesn’t work either. What is wrong here?

Note: quote_id and own_p_id are numbers.

BTW: Probably the same issue applies to “own_p_id>1 and project” (not tested yet).

Hey @BertrandG :wave:
I feel like it’s a bit hard to read, and to debug.
In your formula you are checking 2 different values (own_p_id and Project or Quote). Maybe splitting your condition in 2 would make this easier. You’d have 2 Multi-option split, the first one can check if it’s a quote or a project, then the second Multi-option split can check the other property.
Does that make sense?

Hi Jean-Philippe,
That was a good idea! I did what you suggested and it works. Thank you!

It seems the “is not null” condition in my multi-split doesn’t work; only = null works. I’m now only checking for “= null” and the other branch automatically is for “not null”.

1 Like