StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POError: strictValidationFailed
text
Body
copied!<p>I am trying to access a spreadsheet from a doGet() function which is executed when a link is clicked on by the user who gets an email from a form submit. I figured that I couldn't call getActiveSpreadsheet from doGet(). So I had sent in the spreadsheet id through the link along with the row number, and then called for the spreadsheet i need through openById, but when I do that I get a weird error "strictValidationFailed". That is it, that is all it says about the error. It gives no line no. or type of error. It seems like since this error started appearing when I started using the openById functionality, the error maybe somehow related to that. I am attaching the code snippet relevant to this below.</p> <pre><code>function onFormSubmit(event) { //On form submission send an email to the approver. var spreadsheet = SpreadsheetApp.getActiveSpreadsheet(); var approvalsheet = spreadsheet.getSheetByName("Approval Worksheet"); //Get values that have to be put on the email. var timestamp = event.values[0]; var username = event.values[1]; var campus = event.values[2]; var gltype = event.values[3]; var fullname = event.values[4]; var eMailAdd = event.values[5]; var description = event.values[6]; var replacement = event.values[7]; var usage = event.values[8]; var members = event.values[9]; var notes = event.values[11]; var initialowner = event.values[12]; //The service url that is required for approval on the email. var serviceurl = //hiding the service URL serviceurl+='&spreadsheetId='+spreadsheet.getId(); serviceurl+='&row='+approvalsheet.getLastRow(); //Setting the message that goes on the email sent to the approver. var message = 'There is a new Submission to the UAF List or Group aprooval Workflow\n\n\n'+'You can aproove this request here: '+serviceurl+ '\n\nTime of Submission: '+timestamp+'\n\nSubmitter Username: '+username +'\n\nCampus: '+campus+'\n\nFull Name: '+fullname+'\n\nMiddle Portion of Email Address: '+eMailAdd +'\n\nDescription of the List/Group: '+description + '\n\nIs this replacing an existing eMail List or Group? ' +replacement+'\n\nUsage: '+usage+'\n\nAnticipated number of members: '+members+'\n\nBrief notes about the request :' +notes+'\n\nAre you the initial owner :'+initialowner; //Title for the mail sent. var title = 'New Submission at '+timestamp; //Email address for the approver that gets the submission notification. var mailAdd = 'rssimon@alaska.edu' //Sending Email to the approver. MailApp.sendEmail(mailAdd, title, message); } function doGet(e) //On hitting approve button in the mail. { //retrieving spreadsheet ID from the approval link. var spreadsheet = SpreadsheetApp.openById(e.parameter['spreadsheetId']); //if (spreadsheet != null) { var approvalsheet = spreadsheet.getSheetByName("Approval Worksheet"); //} var row = e.parameter['row'];//retreiving row value that came from the approval link. //if(spreadsheet!=null) //{ approvalsheet.getRange(row, 17).setValue('Yes');//Setting the approval value on the spreadsheet to Yes. approvalsheet.getRange(row, 17).setBackground('White');//Setting the approval box color to white. //} //Creating UiApp for approval notification. var app = UiApp.createApplication(); //Create an instance of UiApp var label = app.createLabel(); //Create a lable on the UiApp label.setText('The list or group was approved');//Set text on the Label. app.add(label);//Add label to the UiApp instance. return app; } </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload