*Error Details:*
*
*
I've created a Google Spreadsheet and form for same. Wrote a Google Script
function "formSubmitReply" which send email on form submitting. Please let
us know the reason and resolution for same.
*Below is the script:*
function formSubmitReply(e) {
var userName = e.values[1];
var primaryPhone= e.values[2];
var phoneType = e.values[3];
var bestTime = e.values[4];
var secondaryPhone = e.values[5];
var email = e.values[6];
var address = e.values[7];
var city = e.values[8];
var state = e.values[9];
var zipCode = e.values[10];
var locationAsso = e.values[11];
var currCarrier = e.values[12];
var addInformation = e.values[13];
MailApp.sendEmail("[email protected]",
"Quote Request Submitted by " + userName + "",
"Hi, \n\nPlease find the quote details:\n\n" +
"Name: " + userName + "\n"+
"Primary Phone Number: " + primaryPhone + " (" +
phoneType + "), Best time to call: " + bestTime + "\n" +
"Secondary Phone Number: " + secondaryPhone + "\n"+
"Email Address: " + email + "\n"+
"Address: " + address + "\n"+
"City: " + city + "\n"+
"State: " + state + "\n"+
"Zip Code: " + zipCode + "\n"+
"Your location association: " + locationAsso + "\n"+
"Current Auto Insurance Carrier: " + currCarrier + "\n"+
"Additional Information: " + addInformation +
"\n\n\nRegards,\nQuote
Request System.\n\nNote: This is system generated email. Please do not
reply\n\n\n",
{name:"Quote System", replyTo:"[email protected]"} )
;
}
*Below is the Error* received from [email protected]
*
Your script, quoteRequest_calcas, has recently failed to finish
successfully. A summary of the failure(s) is shown below. To configure the
triggers for this script, or change your setting for receiving future
failure notifications, click
here<http://spreadsheets.google.com/a/macros/calcas.com/triggers?lib=0e0ed43cf73f7711>
.
Summary:
Error Message
Count
We're sorry, a server error occurred. Please wait a bit and try again.
12
Details:
Start
Function
Error Message
Trigger
End
2/8/11 4:05 PM
formSubmitReply
We're sorry, a server error occurred. Please wait a bit and try again.
formSubmit
2/8/11 4:05 PM
*
*
*