Skip to content

Instantly share code, notes, and snippets.

@eojji
Created June 25, 2018 02:42
Show Gist options
  • Save eojji/3c0abba42bac2c0bc2c80325e67aa555 to your computer and use it in GitHub Desktop.
Save eojji/3c0abba42bac2c0bc2c80325e67aa555 to your computer and use it in GitHub Desktop.
Request Team Drive - 1 https://m.cafe.naver.com/eojji/309
function getResponse() {
var form = FormApp.getActiveForm();
var formResponses = form.getResponses();
if (!formResponses || formResponses.length < 1) {
Logger.log('Not found form.getResponses()');
return;
}
var len = formResponses.length;
var response = formResponses[len - 1];
var responseId = response.getId();
var time = response.getTimestamp();
var email = response.getRespondentEmail().trim();
var itemResponses = response.getItemResponses();
var name = itemResponses[0].getResponse();
Logger.log('Time: %s, Email: %s, Name: %s', time, email, name);
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment