0 Replies Latest reply on Aug 12, 2013 3:07 AM by jrpmedia

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

    jrpmedia

      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.