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

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

i'm new coding , got pre set code utilize within spreadsheet google awesome table, , maintain getting error.

missing ) after argument list. (line 6, file "code)

here code:

var formurl = 'https://docs.google.com/a/waitrose.co.uk/forms/d/11-z44ow1ixp1tshkwjrbpa0dptoa2iinu5mcckuvf0o/viewform'; var sheetname = 'form responses 1'; var columnindex = 5; function geteditresponseurls(){ var sheet = spreadsheetapp.getactivespreadsheet().getsheetbyname(form responses 1); var info = sheet.getdatarange().getvalues(); var form = formapp.openbyurl(formurl); for(var = 2; < data.length; i++) { if(data[i][0] != '' && (data[i][columnindex-1] == '' || !data[i][columnindex-1])) { var timestamp = data[i][0]; var formsubmitted = form.getresponses(timestamp); if(formsubmitted.length < 1) continue; var editresponseurl = formsubmitted[0].geteditresponseurl(); sheet.getrange(i+1, columnindex).setvalue('<div style="width:100px"><a href="' + editresponseurl + '" target="_blank">edit entry</a></div>'); } } }

looks missing pair of quotes on line 6:

var sheet = spreadsheetapp.getactivespreadsheet().getsheetbyname(form responses 1);

should be

var sheet = spreadsheetapp.getactivespreadsheet().getsheetbyname("form responses 1");

javascript google-chrome