Dynamic Table Functions
Description
GoFormz supports dynamic row and column functions that you can use with your tables. These will reference either the current row or current column.
Syntax
Row()
Column()
Row() returns the number of the row your formula is in
Column() returns the number of the column your formula is in
Examples
Set up a table in your template with the following Default Values:
| Column 1 | Column 2 | Column 3 |
|---|---|---|
| ="10" | ="7" | =SUM([Table]![1][Row()]:[2][Row()]) |
| ="15" | ="14" | ="18" |
| ="20" | =Column() | ="27" |
| =SUM([Table]![Column()][1]:[Column()][3]) | =Row() | =IF([Table]![2][Row()] > [Table]![Column()][3], "true", "false") |
| Formula | Description | Result |
|---|---|---|
| =SUM([Table]![Column()][1]:[Column()][3]) | Sums the first three rows of the current column | 45 |
| =SUM([Table]![1][Row()]:[2][Row()]) | Sums the first two columns of the current row | 17 |
| =IF([Table]![2][Row()] > [Table]![Column()][3], "true", "false") | Checks if the value in [2][4] is greater than the value in [3][3] and returns true | true |
| =Column() | Returns current column | 2 |
| =Row() | Returns current row | 4 |
Updated almost 2 years ago