Hey there FM'ers.

I am trying to fill in a repeating field (MyDate repeats 10 times) with dates based on a date selecetd in a Pop-up menu. There are about 12 date values to select from in the DropDownDate pop-up menu. I have defined a script for the DropDownDate pop-up menu to do this. it is

Set Field["MyDate", "Day(DropDownDate)"]

Set Field["MyDate"-2, "Day(DropDownDate + 1)"]

Set Field["MyDate"-3, "Day(DropDownDate + 4)"]

Set Field["MyDate"-4, "Day(DropDownDate + 5 )"]

Set Field["MyDate"-5, "Day(DropDownDate + 6)"]

Set Field["MyDate"-6, "Day(DropDownDate + 7)"]

Set Field["MyDate"-7, "Day(DropDownDate + 8)"]

Set Field["MyDate"-8, "Day(DropDownDate + 11)"]

Set Field["MyDate"-9, "Day(DropDownDate + 12)"]

Set Field["MyDate"-10, "Day(DropDownDate + 13)"]

The DropDownDate is always a Thursday and the number of days added to the DropDownDate make the calculated days weekdays.

Unfortunately, this doesn't work at all. The DropDownDate (define as a pop-up menu) does not Pop-up at all and I am unable to change the initial date (however I do get the esc hourglass for a brief moment when I click on the field). Furthermore, none of the Mydate occurences get populated with dates in them.

What I want to do is fill in all the Mydate occurences based on the initial date selected in the DropDownDate field.

How can I fix this little problem?

Thanks

The Mad Jammer

And then...there was nothing

Could this be done with calculation fields?

Possibly. I worked around the issue by removing the DropDownDate pop-up menu and put the dates in a portal instead. Now, when the user clicks on a date in the portal my piece of script gets executed and fills in the repeating fields very nicely. Thanks for the suggestion about using a calculation field, I'll give that a whirl and see what I get from it.

The Mad Jammer

And then...there was nothing