https://wiki.planetoid.info/index.php?action=history&feed=atom&title=Troubleshooting_of_google_apps_script 2026-06-05T00:51:15Z Revision history for this page on the wiki MediaWiki 1.39.6 https://wiki.planetoid.info/index.php?title=Troubleshooting_of_google_apps_script&diff=23010&oldid=prev 2022-05-24T14:34:59Z

<p>Created page with &quot;Troubleshooting of google apps script about CalendarApp == Fix: TypeError: Cannot read property &#039;createEvent&#039; of null == Code &lt;pre&gt; let cal = CalendarApp.getCalendarById(cale...&quot;</p> <p><b>New page</b></p><div>Troubleshooting of google apps script about CalendarApp<br /> <br /> == Fix: TypeError: Cannot read property &#039;createEvent&#039; of null ==<br /> Code<br /> &lt;pre&gt;<br /> let cal = CalendarApp.getCalendarById(calendar_id);<br /> let event = cal.createEvent(title, start_time, end_time);<br /> &lt;/pre&gt;<br /> <br /> <br /> Error message<br /> &lt;pre&gt;<br /> TypeError: Cannot read property &#039;createEvent&#039; of null<br /> setUpCalendar @ 程式碼.gs:42<br /> &lt;/pre&gt;<br /> <br /> Solution: Verify the {{kbd | key=cal}} variable is not null. <br /> <br /> Code<br /> &lt;pre&gt;<br /> let cal = CalendarApp.getCalendarById(calendar_id);<br /> Logger.log(&#039;The calendar is named &quot;%s&quot;.&#039;, cal.getName());<br /> &lt;/pre&gt;<br /> <br /> == Fix: Exception: Action not allowed ==<br /> Error message<br /> &lt;pre&gt;<br /> Exception: Action not allowed<br /> setUpCalendar @ 程式碼.gs:45<br /> &lt;/pre&gt;<br /> <br /> Code<br /> &lt;pre&gt;<br /> let cal = CalendarApp.getCalendarById(calendar_id);<br /> let event = cal.createEvent(title, start_time, end_time, options);<br /> &lt;/pre&gt;<br /> <br /> Solution: Verify the gmail account running apps script was allowed to write the google calendar<br /> <br /> == Fix: TypeError: cal.createEvent(...).createEventFromDescription is not a function ==<br /> Error message<br /> &lt;pre&gt;<br /> TypeError: cal.createEvent(...).createEventFromDescription is not a function<br /> setUpCalendar @ 程式碼.gs:45<br /> &lt;/pre&gt;<br /> <br /> Root cause: use the wrong function<br /> <br /> Code<br /> &lt;pre&gt;<br /> let options = {description: description, guests: email_of_guest};<br /> let event = cal.createEvent(title, start_time, end_time, options);<br /> &lt;/pre&gt;<br /> <br /> == Further reading ==<br /> <br /> * [https://developers.google.com/apps-script/guides/support/troubleshooting Troubleshooting  |  Apps Script  |  Google Developers]<br /> * [https://developers.google.com/apps-script/reference/calendar/calendar-app?hl=en Class CalendarApp  |  Apps Script  |  Google Developers]<br /> * [https://ithelp.ithome.com.tw/users/20130625/ironman/4630 一份考卷不夠你可以出兩份！用 google apps script 出線上考題 :: 2021 iThome 鐵人賽]<br /> <br /> {{Template:Troubleshooting}}<br /> <br /> [[Category:Google]]</div>

Unknown user