Creating a Button that will run a script to select a random number from a group of cells.

[Bill Roberson]

I have a Google Spreadsheet where I have created a button "Click to Select Random Room Number" and a cell beside the button where I would like this room number to be displayed ("D1"). I have recorded a list of room numbers in cells G2 through G155 that I would like the script to refer to when selecting a random number. 

I have figured out how to generate a random number from this selection but I cannot figure out how to make this work with the use of App Scripts. Ideally, each time I click the button that I've created, I'd like the script to run and select a new/random number each time the button is clicked. Where do I start?

[Ben Ronkin]

Use this code:

const pickRoomNumber = () => {

  const ss = SpreadsheetApp.getActive();

  const sh = ss.getActiveSheet();

  const options = sh

    .getRange('G2:G')

    .getValues()

    .flat()

    .filter((x) => x.toString().length > 0);

  const pos = Math.floor(Math.random() * options.length);

  sh.getRange('D1').setValue(options[pos]);

};

[Bill Roberson]

Thank you.