activation of sheet

[#1]

Hi all,

I want to activate a sheet on the basis of  field selections PFA

[its_anandrjs]

Ok means if you select any thing in the list box then open perticular sheet if so then you have to add field event trigger like

Go to settings -. Document properties -> Triggers -> Field event trigger -> Onselect -> Add Action -> Activate sheet and add sheet name there.

Hope this helps

[#3]

Hi sushil,

  Here i am asking not to show or hide, i want to activate that sheet on basis of field selection

hope u got my question

[#4]

So, you mean you want to show sheet 1 only when "penality" is selected in graph_type and hide it otherwise?

If so, the you can make sheet 1 conditional by navigation to Properties--Genaral tab.

Click on Conditional and write the following expression:

=GetFieldSelections(graph_type) = 'penality'

This will show sheet 1 but won't navigate to it. To navigate to sheet 1, use field event triggers.

PFA.

[sushil353]

ok. for that

Go to settings -. Document properties -> Triggers -> Field event trigger -> Onselect -> Add Action -> Activate sheet

and add condition as specified below

=if(GetFieldSelections(graph_type)='netdelay','SH02')

HTH

Sushil

[#6]

Hi shymal,

  Here i have two conditions if the selection is 'penality' then sheet 1 should activate and if the selection is

delay then sheet 2 should activate

[#7 · Accepted solution]

Then just add the similar condition on Sheet 2 :

=GetFieldSelections(graph_type) = 'netdelay'

And, edit the Field event trigger as:

=If(graph_type = 'penality','SH02',

If(graph_type = 'netdelay','SH03'))

PFA, the modified file.