Archive for February, 2016

Prompt User for Information

Prompt User for Information by Alice Keeler When using Google Apps script sometimes you need to ask the user for some information. First you need to call up the user interface for the app you are using. Prompt the user and then get the response. Here is some sample code for you to copy and […]


Selecting a Random Winner

selectWinner Featured Image

Google Sheets: Select a Random Winner by Daniel J. VandeBunte For my first post for Teachers Can Code I’d like to go through a fairly short google apps script I wrote called selectWinner. I wrote the script during the summer of 2015 to select a random winner from a group of teachers attending a professional development […]


Combining Text and Variables

Combining Text and Variables by Alice Keeler One of the scripts I wrote changes the document title of student work to indicate it has been graded. To do this, I need to combine the text string ‘Graded’ with the original document title which is defined by a variable. Plus To join a text string and […]


#codenoob Ask A Question

Coding forums can be intimidating if the participants in the forum are experienced coders. Ask a basic question on Twitter with the hashtag #codenoob. #codenoob using Google Apps Script and I want to determine how many rows in Column B of a spreadsheet have data… — Alice Keeler (@alicekeeler) February 16, 2016


Tools – Script Editor

When using a Google text document or Google Sheets spreadsheet you can add Google Apps Script to the document to automate tasks. Go to the Tools menu and choose “Script editor.” Function By default the function in the “Script editor” is “myFunction.” You can leave the function name as “myFunction” or change it to something […]


Test for “OR”

My JavaScript knowledge is pretty limited, I like to say I’m a teacher not a programmer. I’m always excited to learn a new tip. Today @flubaroo was able to help me with a little of my code and showed me some new tricks. In an if else loop, I can test for one condition OR another […]


Sample Scripts by Alice Keeler

I started coding in Google Apps Script one year ago. I was surprised how easy it was to get started with coding Google Apps. In a nutshell, Google Apps Script allows me to create custom applications for Google Apps such as Google Sheets spreadsheets or Gmail. You need to know a TINY bit of JavaScript… […]


Google Apps Script

Google Apps Script is based on JavaScript and allows you to customize Google Apps. Google provides some tutorials to get you going with Google Apps Script. You will need to know a little JavaScript to code Google Apps Script. Google Apps Script is EASY You CAN code Google Apps Script even if you currently know zero […]