I am working on a form in InfoPath 2007, that will be used to schedule meetings. The form will sumit the data to a SharePoint 2007 form library, and once approved, populate a calendar. However, I'm stuck on trying to create a repeating event. If they have a meeting that happens every week, or every day, we want them to be able to schedule them for up to 90 days. So far, I have been unsuccessfull with this. I created radial buttons for daily, weekly, monthly, which when selected will calculate the days difference between meetings and populate a frequency text box. I then want to take that number and use the adddays() function to autopopulate a repeating table up to a last meeting date that they specify. What I can't figure out is how to make the table autopopulate, and apply the date in the previous row to a function.
Or if someone knows a better way to use an infopath form to submit a recurring event into a sharepoint calendar, I'm open to ideas.
Hopefully I've explained it well enough.. Any advice on this will be helpful...