If you haven’t done so, please head over to the Notes Design blog and ideajam and give your input. We have been asking for application icons to allow more colors for as long as I can remember. The application icon is the first thing the user sees and let’s face it, 16 color icons does make the application look like legacy software. So anyways just head over to ideajam and promote the ideas the more votes it has the more likely it will be done.
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?