I'm new to coding and got it pre-set code to use a spreadsheet to a Google terrible table , And I keep receiving this error.
After missing) argument list (Line 6, the file "code)
Here is my code:
var formURL = 'https://docs.google.com/a/ Waitrose.co.uk/forms/d/11-z44oW1ixP1tShkwjrBpa0DptOA2IinU5MCCkUvf0o/viewform'; var sheetName = 'form response 1'; var column index = 5; function getEditResponseUrls () {var sheet = SpreadsheetApp.getActiveSpreadsheet (). GetSheetByName (for quick response 1); Var data = sheet.getDataRange (). GetValues (); var form = FormApp.openByUrl (formURL); (var i = 2; i & lt; data.length; i ++) {if (data [i] [0]! = '' & Amp; amp; amp; and (data [i] [columnIndex-1] == '' || data [i] [columnIndex-1]) {var timestamp = data [i] [0]; var for Submitted = form.gate response (timestamp); if (formabmited.line and lieutenant; 1) is in progress; var editResponseUrl = formSubmitted [0] .getEditResponseUrl (); Sheet.GateRnz (i + 1, column index) .setValue (' & lt; div style = "width: 100px" & gt; & lt; a href = " '+ editResponseUrl +'" target = "_ blank" & gt; Edit listing & lt; / A & gt; & Lt; / Div & gt; '}}}}}
should be
var sheet = SpreadsheetApp.getActiveSpreadsheet (). GetSheetByName ("Form Responses 1");
Comments
Post a Comment