Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- var subject = form.subject; // Title of Email with class name
- var subject = index.html().getEmailSubject();
- // Send Email Script for Edit Email Section Popup HTML (using check boxes, etc.)
- function sendEmail() {
- var ui = SpreadsheetApp.getUi(); // Same variations.
- var result = ui.alert(
- 'Send Emails',
- 'Are you sure you want to send missing assignment emails?',
- ui.ButtonSet.YES_NO);
- // Process the user's response.
- if (result == ui.Button.YES) {
- // User clicked "Yes".
- var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Missing Student Information");
- Logger.log("test 1");
- var email_sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Template");
- Logger.log("test 2");
- var email_data = email_sheet.getDataRange().getValues();
- Logger.log("test 3");
- var startRow = 2; // First row of data to process
- var numRows = sheet.getDataRange().getNumRows(); // Number of rows to process
- Logger.log(numRows);
- // Fetch the range of cells A2:(numRows)3
- var dataRange = sheet.getRange(startRow, 1, numRows, 6);
- // Fetch values for each row in the Range.
- var data = dataRange.getValues();
- for (var i = 0; i < numRows;i++) {
- var row = data[i];
- var student_name = row[0]; // Gets student name
- var class = row[1]; // Gets class name
- var student_email = row[2]; // Gets student email address
- var parent_email = row[3]; // Gets parent email address
- var missing = row[4]; // Gets number of missing assignments
- var assign_list = row[5];
- Logger.log("Before get email subject header.");
- var subject = index.html().getEmailSubject(); // Title of Email with class name
- Logger.log("starting "+student_name+" "+missing+assign_list);
- Logger.log("After get email subject header.");
- <!DOCTYPE html>
- <html>
- <head>
- <base target="_top">
- <script>
- // Prevent forms from submitting.
- function preventFormSubmit() {
- var forms = document.querySelectorAll('form');
- for (var i = 0; i < forms.length; i++) {
- forms[i].addEventListener('submit', function(event) {
- event.preventDefault();
- });
- }
- }
- window.addEventListener('load', preventFormSubmit);
- function handleFormSubmit(formObject) {
- google.script.run.withSuccessHandler(updateUrl).SendEmails(formObject);
- google.script.host.close();
- }
- function updateUrl(url) {
- var div = document.getElementById('output');
- div.innerHTML = '<a href="' + url + '">Got it!</a>';
- }
- function setDefaultSubject(subject) {
- if (subject != null && subject != "") {
- var form = document.getElementById('myForm');
- form.Subject.value = subject;
- }
- }
- function setDefaultBody(body) {
- if (body != null && body != "") {
- var form = document.getElementById('myForm');
- form.Body.value = body;
- }
- }
- google.script.run
- .withSuccessHandler(setDefaultBody)
- .getEmailBody();
- google.script.run
- .withSuccessHandler(setDefaultSubject)
- .getEmailSubject();
- </script>
- </head>
- <body>
- <input type="checkbox" name="send_Students" checked="checked" /> Email Students <input type="checkbox" name="send_Parents" checked="checked" /> Email Parents <br/><br/>
- <form id="myForm" onsubmit="handleFormSubmit(this)">
- Email Subject: <input style="width:500px" name="Subject" type="text" value="Current Missing Assignments List"/>
- <br/name="Subject" type="text" value="Current Missing Assignments List"/>
- <br/>
- Email Body: <br/>
- <textarea name="Body" style="width:750px; height:400px">
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement