Filemaker Pro 8.5 Educational Maintenance T3 TJ083LL/A User Manual

Chapter 10

  

|

  Repeating functions     157

Returns the contents of the repeating field specified by number.

ParcelBids is a field defined to repeat with ten values and contains the values 

, 

, 

and 

.

GetRepetition(ParcelBids;2) returns 

.

GetRepetition(if(IsEmpty(ParcelBids) ≠ true, ParcelBids, 
HouseBids);2) returns 1200.
GetRepetition(ParcelBids;5) returns nothing.

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 

. See 

FileMaker Pro help.

Last(field)

field - any 

, or an 

 that returns a reference to a 

repeating 

 or related field.

text, number, date, time, timestamp, container

Returns the last valid, non-blank value in field. If field specifies a repeating field then 

it returns the last non-blank repetition. If field specifies a related field, then it returns the 

last non-blank value in the related set.

The last related value will depend on the way 

records are not sorted, then the Last function returns a value based on the creation order 

of the 

Last(ParcelBids) returns 

 if ParcelBids is a number field defined to repeat with 

ten values and contains the values 

, 

, and 

.

Last(Payments::PaymentDate) returns the payment date in the last matching record 

in the Payments table.