Activate Sheet logic

[abhaysingh]

I want the logic that if I select Particular field value than other sheet will activate..

is it possible?????

[Anonymous]

Hi,

navigate to document properties -> triggers. Search the field which will trigger the sheet under Field event Triggers, and use an expression like this:

=if(match(YEAR, 2013), 'SH02')

where YEAR is the field which the selection is apllied to, and '2013' the Value you want to apply the action to and SH02 the sheet ID which should be activated.

Best Regards

Stefan

[abhaysingh]

I have town values like japur, rajasthan etc...and it comes under the field OfficerTown

it is giving error pls help

[Anonymous]

Hi,

use this expression in the activate sheet action (Layout)  you add to the field trigger:

=if(match(OfficerTown, 'japur', 'rajasthan'), 'YOURSHEETID')

if this doen't help, please post a sample qvw.

Best regards

Stefan

[abhaysingh]

there are so many values in officer not only two

[abhaysingh]

There are so many values in officerTown field I want to do it for all

[Anonymous]

Hi,

ah ok. Then simply type the sheetId of the sheet you want to activate instead of the expression. Thought you only wanted the sheet for specific Values.

Best

Stefan

[abhaysingh]

not working

[#9]

Hi Abhay,

In the field triggers select the field on which you want to add the trigger.

click on "On Select" add actions --> Layout-->Activate Sheet give the sheetID which you want to activate.

Similarly do this on "On change" as well.

Check out the attached image.