This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| function formSubmitReply(e) { | |
| var userEmail = “example@gmail.com”; | |
| var name = e.values[2]; | |
| var letterdraft = e.values[1] + " " + e.values[2]; | |
| var letterdraftHTML = '<p>' + e.values[1] + " " + e.values[2] +' </p>'; | |
| GmailApp.sendEmail (userEmail, name, letterdraft, {htmlBody: letterdraftHTML, name: name, replyTo: e.values[4], cc: “another@gmail.com, thirdemail@gmail.com“}); | |
| } |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* Send Confirmation Email with Google Forms */ | |
| function Initialize() { | |
| var triggers = ScriptApp.getProjectTriggers(); | |
| for (var i in triggers) { | |
| ScriptApp.deleteTrigger(triggers[i]); | |
| } | |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| function sendFormByEmail(e) | |
| { | |
| var email = "digitaledcollaborator@gmail.com"; | |
| var becky = "dec@longwood.edu"; | |
| var subject = "Google Docs Form Submitted"; | |
| var s = SpreadsheetApp.getActiveSheet(); | |
| var headers = s.getRange(1,1,1,s.getLastColumn()).getValues()[0]; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // Includes functions for exporting active sheet or all sheets as JSON object (also Python object syntax compatible). | |
| // Tweak the makePrettyJSON_ function to customize what kind of JSON to export. | |
| var FORMAT_ONELINE = 'One-line'; | |
| var FORMAT_MULTILINE = 'Multi-line'; | |
| var FORMAT_PRETTY = 'Pretty'; | |
| var LANGUAGE_JS = 'JavaScript'; | |
| var LANGUAGE_PYTHON = 'Python'; |
NewerOlder