The onSubmit trigger in Google Forms is causing the e.namedValues variable to be

Question

The onSubmit trigger in Google Forms is causing the e.namedValues variable to be

My apps script has a form submit trigger configured as shown below: https://i.sstatic.net/FNgCD.png

The function onSubmit looks like this:

function onSubmit(e) {
  console.log("Form submitted", JSON.stringify(e.namedValues));
  console.log("Form submitted", JSON.stringify(e));

}

However, when I submit the form, the trigger fires and the function executes. But strangely, e.namedValues is undefined.

https://i.sstatic.net/BGMdS.png

What could be causing this issue? (Even linking a spreadsheet to the form did not change the outcome).

javascript google-apps-script google-forms

Answer 1

Answer №1

We need to pull data from a Google Spreadsheet.

The form trigger does not include any named values.

Visit this page for information on two onFormSubmit triggers

Answer 2

We need to pull data from a Google Spreadsheet.

The form trigger does not include any named values.

Visit this page for information on two onFormSubmit triggers

Answer 3

Answer №2

Automatically Retrieve Responses from Google Forms

This code snippet enables you to automatically fetch responses submitted to your Google Form and view them in the Executions tab of Google Apps Script.

It's worth noting that this method bears some resemblance to @Cooper's technique mentioned in their recent comment.

const onSubmit = (e) => {
  var response = e.response;
  var itemResponses = response.getItemResponses();
  var formResponse = {};

  itemResponses.forEach(itemResponses => {
    var itemTitle = itemResponses.getItem().getTitle();
    var value = itemResponses.getResponse();
    formResponse[itemTitle] = value;
  });
  console.log("Response received: " + JSON.stringify(formResponse));
}

The example form appears as shown below:

https://i.sstatic.net/R0Zrv.png

OUTPUT

https://i.sstatic.net/B1bys.png

REFERENCE

Answer 4

Automatically Retrieve Responses from Google Forms

This code snippet enables you to automatically fetch responses submitted to your Google Form and view them in the Executions tab of Google Apps Script.

It's worth noting that this method bears some resemblance to @Cooper's technique mentioned in their recent comment.

const onSubmit = (e) => {
  var response = e.response;
  var itemResponses = response.getItemResponses();
  var formResponse = {};

  itemResponses.forEach(itemResponses => {
    var itemTitle = itemResponses.getItem().getTitle();
    var value = itemResponses.getResponse();
    formResponse[itemTitle] = value;
  });
  console.log("Response received: " + JSON.stringify(formResponse));
}

The example form appears as shown below:

https://i.sstatic.net/R0Zrv.png

OUTPUT

https://i.sstatic.net/B1bys.png

The onSubmit trigger in Google Forms is causing the e.namedValues variable to be

Answer №1

Answer №2

Automatically Retrieve Responses from Google Forms

OUTPUT

REFERENCE

Similar questions

What is the equivalent in AngularJS to triggering a form submission event like jQuery's $("#formID").submit()?

Having trouble getting my local website to load the CSS stylesheet through Express and Node.js in my browser

Tips for organizing ng-repeat information according to a condition of true or false

Encountering a difficulty in sending data to the server through ajax with Cordova

When the JavaScript alert appears, play audio and then pause it when the alert is closed

Creating a Javascript map that holds an array of strings as values, mirroring the functionality found in Java

Unusual manifestation of the Array

Linking Redux to the highest level of my application is not functioning as expected

Import and Showcase Collada Models with Textures using Three.js and file inputs

JavaScript Promise Synchronization

The battle between AngularJS, Factory, $scope, and promises intensifies

Node.js implementation to transfer MongoDB to CSV, with the unfortunate loss of certain columns

Automatically reveal or conceal an element based on the entry of a value in an input field, without relying on the keyup() or click events

How can I modify this section of the code in Google Script to retrieve all columns?

Adapt appearance according to the length of the text

How can I force an element to overflow without being affected by its parent's overflow style in CSS/HTML/JS, even if the parent is

We were unable to locate the module: Unable to locate './components/counter' in 'C:/...democounter-appsrc'

Automatically calculate the total using jQuery in a Laravel project

Using the parseInt method, you can easily combine integers and strings to perform addition and string concatenation simultaneously

Tips for avoiding the influence of the parent div's opacity on child divs within a Primeng Carousel