Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
When i select a value in the check box then it should show the new sheet (Make it visible from hidden) and navigate to the activated sheet specific sheet of the selected value.If the list box has Customer,Product and when user selects customer it should enable the sheet customer and navigate to the customer sheet. I am able to make the sheet visible through the trigger. But i am not able to achieve both the actions at the same time using actions. Any suggestions
Create an Inline table with SHEETNAME and SHEETID (Product,SH01 etc..). Use the sheetname as a listbox with checkbox properties and enable select only one value.
Create a variable vActiveSheetID as Only(SHEETID). In each of the sheet properties set the visible condition as
vActiveSheetID = <sheetid>.
Go to document prooperties triggers, on field triggers, when selected and the following actions:
ActivateSheet and give sheet ID = vActiveSheetID.
Regards,
Kiran.