Adding filter views to custom menu in Google Sheets

Asked Mar 14 '18 at 20:20

Active Aug 06 '20 at 08:16

Viewed 991 times

Just want to confirm that we currently cannot add saved filter views to custom menus.

Currently to access pre-saved Filter Views users have to go Data \ Filter Views \ etc.

I'd like to add a custom menu at the top level for them called "Our Views" and just list the custom views directly under that.

Making the custom menus seem easy, but my understanding is that there is still no way to get a hook on a saved filter view and open it. Nothing like this:

function onOpen() {
  var ui = SpreadsheetApp.getUi();
  // Or DocumentApp or FormApp.
  ui.createMenu('Custom Menu')
      .addItem('FilterView1', 'OpenFilterView1')
      .addToUi();
}

function OpenFilterView1(){
    openSavedFilter("Our First Filter View")
}

edited Oct 01 '19 at 11:01

Rafa Guillermo

14,474
3
18
54

asked Mar 14 '18 at 20:20

Randal Oulton

2

Filter views have their URLs, so the task is to open a link. You may like this answer: https://stackoverflow.com/a/47098533/5372400 – Max Makhrov Mar 16 '18 at 15:34
That does the trick! Thank you! – Randal Oulton Mar 16 '18 at 19:58

Adding filter views to custom menu in Google Sheets

0 Answers0