Skip to main content
kborkar1-Visitor
1-Visitor
Feb 9, 2017 5:53 AM UTC
Solved

Can we update a cell color of a grid on basis of its value

I have my data in data table and i am displaying that in grid in mashup.

Can i update particular cell color on basis of its value.

for example,

if cell contains value 'ON' than that cell should be displayed with green color.

And if cell contains value 'OFF' than that cell should be displayed with red color.

kborkarAnswer
1-Visitor
Feb 10, 2017 1:15 PM UTC

Just done it with version 7

In state formatting selected statusstate and then given my parameters

Thank you all for replies...

View in thread

6 replies

ankigupta5-Regular Member
5-Regular Member
Feb 9, 2017 11:52 AM UTC

Hi Kedar Borkar​, Yes That's possible.

Just click on the drop down icon on the top left of the Grid.

Then configure the Column containing ON OFF details.

Go to Column Renderer & State Formatting Tab and select State-based Formatting

Set the dependent field as your column.

Set the State Definition. You might have to create one if you haven't already that defines the state and color.

I Hope it helps.

Translate
    ankigupta5-Regular Member
    5-Regular Member
    Feb 9, 2017 11:53 AM UTC

    Check following link for more details on State Definition: PTC

    Translate
      nbansal14-Alexandrite
      14-Alexandrite
      Feb 10, 2017 10:06 AM UTC

      Hello Kedar, which version of Thingworx are you working on?

      Translate
        kborkar1-VisitorAuthorAnswer
        1-Visitor
        Feb 10, 2017 1:15 PM UTC

        Just done it with version 7

        In state formatting selected statusstate and then given my parameters

        Thank you all for replies...

        Translate
        Terms & ConditionsAccessibility statement