Sorting Script in Sheets...What Am I Doing Wrong?

[Jennifer Preissel]

Complete novice here! I'm a high school math teacher and I made a spreadsheet of seating arrangements which I randomize daily. But rather than doing the data sort every day, I want to just push a button in the document. 

Sharing screengrabs of the spreadsheet and of the script I started, which was meant to randomize the tab for the Green Section. But when I run it, I get an error. Any thoughts as to why?

[Jon Couch]

Here's a quick ChatGPT script that seems to work for me. I'm assuming first and last names are in columns B & C from Row 13 to Row 30

function myFunction() {

  const ss=SpreadsheetApp.getActiveSpreadsheet();

  const sheet = ss.getSheetByName("Green S1");

  const range = sheet.getRange("B13:C30");

  // Get the values in Columns B and C

  var values = range.getValues();

  // Create an array to store the shuffled rows

  var shuffledRows = [];

  // Randomly shuffle the rows

  while (values.length > 0) {

    var randomIndex = Math.floor(Math.random() * values.length);

    var randomRow = values.splice(randomIndex, 1)[0];

    shuffledRows.push(randomRow);

  }

  // Set the shuffled rows back in Columns B&C

  range.setValues(shuffledRows);

}

Good luck,

Jon

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/feefdff9-22b0-44d4-b290-e43d30ae00c0n%40googlegroups.com.

[Keith Andersen]

Jennifer

Make a copy of this and you will become sole owner with editor privileges. I hope it meets your needs.

https://docs.google.com/spreadsheets/d/1JV5s8i1hqXeh-OnCiJp3ac2WaHKGpaCPYIkdmMZ1Qkk/edit?usp=sharing

Cheers

Keith

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CADjEj863mQyuxZUo%2BH-ep1Z0GQREFEeEYFs4T84p4aPuteuW-w%40mail.gmail.com.

[Keith Andersen]

Jennifer,

If you haven't already downloaded it, I revised it yesterday and made it so that you can copy the sheet,  rename it to another class, and then put in that class's children and it will work for any and all classes you need to make sheets for.

👍 Keith