New Bug Encountered: Inconsistent Format Rules

AppSheet AppSheet Q&A
1

I’ve came across this bug a few times in the past:

I have a Format Rule that changes a columns Text Color to yellow when on a view name Mine Sites.

CONTEXT("View")=Mine Sites

Almost each time I sync the app or click on the view it will randomly result in:

  • Highlight None

  • Highlight All

  • Highlight all but the top row

2X_e_ef88af533c0cc0682b67b8f2c109e756c82aac8c.png
2X_e_ef88af533c0cc0682b67b8f2c109e756c82aac8c.png645×293 15.1 KB

2X_5_53ae9e62e55121f13b087936a61b30ad19ee3447.png
2X_5_53ae9e62e55121f13b087936a61b30ad19ee3447.png641×271 27.4 KB

2X_4_43908902b688e383d0d0cba5ddb0e27856b135aa.png
2X_4_43908902b688e383d0d0cba5ddb0e27856b135aa.png654×267 26.9 KB

2X_c_cec6334b6f046b6e2d9523d1af2d3c43ce2c4dcc.png
2X_c_cec6334b6f046b6e2d9523d1af2d3c43ce2c4dcc.png821×399 15.1 KB

Things I’ve tested:

  • Mobile / Desktop / Editor Emulator

  • tried expressions with and without quotations around the view name

  • Tried the Expression for the Assets View

  • Clearing Browser Cache & Incognito

On all tests I’ve experienced the same inconsistencies

2

Check for other Format Rules that may be competing with this one.

3

It’s a new app with few other Format Rules that aren’t assigned to this table or tables that have refs between them.