How to create Activate Sheet trigger based on field value selection

[#1]

Hi,

How to set the active sheet trigger based on field value selection,

for example I have a field which has all the sheet names, so when I select any field Value that particular sheet should open, how can we do this, please suggest......

[jerrysvensson]

There is an action called Activate sheet. You have to add Sheet ID as inparam.

Use a variable that contains current selection of your field value as Sheet ID?

[rubenmarin]

Hi savi, an idea could be to set each SheetID with the name of the field value, so you can set a trigger on selections of that field, with an action Design-->Activate sheet, and the sheet id value: =SheetsField

[kiranmanoharrode]

Create Inline Table

SheetList:

Load * Inline [

SheetID, SheetName

SH01, Home

SH02, Dashboard

SH03, Reports

];

Go to Settings -> Document Properties -> Triggers -> Select field (SheetName) from (Field Event Triggers) -> On select -> Add -> Layout -> Activate Sheet -> =Only(SheetID) in Sheet ID input box

On selection of SheetName trigger will activate corresponding Sheet

Regards,

Kiran