Trigger on Value

[nihhalmca]

Hi Experts,

Currently i am facing one query i.e

I need to give trigger on value for example

Dim: Product

           a

           b

           c

           d

But i need to give trigger only on 'a' and 'b'.(if i click 'a' i want to display another sheet)

I dont want to create trigger on 'c' and 'd'.

Please share your knowledge if you know

Thanks in Advance,

Nihhal.

[tresesco]

You have to make your sheet visibility conditional. Go to your sheet which one is to be made visible, right click on a blank space of the sheet->properties>General-> Show Sheet->Conditional

Now put there the condition - > Product= 'a' or Product = 'b'

[#3]

Hi,

PFA application

Regards,
Amay

[nihhalmca]

Hi tresesco, sorry for late response

I tried it just it display sheet not activate sheet i am expecting if i click product 'a', sheet will be activated that sheet has related data and i am expecting field event trigger is it posible

Regards

Nihhal

[nihhalmca]

Hi Amay Patil, Sorry for the late response

I have seen your application, it shows sheet not activated i am expecting if i click product 'a' sheet will be activated that sheet has related data and i am expecting field event trigger is it posible

Regards

Nihhal.

[#6]

Hi Nihhal,

PFA.

I have modified the file provide by Amay Patil.

Hope it helps!

Edit: I have done it for one value 'A', you can use the similar trigger with if condition for 'B' as well.

Something like :

=If(Field = 'A','SH02',
If(Field = 'A','SH03'
))

Also, give this trigger OnSelect and OnChange both.

[spsrk_84 · Accepted solution]

Hi Nihhal,

Create an Field event trigger on both Select & Change as well .i.e Add Activate Sheet trigger using the below condition like for ex

IF (GETFIELDSELECTIONs(PRODUCT)='A','SH02','SH01')

Thanks,

Shiva

[nihhalmca]

Thank You Shivaram Krishna.

NiHhal.