Emails not coming from a Google Spreadsheet issues

[Randy Damewood]

Hello all,

We use a Google Form and spreadsheet for our help desk system. It has been working fine sending out emails when someone has made a ticket for the past year and a half. Starting on about Tuesday we noticed one that did not go through. We have had this happen before, but I would get a script error or some notice that something went wrong, no big deal. 

Well the ticket came through about 6 hours later. We did not think that much about it. Starting yesterday and into today more tickets have not been getting through. In fact, none except 1 out of about 7 or 8. I know that there was a major up date to sheets this week. Anybody else experience this - and does anybody know what I could try?

Thanks so much.

RD

--
Randy Damewood

Director of Technology

Coffee County Schools

931-222-1055

@randydamewood

Google+

[Bjorn Behrendt]

did you upgrade to the new spreadsheet?  There are known issues with scripts. 

Bjorn Behrendt M.Ed ~ Never Stop Learning

   b...@askbj.net | (802) 772-0003

   Google Apps For Education Certified Trainer

My Sites

 ~ Edlisten.com ~ Educational Podcast

 ~ AskBj.net ~ Online Training and Ed Tech Resources

 ~ VTed.org ~ Vermont's Personal Learning Network

gClassFolders ~ Create Google folders for your class.

--
--
You received this message because you are subscribed to the Google
Groups "Google Apps K12 Technical Forum" group.
To post to this group, send email to k12ap...@googlegroups.com
To unsubscribe from this group, send email to
k12appstech...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/k12appstech?hl=en?hl=en
 
---
You received this message because you are subscribed to the Google Groups "Google Apps K12 Technical Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to k12appstech...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[Jesse Thorstad]

We have a couple of forms that are heavily dependent on FormMule and/or Autocrat for various functions. I find that 25% of the time, a formula is not copied down, or an email is not sent...to the point where I need to babysit the spreadsheets a bit to make sure they're behaving. I don't feel 100%A confidence that they are working correctly all the time.

Are you using any scripts, or just the build-in notifier on change or form submit? That part seems to be pretty solid for me.

Jesse Thorstad
Technology Specialist
Fergus Falls (MN) Public Schools
http://www.isd544.org
218-998-0544  x2036

[Doug Blatti]

Here is the list of problems with the new sheets and apps script:

 

https://developers.google.com/apps-script/migration/sheets

 

Something listed here is likely effecting you (assuming you have the new version of sheets).

 

Doug Blatti

Technology Program Manager

Community High School District 155
@dblatti, +DougBlatti, http://blatti.net

[Randy Damewood]

Thanks - That could be it -  Here is a copy of my script  How can I tell what version of sheets that I am using.

function formSubmitReply(e) {

  var userEmail = e.values[1];

  var userSchool=e.values[3];

  var userDescript= e.values[8];

  var name= e.values[2];

  var roomnumber= e.values[4];

  var actionstaken= e.values[5];

  var typeofdevice= e.values[7];

  var availability= e.values[14];

  MailApp.sendEmail(userEmail, 

                    "Help Desk Ticket", 

                    "Thanks for submitting your issue. \n\nWe'll start " +

                    "working on it as soon as possible." +

                    "\n\nHere are the details of the ticket your have created:" +

                    "A ticket was created for location " +userSchool  +" Room "+ roomnumber + 

                   

                   "\n\n\Type of Device: "+ typeofdevice +

                   "\n\nThe following is a description of the issue:\n\n " + userDescript

                   

                   + "\n\nActions that were taken to resolve the issue"+ actionstaken +

                    "\n\nAvailability"+availability

                    

                    ,                    

                     {name:"Thank you, \n\nHelp Desk"});

 MailApp.sendEmail("dame...@k12coffee.net,we...@k12coffee.net, we...@k12coffee.net, reedj...@k12coffee.net","A New Ticket has been created at " + userSchool + " by " +name ,

                   "A Help Desk Ticket has been created at location " +userSchool +" Room "+ roomnumber + 

                   

                   "\n\n\Type of Device: "+ typeofdevice +

                   "\n\nThe following is a description of the issue:\n\n" + userDescript

                   

                   + "\n\nActions Taken "+ actionstaken +

                    "\n\nAvailability, "+availability,                   

                   

                   {name:"Help Desk"})

}

[Jesse Thorstad]

You would have had to have gone into your Drive settings and activated the new Sheets...it only rolled out a few days ago.

And, only NEW sheets would have the new sheet settings/features. So if your spreadsheet is older than a week, it's almost certainly the "old" sheets.

Jesse Thorstad
Technology Specialist
Fergus Falls (MN) Public Schools
http://www.isd544.org
218-998-0544  x2036

[Tyler Loch]

I've noticed this over the last three days with a script that is triggered by a custom UI.

Only ~10% of emails are actually being delivered, though strangely enough, all of them are showing in my Sent folder...

The script I use does touch some spreadsheets (created months ago), but the spreadsheets themselves are not what trigger the email action.

Tyler Loch, Network & Systems Specialist

Community Consolidated School District 21 - Wheeling, Illinois, USA

847.520.6283

http://www.ccsd21.org