1

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?

1

Short answer

This could be done by using Google Apps Script.

Instructions

  1. Open the form editor
  2. Click More (the three dots buttons) > Script editor...
  3. Add the script included below
  4. Click on Resourses > Current project triggers
  5. Click on Add a new trigger
  6. Set the parameters as shown in the following snapshot:

Current project's triggers

  1. Click save.

Script

function 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);
}

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.