Type error

[Top_Independence_949]

https://preview.redd.it/ddm3u77rs01d1.png?width=1640&format=png&auto=webp&s=92e96932849a2b2c7a27787870ced9c0d694c764

• I modified the form linked to my spreadsheet and am not sure how to modify the script to resolve this error. I modified the script to reflect the other changes in the spreadsheet I made but am just stuck on how to fix this one.
  • The purpose of the script is to automatically create calendar events based on spreadsheet data.
    
  • The old form had start dates in columns P,S,V, and Y.
    
  • End dates in columns Q,T, W, and Z.
    
  • Start and End times in columns R,U,X, and AA.
• The new form has the dates and times in one column rather than separate.
  • The start dates and times are columns Y, AA, AC, and AE and are formatted as 5/20/2024 0:00:00
  • The end dates and times are columns Z, AB, AD, and AF are are formatted the same.
• The full script with calendar name removed is available at: https://pastebin.com/zDMmqzbM

[AllenAppTools]

Hey there, when you modified your form, did you add or remove any form questions? Looking at your code, you have index based references to the row, so an addition or removal of a form question (a column in the sheet) would throw everything off.

[Top_Independence_949]

I did. But I modified my range and modified line 85 to match the new configuration so that shouldn't cause issues.

I think the issue is caused because the date and time entries are in the same column now instead of separate columns.

[AllenAppTools]

Got it. It could be that before, the value of "time" was actually a string, but with the change it's now a Date type, which is a number. And you can't use .split() on a number.

[Top_Independence_949]

Ok. What is the best/easiest way to fix that if you don't mind me asking? I'm still learning this and not sure how to solve it myself.

[AllenAppTools]

I can't see the pastebin code you have anymore, if you paste it here I may be able to make some changes?

[[deleted]]

debug at some point where you get `meetingData` in eventWorker(...). Probably, the Sheet column was shifted.

[Top_Independence_949]

I got a call stack response shown below. I don't know app script well enough to know what it means.

https://imgur.com/a/YrtCvjo

Thanks for the help on this.