I want to update my sidebar whenever user clicks on different sheets. Basically, whenever a sheet is activated. I have explored onChange and onEdit events but they don't help my cause. I didn't come across any apps-script event which will help me capture sheet activations. Is there any way we can capture onSheetActivate?
Asked
Active
Viewed 32 times
0
-
Get your sidebar code to poll. – Cooper Sep 15 '20 at 10:03
-
Actually, updating sidebar is just one of the tasks that I want to do. The main area of concern is capturing the sheet activate event. If there is a sidebar, I can poll it. But, what about use cases where I don't have a sidebar. Say, I want to update the menu items on sheet activate. I have a dynamic menu which gets updated based on the contents of a sheet. when I am on sheet1, I have menu1 and on sheet2, I have to show menu2. Hope my question is clear now. – Putta Sep 15 '20 at 12:42
-
There is no such event – Cooper Sep 15 '20 at 13:03
-
Any other way of getting this done? – Putta Sep 15 '20 at 13:55