Then, assign the column a formula that will evaluate to either a list of three numbers between 0 to 255 or a list of six numbers also between 0 to 255. If you send only three values that will become the RGB color for the text and if you send six values the first three will become the RGB for the background and the other three will be for the text. It is also good to mention that these colors will take effect on all columns right of the color column, so it is not a good idea to create this column at the end of the view.
Example of values for column:
255:0:0 – Red Text
143:255:87:0:0:0 – Green background with black text
255:0:0:0:0:0 – Red background with black text
The documents in the application I’m planning to use this technique on are measured in minutes and not on days, so I would schedule the agent to update the view column formula every 5 minutes instead of nightly.
So now I ask, what kind of performance impact would this have on the database if any?