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?

Improve this question
1

1 Answer 1

Reset to default
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.

Improve this answer
2
  • It appears that if you setup the trigger through code it will work again: developers.google.com/apps-script/guides/triggers/… Commented Aug 19, 2015 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. Commented Aug 19, 2015 at 1:00

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.