Use a Form response to create a folder in Drive when form is submitted

Question

I have a Google form, first question is "Client Name" I would like my script to create a folder in Drive and have the name of the folder be the response to the "Client Name" question.

 function main() { 

var form = FormApp.getActiveForm();
var formResponses = form.getResponses();
for (var i = 0; i < formResponses.length; i++) {
  var formResponse = formResponses[i];
  var itemResponses = formResponse.getItemResponses();
for (var j = 0; j < itemResponses.length; j++) 
  var itemResponse = itemResponses[j];
 }
     DriveApp.getRootFolder().createFolder(itemResponse);

}

I've been trying different combinations of this but have had no success.

score 0 · Answer 1 · answered Dec 06 '17 at 23:55

You have to use a on form submit event. Assuming that the Client Name is the first question, then the following on form submit installable trigger added to the form will create the folder with the given name:

function createFolder(e) {
  var items = e.response.getItemResponses()
  var name = items[0].getResponse();
  DriveApp.createFolder(name);
}

How to get form values in the submit event handler?

Use a Form response to create a folder in Drive when form is submitted

1 Answers1