Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function assignEditUrls() {
- var form = FormApp.openById('170AKcBTHkFRy-qYn7XXXXXimXh9Ro8lbgfeidDRftt0'); // klucz id Formy
- var sheet = SpreadsheetApp.openById('1n4aRjXduPabVYaNJ5qjhjFV_tS3nIygIXtJKPyB2dsE').getSheetByName('Edycja listy'); //id skoroszytu + nazwa arkusza
- var data = sheet.getDataRange().getValues();
- var urlCol = 15; // gdzie URL ma być umieszczony ; 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([data[j][0]?urls[timestamps.indexOf(data[j][0].setMilliseconds(0))]:'']);
- }
- sheet.getRange(2, urlCol, resultUrls.length).setValues(resultUrls);
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement