Advertisement
dioxik

Untitled

Feb 6th, 2015
231
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. function assignEditUrls() {
  2.   var form = FormApp.openById('170AKcBTHkFRy-qYn7XXXXXimXh9Ro8lbgfeidDRftt0');     // klucz id Formy
  3.   var sheet = SpreadsheetApp.openById('1n4aRjXduPabVYaNJ5qjhjFV_tS3nIygIXtJKPyB2dsE').getSheetByName('Edycja listy');     //id skoroszytu + nazwa arkusza
  4.   var data = sheet.getDataRange().getValues();
  5.   var urlCol = 15; // gdzie URL ma być umieszczony ; A = 1, B = 2 etc
  6.   var responses = form.getResponses();
  7.   var timestamps = [], urls = [], resultUrls = [];
  8.  
  9.   for (var i = 0; i < responses.length; i++) {
  10.     timestamps.push(responses[i].getTimestamp().setMilliseconds(0));
  11.     urls.push(responses[i].getEditResponseUrl());
  12.   }
  13.   for (var j = 1; j < data.length; j++) {
  14.     resultUrls.push([data[j][0]?urls[timestamps.indexOf(data[j][0].setMilliseconds(0))]:'']);
  15.   }
  16.   sheet.getRange(2, urlCol, resultUrls.length).setValues(resultUrls);  
  17. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement