I would like to have a list with Names and next to them a Button, that brings me to that Spreadsheet. But i dont want to create a Button for each one manually.

Otherwise i would create a Sidebar with a Dropdown.. but would prefer the first solution :)

Thank you

Now I just have a single Name with a Single Button

CodePudding user response：

Yes, you can insert images with Apps Script and use it as buttons. Use

Code.gs

function onEdit(e) {
  try {
    if( ( e.value === undefined ) || ( e.value === "" ) ) return;
    if( e.range.getSheet().getName() === "SheetList" ) {
      if( e.range.getColumn() === 2 ) {
        e.range.setValue(false);
        e.source.setActiveSheet(e.source.getSheetByName(e.range.offset(0,-1).getValue()));
      }
    }
  }
  catch(err) {
    SpreadsheetApp.getUi().alert(err);
  }
}

Reference

• onEdit() Simple Trigger
• Simple Trigger Event Object