The Mad Jammer Posted December 13, 2002 Posted December 13, 2002 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
Vaughan Posted December 14, 2002 Posted December 14, 2002 Could this be done with calculation fields?
The Mad Jammer Posted December 17, 2002 Author Posted December 17, 2002 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
Recommended Posts
This topic is 8016 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now