Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Google Apps Script Form: e.namedValues logs nothing

I have a very basic Google Apps form with two questions, Resource (radio button with two options) and Name (Text Field). I'd like to pick the form values upon submission so I've set up a trigger (on form submit) to call a function:

function onFormSubmit(e) {
  Logger.log(e.namedValues["Resource"]);
}

Any idea what I'm doing wrong?

like image 434
jwesonga Avatar asked Feb 23 '26 23:02

jwesonga


1 Answers

I figured the way to achieve this, here's the code:

function onFormSubmit(e) {
  var frm = FormApp.getActiveForm().getItems();
  var rsc = e.response.getResponseForItem(frm[0]).getResponse();
  var reasonSubmitted = e.response.getResponseForItem(frm[1]).getResponse();
  var dateRequested = e.response.getResponseForItem(frm[2]).getResponse();

   var submitter = Session.getActiveUser().getEmail();

  //Logger.log(e.response);
  Logger.log("resource: " + rsc
  + " reason: " + "resource: " + reasonSubmitted);
  }

This will give you access to the individual responses for each question

like image 124
jwesonga Avatar answered Feb 27 '26 03:02

jwesonga