cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Need to share some code when posting a question or reply? Make sure to use the "Insert code sample" menu option. Learn more! X

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

kborkar
1-Newbie

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.

1 ACCEPTED SOLUTION

Accepted Solutions

Just done it with version 7

In state formatting selected statusstate and then given my parameters

Thank you all for replies...

View solution in original post

6 REPLIES 6
ankigupta
5-Regular Member
(To:kborkar)

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.

ankigupta
5-Regular Member
(To:ankigupta)

Check following link for more details on State Definition: PTC

Already Tried with state formatting but not able to place condition actually i have two values and basis on that i want to change color.

But its displaying that color in every cell of that column.

Doesnt work for me: it always use the default style, and not the one associated to text values

 

nbansal
12-Amethyst
(To:kborkar)

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

Just done it with version 7

In state formatting selected statusstate and then given my parameters

Thank you all for replies...

Top Tags