B.1 Cell on the Current Row

Formulas run in the scope of the current row. Each cell value on the current row can be accessed by indexing into the 'field' array using the appropriate column name or column index. The syntax is as follows:

field['column name']

e.g.,

field['quantity']

field[column idx]

e.g.,

field[3]

For example, if 'quantity' and 'price' are two columns in the current table, a formula column in the same table can use the expression

field['quantity'] * field['price']

to produce the product “quantity*price” for every row of the 'quantity' and 'price' columns. To access the cell values of a different table, see Appendix B.4, Cell of Any Table.

<< Appendix B: Accessing Table Cells in Script © 1996-2013 InetSoft Technology Corporation (v11.5) B.2 Cell on a Previous Row >>