Collaborative Tools Project

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 ...

I'm sorry this isn't a finished solution you can just copy and paste. It's more of an example, sharing THAT this can easily be done which may help you figure out how to do it your case. Lots of people at the University of York are using Google Forms to allow people to sign up to events. They use forms rather than Appointment Slots because they want to work with the data to generate registers for the people running the events. But often these events have a capacity, that is, once 20 people have signed up to them, they're full. There isn't much you can do with Google Forms to "live lookup" data and change form items if they're full, so we have developed workarounds to mimic this behaviour. Firstly, having created our Form in the regular way, we create an extra sheet that keeps a track of how many people have have signed up, like this... The count column has a formula in it like this... = COUNTIF ( 'Form responses 1'!G:G , ...

Earlier today we were looking over the results of a survey we'd put out with Google Forms. The answers were well thought out, very long and textual and impossible to read in a spreadsheet. As a group we want to read the responses and share our thoughts about them using the comment feature in Google Documents so I whipped up this script to move the all the data from a spreadsheet to a Google Document. function document_from_spreadsheet() { var ss = SpreadsheetApp.getActiveSpreadsheet() var sheet = ss.getActiveSheet() var header_range = sheet.getRange(1,1, 1, sheet.getLastColumn()) var headers = header_range.getValues()[0] var data_range = sheet.getRange(2,1, sheet.getLastRow(), sheet.getLastColumn()) var values = data_range.getValues() var doc = DocumentApp.create(ss.getName() + " Exported") var body = doc.getBody() for (var h in headers){ h = Number(h) var header_name = headers[ h ] var p = body.appendParagraph(header_name) ...

I've had two people complaining about this this week. If you have a Google Form in a spreadsheet that was made a while ago, you are still given the old form editing interface. There doesn't seem to be a way to bring a Google Form up-to-date, which is a big pain if your form is very long and complex since the only way to do so is to just start all over again.

In the previous blog post , I showed how we get data from a Form and render it into a Google Document. In this post, I want to show how the Document, as it is created can have a link appended to it to another Google Form that will be used for marking that document. We have used this where people are submitting application forms and lecturers are grading those applications. First, create your new evaluation form, deciding what field will be autopopulated with data from the application form, for example, student name and institution etc. Also add the form items you want to use for marking, which might include drop down menus or multiple choice or paragraph text areas.  and then select then choose the menu Responses > Get pre-filled URL. Once you have filled in this form you will be able to add some code to your Google Spreadsheet like this... and work out which value you need to map onto the bit that says...  entry.1021949580 ...obviously all of these will need changi...

A lot of our staff are using Google Forms to gather lots of data into spreadsheets, from Grant Application forms to self assessment questionnaires and more. Spreadsheets are of course great places to store lots of data, but when that data is mainly textual , it is ridiculously hard to read and edit in a spreadsheet. Our solution has been to generate a Google Doc of the data in a row of data. Sometimes this happens automatically and is emailed to the relevant people and sometimes we add a little interface to be able to say "Make a Google Doc with this row" to the spreadsheet. The challenge is making it easy to set up. Our Solution We've used this a few times. First we create our Google Form and add some data. The spreadsheet now has a list of column headers across the top. Now, we make a template Google Doc. In Tools > Script Editor we add some code that allows us to insert the spreadsheet header names as funny tags, like this, {Username}. You could of cour...