CODEWITHSUNDEEP
javascriptgoogle-apps-scriptgoogle-appsgoogle-forms
Flame of udun
Flame of udun

Reputation: 2237

Google apps script. Form submission fails randomly

I am trying to collect response details from a google form using a script bound to the form, using the onFormSubmit() trigger.

Most times the details are received without error, but once in a while I get an error. The trigger is received but no data is passed to the script. The response is received by the google form console but not forwarded to the script.

Code for receiving data : 

function onFormSubmit(e)
{

  Logger.log("A response has been received!");
  Logger.log(e);
  var resp = e.response.getItemResponses(); //capturing trigger event output
  var form = e.source;
......

Execution transcript in case of error:

[16-09-27 07:29:15:073 PDT] Starting execution
[16-09-27 07:29:15:096 PDT] Logger.log([A response has been received!, []]) [0 seconds]
[16-09-27 07:29:15:097 PDT] Logger.log([{authMode=FULL, triggerUid=xxxxxxx41}, []]) [0 seconds]
[16-09-27 07:29:15:099 PDT] Execution failed: TypeError: Cannot call method "getItemResponses" of undefined. (line 18, file "Code") [0.002 seconds total runtime]

Until now, I have redressed it by duplicating the form and re-setting all the permissions. But I would like a solution that doesn't have me doing this again. On my 10th duplicate now :( Has anyone faced this issue? Please help!!

Upvotes: 2

Views: 586

Answers (1)

user6645160
user6645160

Reputation:

Unfortunately I spent quite a lot of time trying to use Google Apps and have come to the conclusion that it is not a reliable platform. This became especially apparent when using timed triggers, which would fail for no reason several times a day - even when not in use. Sometimes this would log and sometimes not.

I can't offer any help, beyond my eventual solution which was to write everything from scratch in HTML, PHP and Python.

Upvotes: 2

Related Questions