Guest User

Untitled

a guest
Jun 25th, 2018
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.58 KB | None | 0 0
  1. function getResponse() {
  2. var form = FormApp.getActiveForm();
  3. var formResponses = form.getResponses();
  4. if (!formResponses || formResponses.length < 1) {
  5. Logger.log('Not found form.getResponses()');
  6. return;
  7. }
  8. var len = formResponses.length;
  9. var response = formResponses[len - 1];
  10. var responseId = response.getId();
  11. var time = response.getTimestamp();
  12. var email = response.getRespondentEmail().trim();
  13. var itemResponses = response.getItemResponses();
  14. var name = itemResponses[0].getResponse();
  15. Logger.log('Time: %s, Email: %s, Name: %s', time, email, name);
  16. }
Add Comment
Please, Sign In to add comment