5.2.2 Accessing Data in the Same Row ('field')
You can access the value in the current row of another column by using the field keyword. For example, field['col_name'] refers to the value in the current row of a column named “col_name.”
Walkthrough
This example continues from Accessing Data in the Current Cell ('value'). It will set the color of the 'Name' column based on the value of the 'Price' column:
1. Select a cell in the 'Name' column. Right-click and choose 'Format'.

2. Select the Color tab. From the 'Text Color' menu select the 'Expression' option, and click the 'Edit' button. This opens the Formula Editor.
3. In the Formula Editor, enter the following expression:
if (field['Price'] > 1000) {
[255,0,0];
} else {
[0,0,255];
}
4. Click 'OK' to exit the Formula Editor, and then click 'OK' to exit the 'Format' dialog box.

The values in the 'Name' column are now highlighted based on the corresponding values in the 'Price' column. This example continues in Accessing Data in Different Row or Column ('row'/'col').
See Also
field, for reference information.
| << 5.2.1 Accessing Data in the Current Cell ('value') | © 1996-2013 InetSoft Technology Corporation (v11.4) | 5.2.3 Accessing Data in Different Row or Column ('row'/'col') >> |