Filemaker TH325Z/A Fiche technique télécharger pdf (Page 135)

Chapter 8

Logical functions 135

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.

Format

If(test;result1;result2)

Parameters

test - any numeric value or logical expression

result1 - expression or field name

result2 - expression or field name

Data type returned

text, number, date, time, timestamp, container

1 2 ... 130 131 132 133 134 135 136 137 138 139 140 ... 237 238

Pas de commentaire

Filemaker TH325Z/A Fiche technique Page 135