Hi all.
I'm trying to implement a process that'll create a work flow but wait until a preset date for the workflow to fire, but I'm running into some weird issues. The example is an entity with a 'Begin Date' field and a workflow that triggers when 'Begin Date' is changed and basically waits to execute until the 'Begin Date' which would go in as the Postpone Date.
When the 'Begin Date' field is changed the new work flow is created as expected with the proper Postpone date which equals 'Begin Date', but if 'Begin Date' changes a second work flow is created and both it and the original work flow have their Postpone Date changed to the new 'Begin Date'. This basically causes the work flow to execute twice at the new 'Begin Date' which is not what I want. And each time 'Begin Date' changes a new Work Flow is created where all prior work flows are changed to have the same Postpone date.
My hope is that we only have one Work Flow and it's Postpone Date would change accordingly as the 'Begin Date' changes on the Regarding Object. How can we do this? I looked at ways to detect an existing workflow and delete it, but I haven't had much lunch in doing that.
Thanks for any insight.
*This post is locked for comments