I'm getting really frustrated trying to publish my app and on AJAX and am not able to "Clear All" when using an Activate Object trigger when using a button to activate a new sheet. However, it DOES work when simply clicking between tabs.
So if the "OnActivateSheet" trigger is set to "Clear All", it only works when clicking between tabs at the top. However, if you use a button to "Activate" a sheet, once you are on the new sheet, the "Clear All" action will not be triggered.
Does anyone have a solution for this?