Page
|
|
|
Next Page |
|
| Contents > Functions reference (alphabetical list) > Logical functions > GetNthRecord function |
|
|
| GetNthRecord function |
| Format |
GetNthRecord(fieldName;recordNumber) |
| Parameters |
| fieldName - any related field or repeating field, or an expression that returns a field or a repeating field. |
| recordNumber - the record number from which you want data. |
| Data type returned |
| text, number, date, time, timestamp, container |
| Description |
| Returns the contents of fieldName from the provided recordNumber. |
| Note The result of GetNthRecord() will not be updated when the record referred to by GetNthRecord() is a record other than the one in which the calculation is currently being evaluated. |
| GetNthRecord of the current table returns the Nth record of the found set according to how the current table is sorted. |
| GetNthRecord of a related table returns the Nth record of the related set (relative to the current record), regardless of how the related table (or portal) is sorted. |
| Examples |
| GetNthRecord(First Name;2) returns the contents of the First Name field for record 2 in the current table. |
| GetNthRecord(First Name;Get(RecordNumber)+ 1) returns the contents of the First Name field for the next record in the current table. |
| GetNthRecord(Contacts::First Name;2) returns the contents of the First Name field for record 2 in the Contacts table. |
| GetNthRecord(Contacts::Has Repetitions[2];2) returns the contents of the second repetition of the Has Repetitions field for record 2 in the Contacts table. |
| Related topics |
|
Functions reference (category list) |
|
Functions reference (alphabetical list) |
|
About formulas |
|
About functions |
|
Defining calculation fields |
|
Using operators in formulas |
|
Sorting records |
|
|
| Contents > Functions reference (alphabetical list) > Logical functions > GetNthRecord function |
|
|
Next Page |
|