CODEWITHSUNDEEP
google-apps-scripttriggers
Robert Moore
Robert Moore

Reputation: 1

Google Apps Script Triggers not firing

My Triggers no longer work. I have two different google sheets with triggers setup. One sheet has a daily trigger that is set to fire between 9-10am. The other sheet has two triggers, one fires on a form submit and the second trigger fires on change. These had been working fine for a solid year before they up and stopped working a week or two ago.

For both of the google sheets, I have tried deleting and re-adding the triggers. For the one that has the daily timer, I have tried changing the time of day around also. No luck on them firing own their own. If I go to the Run Menu and run the function manually it works fine. I'd rather avoid having to create new google sheets as links to these sheets are published to users in my domain and are in production.

ie.

function updateScores()
{
  Logger.log("Function started");

/*  
all of my code here.... 
*/

}

When I manually run the function I see the "Function started" message in the logs along with all my other Logger.log statements I have throughout the code. Calculations are done correctly, emails sent, etc. The code itself works fine.

Upvotes: 0

Views: 2191

Answers (1)

Teyam
Teyam

Reputation: 8102

Actually, I've seen a couple of issues regarding triggers not working posted just recently in google-apps-script-issues tracker - Issue 6226 and the latest is Issue 6244.

As advised in this SO post - Google app script trigger not working, after checking the logs which you already have done and as you mentioned "The code itself works fine", you may post the issue in Apps Script Issue Tracker .

Upvotes: 0

Related Questions