thwippp
2/10/2017 - 5:24 PM

Form Response URLs (Edit your response links) in Google Sheet

Form Response URLs (Edit your response links) in Google Sheet


function assignEditUrls() {
  var form = FormApp.openById('1l07_B6AeBEJKfHXyjlWtTTG_GLuE7GNzoZhoMGcw_U8');
    //enter form ID here-- use the actual form, not the preview
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Form Responses 1');
    //Change the sheet name as appropriate
  var data = sheet.getDataRange().getValues();
  var urlCol = 7; // 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(responses[i].getEditResponseUrl());
  }
  for (var j = 1; j < data.length; j++) {
    resultUrls.push([urls[timestamps.indexOf(data[j][0].setMilliseconds(0))]]);
  }
  sheet.getRange(2, urlCol, resultUrls.length).setValues(resultUrls);  
}

-------------------------------------------------
function getOtherSheetId() {
  var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = spreadsheet.getActiveSheet();
  var lastRow = sheet.getLastRow();
  var lastColumn = sheet.getLastColumn();
  
  var sheetNamesRow = sheet.getRange("sheetNames").getRow();
  
  for (var s = 0; s < lastRow; s++) {
   var getSheetNames = sheetNamesRow + 
    Logger.log(getSheetNames)
    .getValues();
   Logger.log(getSheetNames [[0]]);
  }
  //var getSheetNames = 
  //getSheetByName = spreadsheet.getSheetByName()
  //var sheetId = spreadsheet.getId();
  
  
}