AUTO-FILL a Repeating [date] Field ... with 6 monthly increments
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
i = Get ( CalculationRepetitionNumber ) ;
Extend ( globaldateField )+ i * 14
All ideas gratefully received :-) Thank you.