# Table Data Input Field with AutoCalculate
## 1. Overview
The Table field lets you:
* Import CSV data
* Edit or fill it manually
* Use the data in AutoCalculate expressions
## 2. Expression Helper: table
Inside AutoCalculate expressions, a helper object named table is available with the following functions:
* table.keys(tbl) → string\[] – returns ordered column names
* table.rows(tbl) → Record\\[] – returns an array of row objects (data rows only)
* table.cell(tbl, rowIndex, keyOrIndex) → unknown – accesses a cell by row and column
* table.col(tbl, keyOrIndex) → unknown\[] – returns a whole column (by name or index)
* table.num(value) → number – tolerant number conversion (''/text → 0; '1,23' → 1.23)
{% hint style="info" %}
Note: Expressions run as JavaScript with the current document bound as this, so you can reference table fields directly by their schema names (e.g., field20).
{% endhint %}
## 3. Headers & Indexing
* The first CSV row is treated as the header (column names).
* Data starts at the second CSV row; in the API this is row index 0.
* Row and column indices are zero-based (0, 1, 2, …).
* If your CSV has no meaningful headers, the first row is still used as the header. To avoid relying on header text, use numeric column indices (0, 1, 2, …).
## 4. Cell Map Example
Sample table:
| Product | Qty | Price |
| ------- | --- | ----- |
| 1 | 1 | 3 |
| 2 | 4 | 5 |
| 3 | 6 | 8 |
Coordinates of data (zero-based):
* (0,0)=1, (0,1)=1, (0,2)=3
* (1,0)=2, (1,1)=4, (1,2)=5
* (2,0)=3, (2,1)=6, (2,2)=8
## 5. Access Patterns
### 5.1 By Column Name
table.col(field20, 'Price') // entire 'Price' column from table field20
### 5.2 By Column Index (no headers dependence)
table.col(field20, 2) // third column (index 2)
### 5.3 Single Cell by Coordinates
table.cell(field20, 1, 'Qty') // row 1 (second data row), column 'Qty'
table.cell(field20, 2, 2) // row 2, column index 2
## 6. In-Table Calculations (Single Table)
### 6.1 Sum of a Named Column (Price)
table.col(field20, 'Price').reduce((s, v) => s + table.num(v), 0)
### 6.2 Sum of a Column by Index (third column)
table.col(field20, 2).reduce((s, v) => s + table.num(v), 0)
### 6.3 Specific Cells + Power
Access cells by coordinates only (works even if headers are not meaningful):
```
Math.pow(
table.num(table.cell(field20, 1, 1)) + // Qty[1]
table.num(table.cell(field20, 2, 2)), // Price[2]
2
)
```
## 7. Cross-Table Calculations & Other Fields
### 7.1 Sum a column from field20, add a column from field30, add a numeric form field field21, then square the total
```
Math.pow(
// sum of 'Price' from field20
table.col(field20, 'Price').reduce((s, v) => s + table.num(v), 0) +
// sum of 'Price' from field30
table.col(field30, 'Price').reduce((s, v) => s + table.num(v), 0) +
// numeric form field
field21,
2
)
```
### 7.2 Index-Only Variant (no header dependency)
```
Math.pow(
table.col(field20, 2).reduce((s, v) => s + table.num(v), 0) +
table.col(field30, 1).reduce((s, v) => s + table.num(v), 0) +
table.num(field21),
2
)
```
## 8. Power & Root Examples
* Square: (a + b) \*\* 2 or Math.pow(a + b, 2)
* Square root: Math.sqrt(x) // same as Math.pow(x, 0.5)
* (table.num(table.cell(field20, 0, 2)) \*\* 2)
* Math.sqrt(table.num(table.cell(field20, 2, 2)))
---
# Agent Instructions: Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter:
```
GET https://docs.guardianservice.io/technical-information/users/standard-registry-users-schemas-and-policies/schemas/available-schema-types/table-data-input-field/table-data-input-field-with-autocalculate.md?ask=
```
The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.