I have a meeting room reservation site in WSS 3.0. I have set up a workflow which sends a notification to invitees that a meeting has been set up and then pauses until 15 minutes before the due time at which point it sends out a reminder.
I have also set up the workflow to fire if the reservation changes which will send a mail out with the new details and wait until 15 minutes before the new time.
I have set up conditions on the workflow to check to see if the modified date is the same as the original modified date when the workflow started so that when it reaches the reminder time it will only send out a reminder if the item hasn't changed. This way it should only send out a reminder for the most recent item as it is set to start a new workflow every time a change is made.
My problem is that the original workflow is still running when a change is made and Sharepoint seems to be unable to start a second workflow on the same item while another is still running. What is happening is that the notification and reminders work perfectly if no change is made but if a change is made before the reminder time a new workflow is not started and as the modified time is changed the original reminder also does not go out (which is essentially correct). If a change is made after the reminder time (i.e. when the first workflow completes) then the change notification and second reminder mails go out as expected.
What I need to know is if there is any way to stop the first workflow before starting the second or if it is possible to run two workflows concurrently on a single item?
I appreciate any help. I've attached a few screenshots so you can see the logic.