This is a followup to a question I asked yesterday on the Google Apps Script Office Hours Hangout.  The goal of my final script is to create an election process for student elections at the high school where I work using Google Forms.  The script has...

in setActiveSpreadSheet doc the example is very clear:  // The code below will make the spreadsheet with key "1234567890" the active spreadsheet var ss = SpreadsheetApp.openById("1234567890"); SpreadsheetApp.setActiveSpreadsheet(ss);...

Project key: MyvPlY2KvwGODjsi4szfo389owhmw9jII  I am trying to run a script that sends the contents of my form by email each time the form is submitted. I was following the instructions from this link below exactly until I started getting errors and...

I'm trying to update an event using:  PUT https://www.googleapis.com/calendar/v3/calendars/primary/events/q4es0o2o70naq8idj1dj6q4354  {  "reminders" {"useDefault":true},  "summary":"updatedsummary",  "descripti...

To preface, I'm super new to programming in general, nevermind javascript.  I'm developing a web application where a user can upload a picture by clicking on a button.  This action will upload pictures into a certain directory in my google dr...

DESCRIPTION: I have a spreadsheet I call 'Applications' which is a schedule of services provided to clients and the dates these services were provided.  I also have another spreadsheet called 'Daily Activity' in which I'm trying t...

I have written a custom function which returns a simple array. (it is a simple dirty 3D lookup over multiple sheets). Here is the code if it helps:  function get3DCellValues(startSheet, endSheet, cell) { var sheets = SpreadsheetApp.getActiveSpreadshe...

I'm in the process of creating a basic form that takes user input via text boxes and drop down list and upon submit will log into a spreadsheet. So far this works fine.  What I would like to add to the form is a "file upload" feature, tha...

I'm using the built-in api for scripting against Google Spreadsheets to send some booking confirmations, and currently my script breaks if someone has filled in an invalid email. I'd like it to just save some data to a list of guests that hav...

I need to submit a form in a google script but get this error:     TypeError: Cannot call method "withItemResponse" of undefined   According to the link below, this is how it should be set up https://developers.google.com/apps-script/referenc...