I have a Google Form that is used as a sign up form. This form has a question requesting emails. It uses the email validation. I have a Google Drive folder that I want everyone who signs up to be able to view. Some of these files, I want to be able to easily set it up so they can edit it. How can I do this?
Share Google Drive Folder with submitters of Google Form
google spreadsheets;google drive;google forms
Short answerThis could be done by using Google Apps Script.InstructionsOpen the form editorClick More (the three dots buttons) > Script editor...Add the script included belowClick on Resourses > Current project triggersClick on Add a new triggerSet the parameters as shown in the following snapshot:Click save.Scriptfunction onFormSubmit(e) {  // Set custom parameters (change this)  var emailQuestionTitle = 'Email';  var folderId = '0B5xqUTHHK_n6d3pWc2l5dVBWZ1k';  // Get the email  var itemResponses = e.response.getItemResponses();  var i = 0;  try {    while(itemResponses[i].getItem().getTitle() != emailQuestionTitle){      i++;        }  } catch(e) {    Logger.log(emailQuestionTitle + ' not found');  }  var emailAddress = itemResponses[i].getResponse();  // Share the folder  var folder = DriveApp.getFolderById(folderId);  folder.addEditor(emailAddress);}