Hello everyone, For an application, I am trying to change the color of individual cells in the “names” column based on its results. [image] I am not able to find a good way to do it and would appreciate your kind help. Thank you!

you'd have to put a transform script like this in the data prop [image] Perspective table cell color Ignition Thanks for your help. That has cleaned up the code a little. I’ll work on sorting the key order in the json string later. output_json = [] style_red = {"b…

[image] Change style of cell (component Table) via script - Perspective Ignition Hi @truonghaibk94 this may be best done in a script transform of the database binding. You can loop through the dataset and form an array of dictionaries for each element like this: data [ …

Thank you very much, @victordcq and @cmallonee ! I followed the code below. It worked for the whole row, however, it did not work for the individual cell: output_json = [] style_red = {"backgroundColor": "#FF0000"} style_green = {"backgroundColor": "#00AA00", "fontWeight": "bold", "fontSize": …

You are missing an ':' after the if checking Flash and pass [image] pkhoshroo: col) == 'names': if value.getValueAt(row, col)=='Flash' cell_style= style_red elif value.getValueAt(row, col)=='pass' cell_style= style_green =='Flash': ... =='pass':

You are correct! Nice catch! I have not even seen that!!! However, I cannot see any colors in my table now. I tried both scripts. It should be red on “Flash” cell and green on the “pass” cell. [image] I tried the following code for “ref_vac_result_id” column and it worked, but same code does no…

I realized the problem. The text “Flash” in the table was “Flash…spaces…” with a lot of spaces in front of it. That is why I could not see any colors. Thank you for your help AS ALWAYS, @victordcq !

No problem:) You could use .strip() to remove leading and trailing spaces value.getValueAt(row,col).strip() It might be a good idea to do that before you save the values into the database too or wherever you get those values from

Great information! Thank you very much, Victor! :slight_smile:

I tried the same code for one of the table but it is not working as shown below: [image] The script change done and is shown as below: output_json = [] `Preformatted text`style_red = {"backgroundColor": "#FF0000"} style_green = {"backgroundColor": "#00AA00"} for row in range(value.getRowC…

Could you copy props.data and either paste it here or send it to me as a private message? Do you have any styling applied to the column as a whole? Examine props.columns[2] for any styling.

Cell Color in Perspective Table

Ignition

cmallonee September 14, 2021, 6:28pm 2