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 . FirstFirst

First

Click to move to the first column.

 

2 . PreviousPrevious

Previous

Click to move to the previous column.

 

3 . NextNext

Next

Click to move to the next column.

 

4 . LastLast

Last

Click to move to the last column.

 

5 . What to useWhat to use

What to use

Select the value to use in the input column.

 

6 . AdjusterAdjuster

Adjuster

Enter the multiplier to adjust the value.

 

7 . Reset RulesReset Rules

Reset Rules

Click to reset the rules for this input column.

 

8 . CloseClose

Close

Click to close the dialog.