Home : Products : Hach WIMS : Hach WIMS Client : Documentation : Basic Concepts : Data : Hand Entry : How to change Monthly Data Entry Background Colors for Entry and Daily Violations
Q14202 - INFO: How to change Monthly Data Entry Background Colors for Entry and Daily Violations

ADVANCED USERS ONLY!

When entering data in Monthly Data Entry, the background color is set if the value entered is an Entry Range Violation, Daily Limit Violation, or both.  The default colors are:

Value is outside of Entry Limit Range
Value is a violation of the Daily Limit

Value is both a Daily Limit Violation and is outside the Entry Limit Range

In certain cases, you may want to set different colors.  NOTE: The defaults are STRONGLY RECOMMENDED and should only be changed if there is a display issue.  You must update the ENTRYVIOLBACKCOLOR, DAILYVIOLBACKCOLOR, and ENTRYANDDAILYVIOLBACKCOLOR Settings in the OPSROOT.GENERALSETTINGS Table.  Use the CUSTOMSQLROOT Action Script to execute the following statements.    

Example set the Daily Violation backcolor to Yellow:

UPDATE GENERALSETTINGS SET CURVALUE = '65535' WHERE KEYVALUE= 'DAILYVIOLBACKCOLOR'

Where '16776960' is the Color Value.  Color value can be calculated with the following formula using the RGB components of a color.

R + G * 256 + B * 256 * 256 

Example Yellow is R=255,B=255,G=0, therefore Yellow = 65535.

 

To reset to defaults:

UPDATE GENERALSETTINGS SET CURVALUE = '13500362' WHERE KEYVALUE= 'ENTRYVIOLBACKCOLOR'

UPDATE GENERALSETTINGS SET CURVALUE = '13303806' WHERE KEYVALUE= 'DAILYVIOLBACKCOLOR'

UPDATE GENERALSETTINGS SET CURVALUE = '9486586' WHERE KEYVALUE= 'ENTRYANDDAILYVIOLBACKCOLOR'

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 5/5/2014 4:14 PM.
Last Modified on 5/5/2014 5:01 PM.
Last Modified by Scott Dorner.
Article has been viewed 2098 times.
Rated 5 out of 10 based on 1 vote.
Print Article
Email Article