Filemaker Pro 8.5 VLA Tier 5 TG558Z/A Manual De Usuario
Los códigos de productos
TG558Z/A
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.
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
, or an
that returns a reference to a
repeating
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
records are not sorted, then the Last function returns a value based on the creation order
of the
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.