I'm a bit lost in your explanation, but if this is true, then the result is correct:
- flag_invoiced -> green fill
- Open -> yellow fill.
Then because the evaluation is done Top -> bottom and does not stop at first true test (it's not a switch/case statement), then, because the 2 formattings operate on the same attribute (fill), the last one wins.
On the left, the test on Open comes last -> yellow
on the right, the test on flag comes last -> green
seems perfectly right to me.
Sorry, my explanation wasn't great so based on what I originally wrote then yes you are right but according to FileMaker on conditional formatting it evaluates from top to bottom which makes the left fail. because it should make the left image green and the right orange. It's rare that I would use 2 different fields like this, most of the time it's the same field with different values so no issue. Just seemed odd.
1 of 1 people found this helpful
James, do you need an "AND" or "OR" condition in your formula based on the two fields tested?
2 of 2 people found this helpful
Not only according to FileMaker, but you have a good proof of it on your screenshots.
I don't know how to explain it better. Let's try.
On the left.
t1 - FileMaker evaluates the 1st (top) condition : flag_invoiced = 1, which is True. So it fills the object with Green
t2 - THEN FileMaker evaluates the 2nd (bottom) condition : status = "Open", which is also true, so it fills the object with Orange. (I would actually call this Yellow, but this is another discussion )
Because Orange replaces Green (same attribute), you see Orange.
Maybe, to understand try to add a font color formatting to your first (top) condition, and not to the 2nd. You'll see it applies as well.
That was it, in my mind it was working like a case statement and that is not the case so that with and AND clause and its good. 99% of the time I am only using the same field with different values.