AnsweredAssumed Answered

AUTO-FILL a Repeating [date] Field ... with 6 monthly increments

Question asked by jrpmedia on Aug 12, 2013

Title

AUTO-FILL a Repeating [date] Field ... with 6 monthly increments

Post

     I have a Repeating Field called Next_Date which I would like to auto populate it's 25 cells (repeats) on a 6 monthly basis (rounded to the 1st of the month)

     I would like to enter a date into the first repeating cell and have all the other 24 cells to auto-fil.

     I would like to be able to also edit any cell (say cell 5 for onstance) and have the auto-fil cascade onwards from that edit (cells 6 to 25 in this case).

     I have looked at this script here: http://forums.filemaker.com/posts/f7b19ecf3f
     But currently with this script (see below) I have to manually edit each cell to get the next to auto-fil

Let (
 i = Get ( CalculationRepetitionNumber )   ;
Extend ( globaldateField )+ i * 14
)

All ideas gratefully received :-) Thank you.

Outcomes