Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a report that I created a "subtab" within a tab. It has a condition to switch to another sheet when you click on a link. On the second "tab", I have sheet properties to lock certain fields and then unlock and clear the fields when I leave the sheet. It works just fine until I use Webview and then the behavior seems to change and the fields stay locked.
On the "second" tab...I have triggers setup for OnActivate Sheet to select 3 fields and then lock those 3 fields. OnLeave Sheet, I have Unlock All and Clear All.
On the "first" tab...I have triggers setup for OnActivate Sheet to Unlock All and Clear All.
Any suggestions as to what I can do differently?
I have two different text objects and two different sheets. These are the two text objects and the Properties for the second text object.
Here is the best I can do at a Test application.
See if this is what you are after:
The fields do not lock when I go from the Business Dashboard - EM sheet back to the Business Dashboard sheet and the Employee Performance tab.
Added actions to the OnLeave event for the Business Dashboard - EM sheet.
Is this the only way to accomplish this as I have 20 other sheets within the full application...
I don't know of any other way.
If you have 20 other sheets, this method probably won't work either. The logic only works because there is just a single sheet to go back to.
You may be able to put the select and lock logic in a macro.
Why not just show SH01 and SH02 as tabs instead of hiding them and using buttons. Then you could use the OnActivate and OnLeave actions for the sheets.
The reason I hide them and use buttons is because I have 20 sheets and it's getting to be too much. We are actually reducing the amount of sheets by utilizing the buttons and trying to keep it from getting cluttered.
Maybe you could use getactivesheetid(). If you assign a variable: vActiveSheet =GetActiveSheetID()
Then you could use the OnChange variable event trigger to do your Field selections and locking.
Did you ever look at my last post?