javascript - Missing ) after arguement list. (line 6 file "code") -


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