Been hitting my head on a brick wall with this... First off I only have access to SharePoint Designer 2007, I do not have the required access to implement add-ons such as those offered by CodePlex...
Essentially I'm creating a custom approval workflow on a doc library with enforced check-in/out. The approval workflow itself works fine... (note: workflow 1 is started manually)
Where I am getting a problem is once the document has been approved and further changes are made I want the item status to change back to 'In Progress'.
To this effect I have created workflow 2 which triggers when an item is modified however as workflow 1 (Approval) modifies the item the second workflow auto kicks in.
I have tried to get workflow 2 working via a 'Review Status' hidden field (accepted values 0, 1).
- Workflow 1 > if Item Approved > Review Status = 1
- If Item Changed by end user > Workflow 2 auto starts > Review Status = 0 > change item status to 'In Progress'
In reality this is what happens:
- Workflow 1 > if Item Approved > Review Status = 1 > but item also changed by workflow 1
- Workflow 2 auto kicks-in so Review Status is changed back to 0
Any help on this would be greatly appreciated :)