/**
  * Gets the edit response URL for a single (the last)
  * form submission on form submit and writes it to the destination sheet
  * in a column that the user chooses by entering 'Edit URL' in
  * the first row of an empty column.
  */


var FORM_ID = '1234567890';

function onFormSubmit(e) {
  var ss = SpreadsheetApp.getActive();
  var sheet = ss.getActiveSheet();
  var range = e.range;
  var values = e.namedValues; Logger.log(values);
  var row = range.getRowIndex();
  var headers = sheet.getRange('1:1').getValues();
  var editUrlCol = headers[0].indexOf('Edit URL') + 1;

  var form = FormApp.openById(FORM_ID);
  var formResponses = form.getResponses();
  var lastResponse = formResponses[formResponses.length - 1]; Logger.log(lastResponse);
  var editUrl = getShortEditUrl_(lastResponse);

  sheet.getRange(row, editUrlCol).setValue(editUrl);

}

function getShortEditUrl_(formResponse) {
  var url = UrlShortener.Url.insert({
    longUrl: formResponse.getEditResponseUrl()
    });
  return url.id;
}