Page
|
|
|
Next Page |
|
| Contents > Functions reference (alphabetical list) > Repeating functions > GetRepetition function |
|
|
| GetRepetition function |
| Format |
GetRepetition(repeatingField;number) |
| Parameters |
| repeatingField - any repeating field, or an expression that returns a reference to a repeating field. |
| number - the field repetition number. |
| Data type returned |
| text, number, date, time, timestamp, container |
| Description |
| Returns the contents of the repeating field specified by number. |
| Examples |
| ParcelBids is a field defined to repeat with ten values and contains the values 2500, 1200, and 1500. |
| GetRepetition(ParcelBids;2) returns 1200. |
| GetRepetition(if(IsEmpty(ParcelBids) ≠ true, ParcelBids, HouseBids);2) returns 1200. |
| GetRepetition(ParcelBids;5) returns nothing. |
| Note You can also find the contents of a particular repetition in a repeating field using square brackets [ ] as array operators. For example, ParcelBids[2] returns 1200. See Getting the contents of a repetition in a repeating field. |
| Related topics |
|
Functions reference (category list) |
|
Functions reference (alphabetical list) |
|
About formulas |
|
About functions |
|
Defining calculation fields |
|
Using operators in formulas |
|
|
| Contents > Functions reference (alphabetical list) > Repeating functions > GetRepetition function |
|
|
Next Page |
|