function email_and_assign_edit_urls(e) {
  var form = FormApp.getActiveForm();
  var ss = SpreadsheetApp.openById(form.getDestinationId());
  var sheet = ss.getSheets()[0];

  Logger.log(form.getDestinationId())
  var data = sheet.getDataRange().getValues();
  var urlCol = 9; // column number where URL's should be populated; A = 1, B = 2 etc
  var responses = form.getResponses();
  var timestamps = [], urls = [], resultUrls = [];

  for (var i = 0; i < responses.length; i++) {
    timestamps.push(responses[i].getTimestamp().setMilliseconds(0));
    urls.push('=HYPERLINK("' + responses[i].getEditResponseUrl() + '", "edit")');
  }
  for (var j = 1; j < data.length; j++) {
    resultUrls.push([data[j][0]?urls[timestamps.indexOf(data[j][0].setMilliseconds(0))]:'']);
  }
  sheet.getRange(2, urlCol, resultUrls.length).setValues(resultUrls); 
  
  Logger.log("hello")
  
//  var formResponses = form.getResponses();
//  var formResponse = formResponses[i];
  Logger.log(e.response)
  var formResponse = e.response
  var itemResponses = formResponse.getItemResponses();
  var email_address = itemResponses[0].getResponse();
  Logger.log(email_address)
   
  var= message + "\n To update your response, use the following link: 
  message = message + "\n" + formResponse.getEditResponseUrl()
  
  var subject = "Macbook data transfer - retain for your records";
  MailApp.sendEmail(email_address, subject, message);
  

}