Please provide a solution for this issue. This issue is causing us major problems and every OOO solution we come up with is 10x the work only because the workflow can’t handling waiting for file to be unlocked by user to move forward or allow us to add an error handling action for this particular action (update items action for files in a library).
We need to store status, reviewer feedback, approval information, commentary etc on files that get opened and closed on a regular basis. We can’t update metadata or columns in library when files are open.
We resorted to tracking document information in a list but this causes more challenges the more we begin using it:
- If someone moves a file the link breaks for the link we push to the list for association.
- Users have to learn how to manage files from a list vs just having the information accessible in the library for each file
- If business requirements require both list and library to be linked, we have to lock the library down from editing up front and provision each file after we have added the list item ID in a column in the library then unlock the file.
The list solution for 1 list item per file is just not sustainable for document management and review and approvals of documents. WE NEED A SOLUTION FOR THIS LOCKED BY SHARE USE OR OUR AUTOMATION SOLUTIONS ARE SUFFERING FOR OUR CUSTOMERS!