Filemaker Pro 8.5 Educational Maintenance T3 TJ083LL/A User Manual

Chapter 8

  

|

  Logical functions     135

fieldName - any 

 or 

, or an 

repeating field.

recordNumber - the 

 number from which you want data.

text, number, date, time, timestamp, container

Returns the contents of fieldName from the provided recordNumber.

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.

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(test;result1;result2)

test - any numeric value or logical 

result1 - expression or 

result2 - expression or field name

text, number, date, time, timestamp, container