Google Form passes data to sheet correctly but sheet2cal script creates a calendar event with "0.0" time and fails to bring over details of events
Unlinked and created new form and debug shows all variable data when run. Events are created in Calendar with "0.0", no Start and Stop times or event text. Odd as it's worked without fail for years :
function createCalendarEvent() {
var sheet = SpreadsheetApp.getActiveSheet();
var calendar = CalendarApp.getCalendarById('plazamarinamgr@gmail.com');
var startRow = 2; // First row of data to process-2 exempts header row
var numRows = sheet.getLastRow(); // Number of rows to process
var numColumns = sheet.getLastColumn();
var dataRange = sheet.getRange(startRow, 1, numRows-1, numColumns);
var data = dataRange.getValues();
var complete = "Done";
for (var i = 0; i < data.length; ++i){
var row = data[i];
var timestamp = row[0]; //Timestamp
var Duration = row[1]; //Duration
var Contact = row[2]; //Contact
var Phone = row[3]; //Phone
var Email = row[4]; //Email
var Address = row[5]; //Address
var City = row[6]; //City
var State = row[7]; //State
var Zip = row[8]; //Zip
var Start = row[9]; new Date //Start
var End = row[10]; new Date //End
var Type = row[11]; //Type
var Make = row[12]; //Make
var Length = row[13]; //Length
var Beam = row[14]; //Beam
var Draft = row[15]; //Draft
var Electrical = row[16]; //Electrical
var Notes = row[17]; //Notes
var eventID = row[18]; //event marked Done
if (eventID != complete){
var currentCell = sheet.getRange (startRow + i, numColumns); calendar.createEvent(Duration +' - '+Contact +' [P]',Start, End,{description:+Phone +' | '+Email+' | '+Type-'+Type+'|'+Make +' | Length-'+Length+'|+Beam-'+Beam +'| Draft-'+Draft+'|Electrical-'+Electrical+' |Notes-'+Notes +[P]ending [+]Confirmed [X]NoAvail [0]NoShow [1]Bill NOTE:24HR CANCELLATION REQUIRED'});
currentCell.setValue(complete);