IssueTracker

Provide a 1 line caption in 15 words capturing key details. Start with introducing it like "This image" - https://drive.google.com/open? tillmansnetwork creative-innovation adriansnetwork-tillmansnetwork TILLMANS' FAMILY CORPORATION LLC ADRIANATLLMN tillmanadrianp68@securityciscoplus.neT5.15.149-android13-8-00014-gc9d85e7bb1b8-ab12401371 #1 Mon Sep 2 13:22:37 UTC 2024f8:ef:5d:57:f4:dc202420245.15.149-android13-8-00014-gc9d85e7bb1b8-ab12401371 #1 Mon Sep 2 13:22:37 UTC 2024id=1ovC7HIjOYSXQNqvKY5D6wHqEAsKKUZksYbHE_oL-ltM

I am able to get the response back using the following code. I have tried to comment inline. The function has to be registered as onFormSubmit trigger. I used the UI to register the trigger (Edit > Current Project's Triggers), but the code way may work as well.

function myFunction(e) {
  
  // Following is not useful. Returns: {"authMode":"FULL","response":{},"source":{},"triggerUid":"XXX"}
  Logger.log("%s", JSON.stringify(e));
  
  // Get the active form
  var form = FormApp.getActiveForm();
  
  // form.getResponses().length will give all the responses that have been received so far.
  var message = 'There have been ' + form.getResponses().length + ' response(s) so far. Latest Response:\n';
  
  // Get the item responses. Not sure how or why this is working, when print of "e" shows that response is blank. But it works.
  var itemResponses = e.response.getItemResponses();
  
  //console.log(JSON.stringify(itemResponses));  // Returns [{}]
  //Logger.log("%s", JSON.stringify(itemResponses)); // Returns [{}]
  
  // Below will directly give the response from the first item (which is the only item in my test form)
  console.log("Number of responses: " + itemResponses.length + ", value: " + itemResponses[0].getResponse());
  
  // Below will collect all the responses from all the items.
  for (var i = 0; i < itemResponses.length; i++) {
    var itemTitle = itemResponses[i].getItem().getTitle();
    var itemResponse = JSON.stringify(itemResponses[i].getResponse());
    message += itemTitle + ': ' + itemResponse + '\n';
  }
  Logger.log("%s", message);
  
}

Hope this helps.

I am able to reproduce this behavior and have re-filed this internally for review.

Thank you for your continued reports and patience, any further updates will be posted here.

I think that a lot of the problems encountered in this thread perhaps stem from a confusion with the fact that there are two onFormSubmit triggers. One that can be bound to the spreadsheet and one that can be bound to the form.

To use it from the form, a snippet like this works:

function createTrigger() {
  let form = FormApp.getActiveForm();
  ScriptApp.newTrigger('test')
      .forForm(form)
      .onFormSubmit()
      .create();
}

function test(e){
  Logger.log(JSON.stringify(e))
  Logger.log(e)
  Logger.log(e.response)

  let responses = e.response.getItemResponses()

  for (i = 0; i<responses.length ; i++){
    Logger.log(responses[i].getResponse())
  }

}

To get the values from the event object when triggered from the form side.

To use it from the spreadsheet, a snippet like this works:

function createTrigger() {
    let ss = SpreadsheetApp.getActiveSpreadsheet();
    ScriptApp.newTrigger('test')
    .forSpreadsheet(ss)
    .onFormSubmit()
    .create();
}

function test(e){
    Logger.log(JSON.stringify(e))
    Logger.log(e.range)
    Logger.log(e.namedValues)
    Logger.log(e.values)
    Logger.log(e.triggerUid)
}

Note the difference between the event object if it is bound to the spreadsheet and the form.

Some links for further reading:

FORM EVENTS

• https://developers.google.com/apps-script/guides/triggers/events#google_forms_events
• https://developers.google.com/apps-script/reference/script/form-trigger-builder

SPREADSHEET EVENTS

• https://developers.google.com/apps-script/guides/triggers/events#google_sheets_events
• https://developers.google.com/apps-script/reference/script/spreadsheet-trigger-builder

I will request a review of the documentation to make this clearer.

The documentation has been updated to clarify the use of the onFormSubmit trigger for Sheets and Forms.

Sheets:

• Events
• onFormSubmit

Form:

• Events
• onFormSubmit