Formatting rule results unexpected

AppSheet AppSheet Q&A
1

I’ve created a formatting rule to show me when a shipment has an adjustment but I am getting unexpected formatting on the ref lists.

Aaron_Blau_0-1738872482979.png
Aaron_Blau_0-1738872482979.png849×975 59.8 KB

Aaron_Blau_1-1738872600411.png
Aaron_Blau_1-1738872600411.png2083×1153 193 KB

Is this expected behavior? If so, is there any workaround?

On the “Related SO Assignments” ref list, only two of the three entries are adjustments so it would be preferred if I could setup different formatting on that list but the formatting on the SO Difference view seems to be overriding it.

2

For the rows in your image that are highlighted in yellow, they must be a REF columns “pointing” to the SOFreight row. The SO column is being used as the Label column representing the row. It will still be subject to the Format Rule.

If you want them colored Red only in the Shipping analysis view then you can adjust your Format Rul like this:

AND(CONTEXT("View") = "Shipping Analysis", 
    [HasAdjustment] = TRUE
)

I hope this helps!

3

Beautiful, thanks so much!

4

Hmm, so after a bit of testing I see that the view works as long as a record is not selected, as soon as I select a record and the detail is displayed the formatting disappears, is there a way to refer to the view with the detail being displayed?

Aaron_Blau_0-1738881494527.png
Aaron_Blau_0-1738881494527.png1243×1024 93.2 KB

Aaron_Blau_1-1738881534240.png
Aaron_Blau_1-1738881534240.png1454×710 90.4 KB

5

This is the fairly new Desktop Mode. I do know for a long while Format Rules and CONTEXT() were not supported. However neither of these previously known issues is listed in the documentation as “known issues” so the assumption is that they should be working normally.

This presentation style is new in the new Desktop Mode and maybe they don’t have all the kinks worked out yet. In my opinion, the formatting should remain on the “Shipping Analysis” view - even when the Detail View of a row is opened. I would open this as an issue to AppSheet Support.

You can work around this by adding another column, such as a Virtual Column, defined as Text and assigned the SO value (in text form) from the SOFreight row. Apply the Format Rule to this new column in the same way as you initially did (no CONTEXT() expression). Then replace the current SO column with this new SO column ONLY in the views where you want to see the formatted value. From a visual aspect it will look exactly the same and you do not lose any functionality.

The other option is to revert back to the original Format Rule you had and just let it get applied everywhere.

I hope this helps!

6

Ok, I’ll see if I can get a workaround going, thanks again for you input.