Skip to main content
K
kborkar1-Visitor
1-Visitor
February 9, 2017
Solved

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

  • February 9, 2017
  • 2 replies
  • 4467 views

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.

Best answer by kborkar

Just done it with version 7

In state formatting selected statusstate and then given my parameters

Thank you all for replies...

2 replies

A
ankigupta5-Regular Member
5-Regular Member
February 9, 2017

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.

    A
    ankigupta5-Regular Member
    5-Regular Member
    February 9, 2017

    Check following link for more details on State Definition: PTC

      N
      nbansal14-Alexandrite
      14-Alexandrite
      February 10, 2017

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

        K
        kborkar1-VisitorAuthorAnswer
        1-Visitor
        February 10, 2017

        Just done it with version 7

        In state formatting selected statusstate and then given my parameters

        Thank you all for replies...

        Terms & ConditionsAccessibility statement