Filemaker Pro 8.5 Advanced Maintenance TG761Z/A Manual Do Utilizador
Códigos do produto
TG761Z/A
Chapter 8
|
Logical functions 135
Parameters
fieldName - any
or
, or an
repeating field.
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.
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.
If
Format
If(test;result1;result2)
Parameters
test - any numeric value or logical
result1 - expression or
result2 - expression or field name
Data type returned
text, number, date, time, timestamp, container