activation of sheet

[#1]

Hi all,

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

[its_anandrjs]

Means you want to go to perticular sheet or unhide that sheet

Thanks & Regards

[#3]

Hi,

PFA. You have to add trigger/action on that field.

I have assumed that you need to activate the sheet "Sheet 1" on the basis of selection in the field "graph_type"
Hope this helps!

[its_anandrjs]

Hi,

In sheet properties -> General -> show sheet option -> in conditional option ->

copy a code like =GetSelectedCount(ListboxField)

Hope this helps

Thanks & Regards

[sushil353]

hi,

Goto Sheet property> General > show conditional

=if(getfieldselections(graph_type)='netdelay',1,0)

HTH

Sushil

[#6]

Hi Anand,

I want to navigate to particular sheet

[PrashantSangle]

Hi,

In your example you can add Three Buttons or Text Boxes ,

Give Proper Name,

then Go to Property window->Action Tab->Add->Layout->ActivateSheet->give Sheet Id,

Regards,

[#8]

Hi Shymal,

  I need  to navigate to sheet1  when the graphtype=penality

[sushil353]

You can add listbox to every sheet and add condition to specific sheet .. for example if you have say 3 sheet and

your data in listbox is netdelay,payout and penality..

then for sheet 1 put condition = =if(getfieldselections(graph_type)='netdelay',1,0)

for sheet 2 put condition = =if(getfieldselections(graph_type)='payout ',1,0)

for sheet 3 put condition = =if(getfieldselections(graph_type)='penality',1,0)

HTH

Sushil

[#10]

Hi Max,

  But the sheet should activate on the basis of selection I.e  if the graphtype=penality then sheet 1 should activate

(not display or hiding)