I have a table populated with a SQL Query containing values that vary from 'OK' if the parameter is accepted, 'X' if it isn't measured and a float/integer if the parameter is not accepted therefore returns the measure error.
I would like to color the single cells that contain numbers to showcase the wrong parameters and make it easier to recognise them quickly.
I tried using many methods: propertyChange scripts, the built-in background mapping function, property bindings etc. but i haven't managed to successfully do it.
If any other info is needed I'm open to share. Thanks.
Use a Power Table and write a configureCell extension script for it. It will be called for every displayed cell and can customize the display.
Make sure that the script does no tag reads or SQL callouts or API calls--it doesn't have time for that. If you need more information than what is already present in the table's data, use custom properties on the component to pull in all the extra information you need, in bulk, then look up the right parts in the script.
I ended up using the getBackgroundAt method in the normal table because I didn't notice your reply. Will definetly try configureCell if I'll have some more complex cell personalization issues. Thanks!
