Set quality of table data cell by scripting

#1

Is it possible to control the quality overlay of a table cell by scripting?

In my case I want to perform some data validity checks in a table where the user can edit the cell values. If the cell value is “out of range” i want the cell to have a bad quality overlay.

0 Likes

#2

I’m not sure about adding a tag/component overlay to a cell, but why not just change the background fill to red when value is out of range, or something along that line?

0 Likes

#3

Filling in for ald (my colleague).
We did do this. The reason for the question is that we want an easy way to check if ALL the data in the table is “valid” or not.
What we would like to do is set and reset a custom parameter “dataValid” on the table component depending on the content.

However I’m sure there are also other ways to accomplish this. If we only work with background colour of the cell then we would need a script that loops through each cell and retrieves the actual color.

What is considered best practice?

0 Likes

#4

if you are binding tags to individual cells in a table, you could probably use tag expressions. Check to see if your value is within tolerance, if not use forceQuality to change the tag quality. Also tags have engineering limits that can enforce tag quality

0 Likes