dinsdag 10 november 2020

How to randomize an array of persons with #GoogleAppsScript #DIY

 For a 'breakout room' or so ....

function randomizeAnArray(){

    var participantsColumn = "a number";
    var ss = SpreadsheetApp.getActiveSpreadsheet();
    var sheet = ss.getSheetByName("SHEETNAME");
    var participants = sheet.getRange(2,participantsColumn,sheet.getLastRow(),1)
    .getValues()
    .filter(function(participant){return participant !== "";})
    .map(function(participant){return [Math.random(),participant]});
    
    return participants.sort()

}

maandag 9 november 2020

Third thursdays a month a year with #GoogleAppsScript

I am organising - I would like to organise - something every third thursday a month a year. So how to collect the dates of all those third thursdays.

 
function thirdThursdaysArray(year){
 
 var thirdThursdaysAMonthAYear = [];
 
 var daysAMonth = [31,28,31,30,31,30,31,31,30,31,30,31];
 
   for(var i=0;i< daysAMonth.length;i++){
  
   var thirdThursdaysAMonth = [];
   
     for(var j=0;j<daysAMonth[i];j++){
     
       var month = i;
       var day = j+1;
              
         if(new Date(year,month,day).getDay() == 4){
         
           thirdThursdaysAMonth.push(new Date(year,month,day));
           
         }
     }
     
     thirdThursdaysAMonthAYear.push(thirdThursdaysAMonth[2]);
   }
 
 return thirdThursdaysAMonthAYear;
 
 }