Skip to main content

Posts

Showing posts with the label process

Creating a Documentation Process With Google Forms, Documents and Spreadsheets.

We wanted to improve the way people at the University request new software and tools. This is a process that requires lots of people's feedback and needs to be very flexible. We need to get software experts to look at it, security teams, the support teams, teaching experts to see if is a good pedagogical match. We need the licensing to looked at and the usability and accessibility. The list is astonishingly long and in these cases it often gets so that your process map just starts to look like infinite spaghetti. No wonder it didn't quite work, infinite spaghetti is always troublesome. Much of my work involves trying to find a workable solution to a fiendish problem.. it's simplicity hunting. And when working with people around the university it's clear that they really don't want a tool that solves their immediate problem, they want abilities that solve problems like these. This is a very different thing. And besides I personally couldn't create So, out of ...

Creating a Process Workflow with Google Spreadsheets

I thought I'd share this ongoing project I've been working on about creating workflow support for a team. I've referred to it before in a blog post called  Using Spreadsheets Instead of Forms , in which I argue how using the commenting, "live saving", versioning and collaborative features of spreadsheet far exceeds what can be done with a simple Google Form (see below). This is especially so when the data you are collecting is long and complicated. ( Tip of the hat to Tim Saunders who had this idea ). Having quickly trialled and liked bespoke workflow apps like Kissflow , and also read the documentation for bigger workflow systems like RunMyProcess , we realised that one of our first challenges was to define the mood or tone of this process. It was clear that the process we were trying to support was more consultative and discussion-based than a hard passing of numbers and approvals in a clear process flow. Our process needed to be more about " letti...

Testing Kissflow To Create an Approval Process

I was really impressed with Kissflow ( which integrates with Google Apps ), a tool for running processes.  I'm working with lots of departments at the moment that are doing, or trying to improve their processes using Google Spreadsheets but this may offer a more complete solution. It works like this.... First you design a form as if it was one big form for the entire process, with different sections.  Next, you create a diagram of your workflow that can contain, approval requests, requests for more information, and queries. You can also create parallel processes and I liked the way you can create sub-process blocks. At each stage you add the people who need to complete it. The next step is to then sort of define who needs to see which bits of information at which stage.  And finally you publish and initiate your process. I have created one to request to create a new programme. It basically goes, Create a request Get approval to...

Improving Ethics Approval in Research With Google Forms and Spreadsheets

I have just met with a colleague who is using Google Forms to improve the Ethics Approval process for research projects. They are taking a slightly different path to the one I might have plumped for, and are creating, on-the-fly Google Documents, filling in the appropriate sections and then sending them to people to add comments to etc. We thought he may have worked himself into a corner because although there is a function to capture when people submit a form ( onFormSubmit() ), there isn't one to capture if you "allow the user to edit responses" - there's no onFormUpdate(). We created a workaround by having a time-based trigger that just checks to see if the updated_timestamp is greater than the last_checked_timestamp. The best part, for me, of working with my colleague was when I referred at some point to my JavaScript skills being far from honed and he asked "So is this JavaScript then?" and laughed incredulously. He was happily coding away without...