Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Changing values of variable on leave sheet or open sheet

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.

1 Solution

Accepted Solutions
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

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

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

View solution in original post

2 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

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

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Not applicable
Author

Thanks Kaushik.

Never mind I did the same.