Cant get a format rule to work

AppSheet AppSheet Q&A
1

I have format rules in place that are working fine to color pins on a map. I am trying to do another format rule which is exactly the same but just reads from a different column and this one won’t work for me.

I have it at the top of the rules list, and I have just copied another rule and changed the formula to include the new source column.

TJK_0-1675732422846.png
TJK_0-1675732422846.png2396×1208 291 KB

The circled pins on the map shown should be pink..

I can’t figure out what I’m doing wrong

Cheers

Troy

2

If you didn’t already, confirm (e.g., using the test feature in the expression assistant) that your expression indeed evaluates to true for the intended rows. For example, if [Scoped] is not a Yes/No type column but rather a Text type column then your expression would need to be [Scoped] = “TRUE” (i.e., with quotes).

3

Thanks so much for the quick reply dbaum!
I have the SCOPED set for Yes/No, but still not working.
Do you have any other suggestions?

4

It is exactly the same as [complete] which works fine???

TJK_2-1675733789532.png
TJK_2-1675733789532.png1659×107 6.96 KB

TJK_3-1675733811283.png

TJK_1-1675733735986.png
TJK_1-1675733735986.png1589×1211 85.4 KB

TJK_4-1675733846110.png
TJK_4-1675733846110.png1641×1220 141 KB

5

Additional details to check in troubleshooting:

  • If you didn’t already, confirm you selected the color using the same property in both rules–i.e., either “Highlight color” (which is the property that I think is applicable to map pins) or “Text color”.
  • Confirm the rules are sequenced to achieve the effect you want. Per Format Rules: The Essentials - AppSheet Help "The rules are processed in order from the first to the last. If two matching rules conflict in their formatting information, the last rule takes precedence. "
6

AHA!
I had it at the top of the list. I put it down the bottom (last) and that fixed it.

Thank you so much mate!