Filemaker Pro 8.5 Advanced Maintenance TG761Z/A User Manual

Extend(non-repeatingField)

non-repeatingField - any non-

 defined to contain only one 

value), or an 

expression

 that returns a reference to one.

text, number, date, time, timestamp, container

Allows a value in non-repeatingField to be used with every repetition in a repeating 

field. Use the Extend function with calculations involving both repeating and non-

repeating fields. Without the Extend function, the value in non-repeatingField is 

used only with the first repetition in the repeating field.

Extend(TaxRate) * Quantity * ItemPrice returns 

, 

, and 

 when 

TaxRate contains 

; the repeating field Quantity contains 

, 

, and 

; and the repeating 

field ItemPrice contains 

, 

, and 

.

Item Count * Extend(if(Company Size > 100; Reduced Price; Price)) 

returns $1250, $500, and $750 when Reduced Price contains $50; the repeating field 
Item Count contains 25, 10, and 15; and Company Size is greater than 100. If 
Company Size is less than 100 and Price contains $100, this calculation returns $2500, 

$1000, and $1500.

GetRepetition(repeatingField;number)

repeatingField - any 

 that returns a reference to a 

repeating field.

number - the field repetition number.

text, number, date, time, timestamp, container