tag:blogger.com,1999:blog-7379565521701914821.post2134091819388486822..comments2024-03-14T18:57:15.880+00:00Comments on The Gift of Script: Bulk create Google Calendar events with optional Meet or Zoom - overviewPhil Bainbridgehttp://www.blogger.com/profile/10553620286575352544noreply@blogger.comBlogger15125tag:blogger.com,1999:blog-7379565521701914821.post-50961304190182032602023-10-21T12:06:53.842+01:002023-10-21T12:06:53.842+01:00This reminds me of why I put the validation in the...This reminds me of why I put the validation in there.<br /><br />After some testing I have found the value from the cell is no longer being read as a string, hence the error. You would need to go into the Apps Script code, to the '5) checkData.gs' function and append '.toString()' to lines 32 and 35, so they look like this:<br /><br />var startMin = spreadsheetData[row][6].toString();<br />var endMin = spreadsheetData[row][9].toString();Phil Bainbridgehttps://www.blogger.com/profile/10553620286575352544noreply@blogger.comtag:blogger.com,1999:blog-7379565521701914821.post-84318895140555206992023-10-18T04:16:26.142+01:002023-10-18T04:16:26.142+01:00Hey Phil,
Thank you for such a quick response! I ...Hey Phil,<br /><br />Thank you for such a quick response! I have removed the validation but now I receive the error message:<br />“problem with createEvent Function<br />TypeError: checkDataReturn.endHour.trim is not a function” when running it.<br /><br />I don’t suppose you have a quick and easy solution for this problem? I wouldn’t want to trouble you any further.Tsuhttps://www.blogger.com/profile/16021190720024498396noreply@blogger.comtag:blogger.com,1999:blog-7379565521701914821.post-60664166288436296812023-10-14T16:50:20.691+01:002023-10-14T16:50:20.691+01:00Thank you very much Tsu!
You could probably just ...Thank you very much Tsu!<br /><br />You could probably just remove the Data Validation to achieve what you want ... highlight those columns > Data > Data validation > delete for those columns.Phil Bainbridgehttps://www.blogger.com/profile/10553620286575352544noreply@blogger.comtag:blogger.com,1999:blog-7379565521701914821.post-15693853829205294542023-10-14T07:11:16.406+01:002023-10-14T07:11:16.406+01:00Hey Phil, this is an incredible tool! Thank you so...Hey Phil, this is an incredible tool! Thank you so much!!! It saves so much time for me at work. As a person who knows nothing about coding, you provided an easy solution for me to reduce admin.<br />I have set up a sheet with event template, since events at my work are very similar with just a few tweaks. <br />The only problem I have found is that I can't set the end hour or minute as "start hour +1" or "start minutes + 5" since the validation rules would be showing a warning. I managed to follow this logic with dates, but not minutes/hours. <br />The reason I need it is because I need to set up a lot of events and they all follow a similar logic: one starting at 10am and lasts an hour, second from 9.45am to 10 am, and third: 10am to 10.15am - so 15 min before and after the first event. Any guidance with this problem would be highly appreciated.Tsuhttps://www.blogger.com/profile/16021190720024498396noreply@blogger.comtag:blogger.com,1999:blog-7379565521701914821.post-21284627272211128002022-11-16T13:43:57.926+00:002022-11-16T13:43:57.926+00:00You're very welcome, thank you!You're very welcome, thank you!Phil Bainbridgehttps://www.blogger.com/profile/10553620286575352544noreply@blogger.comtag:blogger.com,1999:blog-7379565521701914821.post-64403278869797771452022-11-16T09:45:24.861+00:002022-11-16T09:45:24.861+00:00Phil, thank you so much for publishing this tutori...Phil, thank you so much for publishing this tutorial! It is fantastic. 🤩 Glad I finally stumbled upon it. I had been using a tutorial you did several years ago to build my own version, a much leaner app but was struggling with getting the Zoom OAuth to work in mine. Now I'm going to try to merge your version with mine. Mine uses data that I have parsed from my email as I want the appointment data to transfer automatically. It's been a very slow process but I will let you know if I ever figure it out. Your work has been a tremendous help! 🙏🏻🙏🏻🙏🏻 Truly grateful!Automation Divahttps://www.blogger.com/profile/16513168042057207056noreply@blogger.comtag:blogger.com,1999:blog-7379565521701914821.post-33711056443492303152022-06-19T18:17:41.100+01:002022-06-19T18:17:41.100+01:00You're welcome.You're welcome.Phil Bainbridgehttps://www.blogger.com/profile/10553620286575352544noreply@blogger.comtag:blogger.com,1999:blog-7379565521701914821.post-16351159589001095372022-06-18T20:41:00.347+01:002022-06-18T20:41:00.347+01:00Works great! Thanks a bunch! Works great! Thanks a bunch! Yochaihttps://www.blogger.com/profile/17411526344233501086noreply@blogger.comtag:blogger.com,1999:blog-7379565521701914821.post-25042434207950545822022-06-18T19:34:38.378+01:002022-06-18T19:34:38.378+01:00Thank you.
1) Check in the Google Sheet: File >...Thank you.<br /><br />1) Check in the Google Sheet: File > Settings > Time zone<br />2) Check in the Script Editor: Extensions > Apps Script > Project Settings > General Settings > Time zone<br /><br />Kind regards<br />PhilPhil Bainbridgehttps://www.blogger.com/profile/10553620286575352544noreply@blogger.comtag:blogger.com,1999:blog-7379565521701914821.post-64959383812884839462022-06-15T23:31:48.766+01:002022-06-15T23:31:48.766+01:00Great tool! ❤
One question, how can I change the t...Great tool! ❤<br />One question, how can I change the time zone? Currently it's UK time so it doest sync well with my calendar due to time differences Yochaihttps://www.blogger.com/profile/17411526344233501086noreply@blogger.comtag:blogger.com,1999:blog-7379565521701914821.post-90398802374359212372022-04-22T11:23:21.224+01:002022-04-22T11:23:21.224+01:00Hi
Thank you.
Not with this tool no - it's a...Hi<br /><br />Thank you.<br /><br />Not with this tool no - it's a one way sync only I'm afraid.<br /><br />Kind regards<br />PhilPhil Bainbridgehttps://www.blogger.com/profile/10553620286575352544noreply@blogger.comtag:blogger.com,1999:blog-7379565521701914821.post-88944871313361182592022-04-21T17:10:58.954+01:002022-04-21T17:10:58.954+01:00Absolutely brilliant!!
Thank you!
PS: Any way t...Absolutely brilliant!! <br /><br />Thank you!<br /><br />PS: Any way to add/subtract guests from sheets once the events have been created? Anonymoushttps://www.blogger.com/profile/01813841238574139588noreply@blogger.comtag:blogger.com,1999:blog-7379565521701914821.post-39933128428613851202021-06-09T09:01:20.872+01:002021-06-09T09:01:20.872+01:00ThanksThanksAntony Rappaihttps://www.blogger.com/profile/17036598923822683028noreply@blogger.comtag:blogger.com,1999:blog-7379565521701914821.post-62403150585624172902021-05-09T10:35:18.559+01:002021-05-09T10:35:18.559+01:00Hi Antony
Thank you. Yes there are API limits to ...Hi Antony<br /><br />Thank you. Yes there are API limits to be aware of: https://developers.google.com/apps-script/guides/services/quotas<br /><br />Kind regards<br />PhilPhil Bainbridgehttps://www.blogger.com/profile/10553620286575352544noreply@blogger.comtag:blogger.com,1999:blog-7379565521701914821.post-7789570784400718222021-05-09T07:41:39.923+01:002021-05-09T07:41:39.923+01:00Hi, thanks a bunch, thanks for sharing. I was wond...Hi, thanks a bunch, thanks for sharing. I was wondering if you try to upload like 5000 events will hit an API limit ? Antony Rappaihttps://www.blogger.com/profile/17036598923822683028noreply@blogger.com