Fast-tracking feedback: Google Apps Script user interface training material [Release 2]

Note: This is a personal post made outwith my current employment at JISC CETIS

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

Introduction to Google Apps Script: Custom Interfaces Guide


Join the conversation

comment 3 comments
  • Eoin

    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.

    • Martin Hawksey

      I’ve always avoided VBA because I didn’t like the ‘look’ of it. Because Apps Script uses a Javascript syntax a lot of people have familiarity with it so its more like diving in at the shallow end. The GUI Builder is great for simple stuff, but only gets you so far before your handcoding UI elements.
      This project has continued to evolve and is coming close to completion. Stay tuned for another release 😉

Comments are closed.