Talk:Demon boss/Strategies

From the RuneScape Wiki, the wiki for all things RuneScape
Jump to: navigation, search
This talk page is for discussing the Demon boss/Strategies page. 03:59, November 25, 2017 (UTC)I made this spreadsheet to help hunt them down. it should insert the timestamps automatically and be very easy to use. multiple people can use it at the same time. I has spript to insert the current date and time. the script it uses is below and the link is // /*Updated and maintain by*/

function onEdit(event) {

 var timezone = "GMT-5";
 var timestamp_format = "MM-dd-yyyy HH:mm"; // Timestamp Format. 
 var updateColName = "location";
 var timeStampColName = "start time";
 var sheet = event.source.getSheetByName('Sheet1') //Name of the sheet where you want to run this script.

 var actRng = event.source.getActiveRange();
 var editColumn = actRng.getColumn();
 var index = actRng.getRowIndex();
 var headers = sheet.getRange(1, 1, 1, sheet.getLastColumn()).getValues();
 var dateCol = headers[0].indexOf(timeStampColName);
 var updateCol = headers[0].indexOf(updateColName); updateCol = updateCol+1;
 if (dateCol > -1 && index > 1 && editColumn == updateCol) { // only timestamp if 'Last Updated' header exists, but not in the header row itself!
   var cell = sheet.getRange(index, dateCol + 1);
   var date = Utilities.formatDate(new Date(), timezone, timestamp_format);

} 03:59, November 25, 2017 (UTC)