3

I had a working Google form, Google spreadsheet, and GAS script which would be called when the form was submitted. It worked fine until the did (one?) of the following things:

  1. Cleared out the Responses
  2. Moved the sheet and the form into a folder on Google Drive by themselves (and a Google Document)
  3. Modified the form a bit, moving questions around, adding them and such.

When I submit the form, the data still shows up in the sheet but my .gs script is not called any longer for some reason.

The script sends mail, but I also wrote a function to check my quota for sending mail from it and it says I still have some quota left for the day I can still send 89 emails:

function test() {
 var emailQuotaRemaining = MailApp.getRemainingDailyQuota();
 Logger.log("Remaining email quota: " + emailQuotaRemaining);
}

The script is 173 lines long, it doesn't seem like it's that big.

I already have the Resources->Current Project's Triggers setup to send an email immediately.

Is there any way to check why the onFormSubmit function is not being called?

3

There's a defect listed on the Google Apps Script issue tracker.

We'll have to wait it out to see when a project member responds to it, I'm assuming.

  • It appears that if you setup the trigger through code it will work again: developers.google.com/apps-script/guides/triggers/… – leeand00 Aug 19 '15 at 0:52
  • I guess the answer is, A SERVICE OUTAGE! Or...rolling back to an older version of the software by nameless-faceless parties at Google. Oh well at least they left us an out...writing code, I'm okay with that. – leeand00 Aug 19 '15 at 1:00

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.