Guest User

Untitled

a guest
Feb 18th, 2019
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.49 KB | None | 0 0
  1. function onEdit(e) {
  2. var sheet = e.source.getActiveSheet();
  3. var sheetName = sheet.getName();
  4. //if editing specific sheet
  5. if (sheetName == "draft_test" ) {
  6. //if editing 6th column
  7. var r = e.source.getActiveRange();
  8. if (r.getColumn() == 6 ) {
  9. var player = sheet.getActiveCell().getValue();
  10. // Display a dialog box with a message and "Yes" and "No" buttons.
  11. var ui = SpreadsheetApp.getUi();
  12. var response = ui.alert('Do you want to draft '+player+'?', ui.ButtonSet.YES_NO);
  13. // Process the user's response.
  14. if (response == ui.Button.YES) {
  15. //***********FOR SOME REASON EXECUTING THIS FUNCTION ISNT WORKING******************
  16. emailLeague();
  17. //sortAutoRoster();
  18. } else {
  19. }
  20. }
  21. }
  22. }
  23.  
  24. function emailLeague() {
  25. var draftSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("draft_test");
  26. var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("test_email");
  27. var emailSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Manager Info");
  28.  
  29. //actual email address omitted
  30. var recipient = 'emailaddress@gmail.com';
  31. //get array of all picks on "draft test" tab, and find latest one
  32. var picks = draftSheet.getRange(3,6,146,1).getValues();
  33.  
  34. for (var i=0; i<picks.length; i++){
  35. if (picks[i] == ""){
  36. var latestPick = i;
  37. break;
  38. }
  39. }
  40. var subject = sheet.getRange(i+1, 2).getValue();
  41. var body = sheet.getRange(i+1, 1).getValue();
  42. MailApp.sendEmail(recipient, subject, body);
  43. }
Add Comment
Please, Sign In to add comment