Work on the holiday approval workflow has continued over this last week. We have been adding more and more actions into it, just to see what we can accomplish. We described our workflow to Dave in out monthly review meeting, and he metnioned other features that should be implemented.
Previously, the workflow calculated how many day’s the user’s holiday is, taking into account half days, and input this into a calendar. To make this workflow more intelligent, and useful, I set up a list that would contain the name and department of each member of staff, with a number of how many days of holiday they have left. Before editing the workflow, I created a custom data view of the list, showing only the members of the Online Services team. This feature was requested by Dave as he wanted to see how many holiday days each member of his team had, and creating a list for this data appeared to be one of the only ways to implement it. This method isn’t entirely desirable, as each time a member is added to the Sharepoint site, they also need to be added into the “Holidays Remaining” list. Another issue that has been raised is that, the “Days remaining” field will need resetting every year, and as of yet we do not yet know a way of resetting every feild at once with a single workflow.
We then incorporated the workflow with the list, getting it to subtract the holiday from the “Days remaining” field. We have found with this particular workflow could easily spiral out of control, there will always be something else to add to improve it and get it to do more. This will most likely be the same for a lot workflows, you just have to find a good stopping point.