Create an AllDayEvent using getCalendarById in Google Scripts

Vote count:

0

Trying to create an AllDayEvent using the getCalendarById without success. The current script I have will run using getDefaultCalendar but as soon as I try to replace with getCalendarById I get an error message, "Action not allowed".

Code.gs:

//Numeric IDs for Column values

//Column containing PBG code
var titleId = 3
//Column containing delivery period
  var titleId2 = 5
//Column containing delivery notes
  var descId = 8
//Column containing TimeStamp
  var formTimeStampId = 1
//Column containing Regional Coordinator
  var regionalcoordinatorId = 2
//Column containing certification status
  var certId = 6
//Column containing delivery date
  var delivdateId = 4
//Column containing Delivery Coordinator
  var deliverycoordinatorId = 9
//Column containing dozens
  var dozensId = 7  

//Calendar Id
  var calendarId = "CALENDAR_ID_GOES_HERE"


function sendFormToCalendar() {
//Allow access to spreadsheet
  var sheet = SpreadsheetApp.getActiveSheet();
  var rows = sheet.getDataRange();
  var numRows = rows.getNumRows();
  var values = rows.getValues();
  var lr = rows.getLastRow();
  var dataRange = sheet.getRange(lr,1,1);
  var data = dataRange.getValues();
  var title = sheet.getRange(lr,titleId,1,1).getValue()+" :: "+sheet.getRange(lr,dozensId,1,1).getValue()+" :: "+sheet.getRange(lr,titleId2,1,1).getValue();

//Increasing content for Description
    var subOn = "Posted:"+sheet.getRange(lr,formTimeStampId,1,1).getValue()+"\n"+"Posted By: "+sheet.getRange(lr,deliverycoordinatorId,1,1).getValue();
    var desc = "Certification:"+sheet.getRange(lr, certId, 1, 1).getValue()+"\n"+sheet.getRange(lr,descId,1,1).getValue()+"\n"+subOn;
    var loc = 'Perry Import-Export SA';  

//Create an all-day event and log the ID
  var date = sheet.getRange(lr,delivdateId,1,1).getValue();
  var event = CalendarApp.getDefaultCalendar().createAllDayEvent(title, new Date(date),
                                                                 {location: loc, description: desc});
 Logger.log('Event ID: ' + event.getId());
  }

asked 21 secs ago

Isaac Gardner

1

Create an AllDayEvent using getCalendarById in Google Scripts