Hi all,
I have 2 workflows but each of them is using two different metadata templates. I have a field Staff list which consists of all users which is populated based external table from a MSSQL table.
A document A (for instance, Entry ID: 50) is created using a template named as 'Entry Sheet', I have a workflow A which routes shortcut of that document to a user based on a satisfied condition. An example: the document is routed between 2 users: User X -> User Y.
The shortcut is still not yet deleted on the working folder of User Y and the Entry Sheet Status is ‘Awaiting for a reply note’.
Another document B is created using a template ‘Reply Sheet’. On the template, there is a field 'Reply Approval' of list type and a field ‘Master Doc ID’. The value of the ‘Master Doc ID’ is equal to the ID of the document A (i.e. 50). Once, the value is changed to Approved, the workflow B is completed by automatically assigning another field 'Reply Status' to Completed.
Now, I want to automatically set the Entry Sheet Status metadata field of document A to Completed and the shortcut of User Y should be cleared based on these conditions:
- Reply Status = Completed on workflow B
- The initiator of Workflow B = the last user where the shortcut is found in Workflow A
- Entry ID of document A = Master Doc ID on template B
Is it possible to make such types of conditions to end another workflow?
Is it possible to make a workflow be completed until another workflow is completed?
Please advise.
Thanks