Bug?: Format Rules are not applied as intended

kosuke
New Member

I have created a Format Rules that changes the color when the value in the column [Total Approved budget 1] is 0.
However, even when the value displayed is not zero, the Format Rules are applied and the color changes. This is not the intended behavior.
When I checked the Expression Result in the Test screen of Format Rules, I found that Y/N was properly calculated according to the column values.
When I delete this Format Rules, the color goes to the default state, so there is no other Format Rules changing the color.
Why does it behave this way?
Is there a workaround?

Tip: [Total Approved budget 1] is a Virtual Column that sums the values of other tables.

3X_2_b_2bdbe54743c4618ea07c07c4b0b53f51f47012b1.png

0 4 153
  • UX
4 REPLIES 4

Steve
Platinum 4
Platinum 4

Did you save your changes after adding the format rule? In my experience, format rules donโ€™t always work properly in the app emulator of the app editor until the changes are saved.

As you say, it may not be reflected properly unless we save after the change.
I also saved and synced, but it doesnโ€™t work properly.

Given that, youโ€™ll want to contact support@appsheet.com for help with this.

Yes even I experienced the same.

Top Labels in this Space