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:
- Cleared out the Responses
- Moved the sheet and the form into a folder on Google Drive by themselves (and a Google Document)
- 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?