This is the full example that Stefan Muntwyler developed for his class at UNIS Hanoi, modified by both Stefan and Paul Swanson for demonstration purposes.Click here to view and then copy the spreadsheet. Note that there are six functions in this script: onSubmit – this is what is triggered on form […]
Monthly Archives: February 2015
21 posts
As powerful as a script is on its own, it can be hugely more useful when combined with a Google Form and Spreadsheet.Take a look at this Google spreadsheet, and click File > Make a Copy to have a copy for yourself to work from.When you copy a Google spreadsheet […]
This example builds on the previous one, but in addition to appending the text to a Google Doc, it emails the student with both the feedback and a link to the doc. Click here to open it and make a copy for yourself. It does so with an additional 4 commands […]
In this example we get into the real power of Google Scripts: the ability to interact with Google Docs, Sheets, and more. Click here to view the Example Script 07 – Modifying a Google Doc. function myFunction() { /* The array, data, has three values: studentEmail, message, and docId */ […]
In Google Script, as in most coding, arrays are an important way of storing a series of variables. For a look at arrays in javascript, click here: http://www.w3schools.com/js/js_arrays.asp Take a look at the following example, or click here to make your own copy of the code: function myFunction() { var data […]
In this challenge, you want to pass two variables, ‘studentEmail’ and ‘message’, to the function emailStudent.To do this, you’ll need to add the variables as parameters to both the function CALL, and the function DEFINITION.Once you’ve done this, use the Logger.log command to log both variables and make sure they […]