Changing values of variable on leave sheet or open sheet

[#1]

Hi All,

I am stuck with a weird situation.

I created a menu button which shows the list of menu items in it.

When i click on any menu item (it basically has activate sheet action in each item) it navigate to other sheet.

Now when i navigate to other sheet the menu still remains open.

My requirement is to close that menu as soon as other sheet is opened or basically making the value of that variable which opens the menu to make it 0.

The alternative i tried are-

Adding triggers on open & leave sheet to make the variable value as 0 - Sheet level triggers don't work in AJAX mode.

Please help on this as document level triggers work but sheet level don't.

[kaushiknsolanki · Accepted solution]

Hi,

You can place one more action to each of that item which will set the variable to 0.

Regards,

Kaushik Solanki

[#3]

Thanks Kaushik.

Never mind I did the same.