Back in May 2011 Tony Hirst looked at the Visual UI Editor For Google Apps Script and commented that he thought before long I would have posted something about it. Well almost a year later here’s what I’ve got for you. As part of the Fast-tracking feedback project (funded by the LSIS Leadership in Technology grant) with Loughborough College I ran a training session at the beginning of the month to help staff learn about user interface construction in Google Apps Script. The session follows on one of my earlier blog posts releasing some code to batch fill in Google Docs from a spreadsheet of feedback comments. As part of the session I produced a step-by-step guide for creating a Google Sites based form/gadget that could read and write data to a spreadsheet. As part of the project this guide is available for re-use using the link below. Before you download/use a couple of things worth bearing in mind:
- the guide has been tweaked slightly for publication and as a consequence I may have inadvertently broken it. If you find something is wrong leave a comment in the document
- in the guide an image is used to help you layout a form and is not intended to be part of the final navigation
Join the conversation
This looks like what I am needing for my next project – though I am at that funny stage of not kowing exctly what it is I need to know….
Having previously assumed the Google Apps UI was similar to VBA form builder, and having dismissed it, I think I will go back and re-examine. The ‘test for tutor’ is particularly interesting though I suppose not specific to the UI.
This project has continued to evolve and is coming close to completion. Stay tuned for another release 😉
Hacking stuff together with Google Spreadsheets: Fast Tracking Student Feedback System JISC CETIS MASHe
[…] to students. This project has generated a number of outputs for the wider community including training material and some code snippets (sending free SMS | generating Google Documents from Spreadsheets).As my […]
Comments are closed.