| #1 Ranking: Read how InetSoft was rated #1 for user adoption in G2's user survey-based index |
|
Read More |
The following expressions allow you to access any cell in a table by absolute reference.
table[rowIx][colIx]
data[rowIx][colIx]
Simply set the rowIx and colIx indexes to specify the position of the desired cell. For example:
• table[0][0]: Value in first row, first column.
• table[2][4]: Value in third row, fifth column.
You can type these keywords manually into your script, or you can click the appropriate node on the 'Component' tree in the Script Editor.
You can use absolute and relative references in the same statement, as the following example illustrates.
It will set the header cell of the 'Price' column to show a red background if there exists a price exceeding $2000, and will otherwise show a green background. This requires a loop structure, as well as mixed absolute and relative references:
1. Select the header cell in the 'Price' column. Right-click and choose 'Format'.
2. Select the Color tab. From the 'Fill Color' menu select the 'Expression' option, and click the 'Edit' button. This opens the Formula Editor.
3. Add the following script in the Formula Editor: for (i=1; i 2000) { [255,0,0]; break;} else [0,255,0]; }
4. Click 'OK' to exit the Formula Editor, and then click 'OK' to exit the 'Format' dialog box.
The header cell is read because a price exists that exceeds $2000. To test the header cell script, add a Range Slider to filter the values in the table. Follow these steps:
5. Drag a Range Slider from the Component tree into the Viewsheet. This creates a new Range Slider.
6. From the 'ProductInfo' Data Block in the Component tree, drag the 'Price' field onto the Range Slider. This binds the Range Slider to the 'Price' field.
7. Drag the right side of the Range Slider to vary the prices included in the dataset. Observe the color of the header cell as the dataset changes.