Advertisement
Guest User

Untitled

a guest
Jan 7th, 2017
186
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.25 KB | None | 0 0
  1. function AddPrestige()
  2. {
  3. var ss = SpreadsheetApp.getActiveSpreadsheet();
  4. var calculatorSheet = ss.getSheetByName("Calculators");
  5. var proressTrackerSheet = ss.getSheetByName("Progress Tracker");
  6.  
  7. var column = proressTrackerSheet.getRange('I:I');
  8. var values = column.getValues(); // get all data in one call
  9. var emptyRowIndex = 0;
  10. while ( values[emptyRowIndex][0] != "" )
  11. {
  12. emptyRowIndex++;
  13. }
  14.  
  15. var dateCellName = ('I' + (emptyRowIndex + 1));
  16. var dateCell = proressTrackerSheet.getRange(dateCellName);
  17.  
  18. var timeCellName = ('J' + (emptyRowIndex + 1));
  19. var timeCell = proressTrackerSheet.getRange(timeCellName);
  20.  
  21. var bookOfShadowsCellName = ('L' + (emptyRowIndex + 1));
  22. var bookOfShadowsCell = proressTrackerSheet.getRange(bookOfShadowsCellName);
  23.  
  24. var d = new Date();
  25. var dateString = d.toDateString();
  26. var timeString = d.toLocaleTimeString('en-GB');
  27.  
  28. // Remove 'GMT' or equivelent
  29. var index = timeString.indexOf(" ");
  30. timeString = timeString.substring(0, index);
  31.  
  32. dateCell.setValue(dateString);
  33. timeCell.setValue(timeString);
  34.  
  35. var bookOfShadowsLevel = calculatorSheet.getRange('Q48').getDisplayValue();
  36. bookOfShadowsCell.setValue(bookOfShadowsLevel);
  37. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement