Some of you may have seen my weary posts regarding a 'project' I have to turn our paper Purchare Requisition system electronic with Sharepoint.....?
I'm having to use WSS 3.0, I think to prove that it works before any movement is made on buying MOSS so I know the way I'm doing things is wrong but I need a little assistance on Document Libraries and workflows.
I have 4 document libraries set up: Submission, Review, Purchasing and Archive.
New documents can be created (from an xlsx template) in the Submission library. I envisage users filling out their template and saving it back into the Submission list. My first question is: is there any way to automatically name the document when it comes back in to the library? It's very manual at the moment. I have fiddled with a workflow to try and rename the Name field to the Created By entry to no avail.
After the document is saved, I have a manual workflow set up (very basic at this time) that when executed will move the document to the Review library. I will then use a 'when item is created' workflow in the Review library to notify the Approver of a new item (maybe a To-Do as well) however I don't know if this is possible without some clarification on the following question:
What I need at this point is a way to create the document and input some list data in a field called Approver and another called Buyer within the document library. I am hoping this can stay with the document as it is copied across the libraries as I need it for workflows. As excel files are dumb documents I can't extract info from them automatically and I dont believe workflow data is stored anywhere once executed? Is there a way for this to happen?
From the Review library I have enabled content approval so, when approved by the right person a notification will be sent to the creator saying it has being authorised and the document will be moved to the Purchasng library.
From the Purchasing library an alert will be sent to the Buyer notifying them of a new item. Content approval is again active on this folder so after the item has been purchased annd then Approved a workflow will move the document to its final resting place in the Archive folder notifying the originator that the document has been processed.
Does this at all make sense? I'm attaching a quick Visio doc to try and get across what I think I mean.
I know it isn't perfect and would rather get stuck in to Infopath to do this more dynamically. Maybe this isn't the right way to do this and a list is a better idea?