Skip to content

Instantly share code, notes, and snippets.

@jccarlin56
Created October 9, 2013 13:00
Show Gist options
  • Select an option

  • Save jccarlin56/6900879 to your computer and use it in GitHub Desktop.

Select an option

Save jccarlin56/6900879 to your computer and use it in GitHub Desktop.
/**
* A set-up function that uses the conference data in the spreadsheet to create
* Google Calendar events, a Google Form, and a trigger that allows the script
* to react to form responses.
*/
function setUpConference_() {
if (ScriptProperties.getProperty('calId')) {
Browser.msgBox('Your conference is already set up. Look in Google Drive!'); }
var ss = SpreadsheetApp.getActive();
var sheet = ss.getSheetByName('Conference Setup');
var range = sheet.getDataRange();
var values = range.getValues();
setUpCalendar_(values, range);
setUpForm_(ss, values);
ScriptApp.newTrigger('onFormSubmit').forSpreadsheet(ss).onFormSubmit() .create();
ss.removeMenu('Conference');
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment