First, column labels are NOT affected by Format rules.
Second, it looks like your text values (the numbers) do have a Format rule that is applying a Yellow color. NOTE: In the case of overlapping Format rules, the last one applied wins. Check if there might be another Format rule that is overwriting the red or green colors with Yellow.
In the Format rules, Text color is controlled separately from the Highlight color. Highlight is some icon you have selected. If no icon chosen then AppSheet uses the dot.
The Text to be colored requires 2 properties being set:
See the Blue annotations for Text Coloring Format
There is no Format rules overlapping or overwriting the ones that is shown on the pictures.
Highlight color and Text color formats are correctly set, I set both values in each Format rule with the same selection of color, but it seems that the cell value is not changing color as it supposed to do…
Check this other pic:
Soporte_GestionApp:
but it seems that the cell value is not changing color as it supposed to do…
In this example the color is correct…right?
I know you said everything is set correctly but I wonder if there is something being overlooked? It’s such a simple use case.
Without more details, the only other suggestion I can make is to NOT depend on ordering of the format rules. Instead, set the criteria to be distinct so that one and only one Format rule can be applied.
For example, set the criteria in Yellow to be:
AND([Airemedico_5_8_Bar] < -0.39, [Airemedico_5_8_Bar] >= -0.59)
And in Green, set it to:
AND([Airemedico_5_8_Bar] < -0.59, [Airemedico_5_8_Bar] >= -0.80)
The other two can be left as is.
NOTE: You are probably aware but thought I’d mention, no formatting is applied if the value is between -0.39 and 3.79 (inclusive)
Have you saved your format rules. Sometimes the emulator looks a bit strange until the formatting has been saved.
I did
I have found on rare occasion you need to refresh the editor web page itself for UI related changes to take effect sooner rather than later. I think at times there is a delay in changes being actually reflected - at least in the editor.
Soporte_GestionApp:
May be it´s an expression error…or a bug…?
I would check for rounding. In other words, what value is saved in the datasource?
Since we can’t see how you actually implemented things in your app, I would recommend reaching out to AppSheet support for more help.
That´s what I did thanks!
These overlap:
If [Gasoil_50_100] is less than 40, the second rule will be applied–not the first–because less than 40 is also less than 50.
As noted previously:
WillowMobileSystems:
Second, it looks like your text values (the numbers) do have a Format rule that is applying a Yellow color. NOTE: In the case of overlapping Format rules, the last one applied wins. Check if there might be another Format rule that is overwriting the red or green colors with Yellow.
I understand that, but how can I format these rules?
I need to have some expression that works, so if is less than or grater than, is a red, yellow or green flag.
If an If or Ifs condition doesn´t work in format rules, how can I do it?
Soporte_GestionApp:
If an If or Ifs condition doesn´t work in format rules, how can I do it?
I gave you two example expressions for two of your rules above to implement a discrete Format rule. You just need to replicate that pattern for all other similar rules.
WillowMobileSystems:
AND([Airemedico_5_8_Bar] < -0.39, [Airemedico_5_8_Bar] >= -0.59)
I thought AND it was used only if all the conditions inside the AND expression are true, and if there is a condition that does not match, the AND is false.
I never use it this way, can you explain me the difference please?
As * AND(..., ..., ...) requires all conditions must be TRUE.
Then should be AND(OR(…,…)) am I correct?
Or an IN condition maybe?
Soporte_GestionApp:
I thought AND it was used only if all the conditions inside the AND expression are true, and if there is a condition that does not match, the AND is false.> I never use it this way, can you explain me the difference please?
You are correct. The expression is basically checking the column value is BETWEEN the conditions.
If by “difference” you mean the difference between a discrete format rule and relying on order of Format Rules, there is, in this case, no difference… IF you get the conditions right AND the order right. As @Steve pointed out, a couple of your rules were out of order. Trying to get it right can be frustrating.
Implementing discrete Format rules means you know exactly which rule was supposed to apply. It becomes easier to analyze. You are also forced to think about the conditions, especially the boundary conditions.
Soporte_GestionApp:
As *
AND(..., ..., ...)requires all conditions must be TRUE.> Then should be AND(OR(…,…)) am I correct?
No. AND() is sufficient. Think of it this way:
"lower bound" < [column value] < "upper bound"
The “lower bound” must be < value AND value must be < “upper bound”
Then it’s just a matter of determining if the bounds should be included in the range or not.
It is indeed quite frustrating sometimes!
Thanks a lot for the comments and guidance! @WillowMobileSystems @Steve