Input Validating Rules

Input Validating Rules
 
Input Rules.  Validating rules can be applied to input columns to modify the values used during a validating cycle.  The values can be set to lowest, highest, median or average and applied to all rows.  The actual values can also be multiplied by a constant.
 
The validating rules edit dialog is produced when the  toolbar button is pressed or by using Edit > Rules menu command.  The dialog is used to step through the columns and set or reset the rules.  Any rules that are changed are set by moving to a different column.  Rules can be reset and deleted by pressing the Reset Rules button.
 
1

First

1. FirstClick to move to the first column.
 
2

Previous

2. PreviousClick to move to the previous column.
 
3

Next

3. NextClick to move to the next column.
 
4

Last

4. LastClick to move to the last column.
 
5

What to use

5. What to useSelect the value to use in the input column.
 
6

Adjuster

6. AdjusterEnter the multiplier to adjust the value.
 
7

Reset Rules

7. Reset RulesClick to reset the rules for this input column.
 
8

Close

8. CloseClick to close the dialog.
 

Created with help of DrExplain