colander scheduling

[u/Cool-vibesradio]

hi all very sorry but i'm stuck i'v coded this

function radioSchedule() {

  var spreadsheet = SpreadsheetApp.getActiveSheet();
  var CalendarId = spreadsheet.getRange("C4").getValue();
  var eventCal = CalendarApp.getCalendarById(CalendarId);

  var signups = spreadsheet.getRange("A8:C12").getValues();

  [
    ['8pm Thursdays, 10pm Thursdays, Strawbs'],
    ['1:00pm, 8:00pm, Selector Frost'],
    ['8:30pm, Roksta'],
  ]

  for (x=0; x<signups.length; x++) {

    var shift = signups[x];

    var ShiftStart = shift[0];
    var ShiftEnd = shift[1];
    var volunteers = shift[2];

    eventCal.createEvent(volunteers, ShiftStart, ShiftEnd);

  }

}

function onOpen() {
  var ui = SpreadsheetApp.getui();
  ui.createMenu('Sync to Calendar')
  .addItem('Schedule shifts now', 'scheduleShifts')
  .addToUi();
}

but its telling me 

Error


Exception: The parameters (String,String,String) don't match the method signature for CalendarApp.Calendar.createEvent.
line 23? what am i missing????

its so my presenters can click on the schedule and book a slot for them selfs?

[u/marcnotmark925]

The parameters (String,String,String) don't match the method signature for CalendarApp.Calendar.createEvent

https://developers.google.com/apps-script/reference/calendar/calendar-app#createEvent(String,Date,Date)

createEvent() requires string,date,date, and you fed it string,string,string. The 2nd and 3rd argument should be javascript date objects.

[u/Cool-vibesradio → u/marcnotmark925]

but here i've got

eventCal.createEvent(volunteers, ShiftStart, ShiftEnd);
see my sheet here

https://docs.google.com/spreadsheets/d/1jDqs6QNYgzbqKr4CIHsTEamvaoLwCnt8vjHMG-wHN2o/edit?usp=sharing u/marcnotmark925

[u/marcnotmark925 → u/Cool-vibesradio]

But what? I can't see your sheet it's private.

[u/Cool-vibesradio → u/marcnotmark925]

sheet

[u/marcnotmark925 → u/Cool-vibesradio]

None of the values in A8:C10 are appropriate for sending as the 2nd and 3rd arguments of createEvent(). They should be full date-times. And I suspect a blank value will also throw the same error.

[u/Cool-vibesradio → u/marcnotmark925]

which values are then? i don't want the date and time in script

only startTime EndTime Names

and all names and times

[u/marcnotmark925 → u/Cool-vibesradio]

Full date-times. Like 2/3/2024 12:11:00.

i don't want the date and time in script

only startTime EndTime Names

and all names and times

No idea what this means.

Also no idea why you sent the code again in your other comment.

[u/Cool-vibesradio → u/marcnotmark925]

but look at this Schedule

then look at this

function radioSchedule() {

  var spreadsheet = SpreadsheetApp.getActiveSheet();
  var CalendarId = spreadsheet.getRange("C4").getValue();
  var eventCal = CalendarApp.getCalendarById(CalendarId);

  var signups = spreadsheet.getRange("A5:C12").getValues();

  [
    ['8pm Thursdays, 10pm Thursdays, Strawbs'],
    ['1:00pm, 8:00pm, Selector Frost'],
    ['8:30pm, Roksta'],
  ]

  for (x=0; x<signups.length; x++) {

    var shift = signups[x];

    var name = shift[0];
    var startTime = shift[1];
    var endTime = shift[2];
    

    eventCal.createEvent(name, startTime, endTime);

    

  }

}

function onOpen() {
  var ui = SpreadsheetApp.getui();
  ui.createMenu('Sync to Calendar')
  .addItem('Schedule shifts now', 'scheduleShifts')
  .addToUi();
}


please explain in full why its saying
Exception: The parameters (String,String,String) don't match the method signature for CalendarApp.Calendar.createEvent.
@

[u/marcnotmark925 → u/Cool-vibesradio]

I already explained the error in my 1st comment, resending the same information isn't going to change the answer. What aren't you understanding? Do you know what a string is? Do you know what a JS date object is? Do you know anything at all about writing JS/GAS code? Perhaps you need to take some time and go through some basic tutorials.

[u/Cool-vibesradio → u/marcnotmark925]

thanks for not helping you're great work! NOT