Switching between Filter views using apps script

2019-01-29 07:38发布

问题:

I would like to create a custom menu with items to switch between filter views on particular sheet. Is there any way? I need filter views, because of sorting and filtering but still keeping edit option. Filter function doesn't work due to that fact.

Thanks.

回答1:

Filter View doesn't have support on apps Script yet It's an old feature request



回答2:

It is possible to access and edit filters using the Advanced Sheets service, as seen in this example.