When used in an expression, cellValue is essentially a variable whose value is determined by the rule Column that executes. Using cellValue in a Condition or Action expression eliminates the need for multiple, separate Rows to express the same logic.
This sample Rulesheet uses cellValue to increment integer1 by the amount in the Action Cell of the rule Column that fires. An equivalent Rulesheet which does not use cellValue is also shown for comparison purposes.
Equivalent Rulesheet without using cellValue:
SAMPLE RULETEST 1
A sample Ruletest provides two examples of boolean1. The following table shows Input and Output panels.
RULESHEET EXAMPLE 2
The following Rulesheet uses cellValue to evaluate whether collection1 includes at least one member with a string1 value of the entry in the Conditions Cell of the rule Column.
SAMPLE RULETEST 2
A sample Ruletest provides three examples of collection1 – each member has a string1 value. Input and Output panels are shown below.
RULESHEET EXAMPLE 3
The following Rulesheet uses cellValue to create a new member of collection1 with string1 value equal to the Action Cell in the rule Column that fires.
SAMPLE RULETEST 3
A sample Ruletest provides string1 values for three examples. The following illustration shows Ruletest Input and Output panels. Notice that each collection1 already has one element prior to executing the test. This simply ensures the results will be displayed in hierarchical style.
