Filemaker TH325Z/A Datový list stáhnout pdf (Strana 157)

Chapter 10

Repeating functions 157

Description

Returns the contents of the repeating field specified by number.

Examples

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

and 1500.

GetRepetition(ParcelBids;2) returns 1200.

GetRepetition(if(IsEmpty(ParcelBids) ≠ true, ParcelBids,

HouseBids);2) returns 1200.

GetRepetition(ParcelBids;5) returns nothing.

Note 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 1200. See

FileMaker Pro help.

Last

Format

Last(field)

Parameter

field - any repeating field or related field, or an expression that returns a reference to a

repeating field or related field.

Data type returned

text, number, date, time, timestamp, container

Description

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.

Note The last related value will depend on the way related records

are sorted. If the related

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

of the records

Examples

Last(ParcelBids) returns 1500 if ParcelBids is a number field defined to repeat with

ten values and contains the values 2500, 1200, and 1500.

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

in the Payments table.

1 2 ... 152 153 154 155 156 157 158 159 160 161 162 ... 237 238

Žádné komentáře

Filemaker TH325Z/A Datový list Strana 157