# Perspective Table, dataset help

**URL:** <https://forum.inductiveautomation.com/t/perspective-table-dataset-help/53816>\
**Category:** Ignition\
**Tags:** ignition81, perspective\
**Created:** [December 6, 2021, 8:59pm UTC](https://forum.inductiveautomation.com/t/perspective-table-dataset-help/53816 "2021-12-06T20:59:44Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![mjohnson0238](https://avatars.discourse-cdn.com/v4/letter/m/4bbf92/32.png) [@mjohnson0238](https://forum.inductiveautomation.com/u/mjohnson0238)\
**Post date:** [December 6, 2021, 8:59pm UTC](https://forum.inductiveautomation.com/t/perspective-table-dataset-help/53816/1 "2021-12-06T20:59:44Z")

</div>

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:

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/8/3/83af7120474b97a325554ed8b91211dc890ff22d.png)

My Table looks like this:

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/d/9dfee0e5993b83ada7562c31fdf156605982513c.png)

Much thanks in advance for the help!

---

<div class="post-metadata">

**Author:** ![victordcq](https://avatars.discourse-cdn.com/v4/letter/v/f6c823/32.png) [@victordcq](https://forum.inductiveautomation.com/u/victordcq)\
**Post date:** [December 7, 2021, 8:01am UTC](https://forum.inductiveautomation.com/t/perspective-table-dataset-help/53816/2 "2021-12-07T08:01:24Z")

</div>

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.  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/4/6/4634d8c597eaf51ab4f694802232219a05a6b023.png)

some script inspiration:

> [@Perspective table cell color](https://forum.inductiveautomation.com/t/perspective-table-cell-color/50047/4):
>
> 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