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?
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
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With