Clever Geek Handbook

Use the form response to create a Drive folder when the form is submitted

I have a Google Form, the first question is "Customer Name". I would like my script to create a folder in Drive and the folder name is the answer 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 have tried different combinations but have no success.

+3


source to share


1 answer


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

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


Related

0


source






More articles:


All Articles