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()

}