Perspective Table, dataset help

[mjohnson0238]

Im looking for someone to help me craft some scripting to make my dataset table change a row/cell color to red if the 'Delivered" column has a timestamp and the “Quad_Scan” column has ‘Not Scanned’ in the row/cell.

I am using this Named query to get table data:

My Table looks like this:

Much thanks in advance for the help!

[victordcq]

The whole row or just the one cell?

if you set your query to get json format
you can change the enter to have value and style. look at the table the first cell is orange, you can do the same for the whole row.

some script inspiration:

Perspective table cell color

it might be easier to use “getColumnNames()” instead of “getColumnCount()”, so you dont have to worry about sorting indexes this: for col in value.getColumnNames(): .... if col == 'LED': ... row_object[col]=cell_object instead of: for col in range(value.getColumnCount()): ... value.getColumnName(col) == 'LED' ... row_object[value.getColumnName(col)]=cell_object