About Google AppsScript Project Trigger Settings Defects

Asked 2 years ago, Updated 2 years ago, 34 views


Code created by the Script Editor function of the spreadsheet Failed to run at the time set in Triggering Current Project

On November 5, 2018, I clicked
Triggering Current Project
The G Suite Developer Hub configuration screen appears.

Since then, it has run seven hours before the configured time.
(The source of the event is 主導time-driven 型 and the trigger type is
 
Date-based timers,
if the time is between 6:00 and 7:00 a.m.  It runs between 23:00 and midnight every day.)

I would like you to answer the following three questions.
①Reproducibility (are other similar symptoms occurring)
②Workaround (Is there a way to fix the time lag issue?)
③Contact information (I would like to contact a page that supports Japanese, but
        I don't know where to go)

Thank you for your cooperation.

google-apps-script

2022-09-29 20:24

1 Answers

Google Spreadsheet Time Zone and Project Time Zone
may be different.
Check the time zone configuration at the following URL:
https://qiita.com/kawamurayuto/items/e98ce7f38cb572ae616a


2022-09-29 20:24

If you have any answers or tips


© 2024 OneMinuteCode. All rights reserved.