Repeating Field Calculations

[caseavey]

I am trying to make a calculation that compiles information into a repeating calculation in FMP 6. How do i jump from one line of the field to the next repeating field.

For example

Day & Start Time & Venue [[[next line]]]

Day & (Start Time + 1) & Venue ...

[Raybaudi]

Extend ( Day ) & Extend ( Start Time ) + Get ( CalculationRepeatitionNumber ) - 1 & Extend ( Venue )

[comment]

IIRC, the way to do this before version 7 was to have a global repeating field with pre-entered values of 1|2|3... etc., and a repeating number field set to lookup from the global. The calculation would then be:

Extend ( BaseValue) + RepeatingNumber

You might want to look at Mikhail Edoshin's Smart Ranges instead:

http://www.onegasoft.com/tools/smartranges/index.shtml

[Raybaudi]

Oh yes ... FM6 !

[caseavey]

what if i am trying to display every minute between two times. I tried using

Case(Extend(Start Time)+(Number250*60) < End Time Calc, Extend(Start Time) + (Number250*60))

Number250 is a repeating field with 251 values including every number from 0-250

Start Time is the starting time

End Time Calc is end time

(ie 7:00, 7:01, 7:02, 7:03...7:59)

, equals a repeat

7:00 = Start Time

8:00 = End Time Calc

[Raybaudi]

You'll need to Extend End Time Calc too.

Case(

Extend( Start Time ) + Number250 * 60 < Extend( End Time Calc ) , Extend( Start Time ) + Number250 * 60

)

[caseavey]

How stupid of me

THANK YOU