/* GScript for adding edit urls to the response sheet. Needs to be run after every submit/form edit */

generateEditURL

/* GScript for adding edit urls to the response sheet. Needs to be run after every submit/form edit */

function assignEditUrls() {
  var form = FormApp.openById('FORM_ID');
  var sheet = SpreadsheetApp.openById('SPREADSHEET_ID').getSheetByName('SPREADSHEET_NAME');
  var data = sheet.getDataRange().getValues();
  var urlCol = 7;  //COLUMN NUMBER
  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(responses[i].getEditResponseUrl());
  }
  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);  
}