i need to show selections when i select sheet?

[#1]

Hi All,

I have 2 sheets created in qv app.

In each sheet i have created common filter as Year.it contains 2011,2012,2013,2014.

if i open sheet2 year show default selection as 2014 and if i go back to first sheet needt to show no selections on year

[vikasmahajan]

you can use Sheet Properties -> Triggers -> Select in Field -> give field name (YEAR) ->  in search values 2013

This way you can set years to each sheet which ever you want.

Vikas

[its_anandrjs · Accepted solution]

Use Sheet triggers for this Settings >> Sheet Properties >> Add actions >> On Leave Sheets >> Add >> Clear All

Regards

Anand

[#4]

you can achieve this by creating sheet level trigger.

[MayilVahanan]

Hi

Try with sheet trigger

In sheet 2, add the OnActivateSheet trigger for the Year filter with 2014 values by using the Select in Field actions.

In sheet 1, add the OnActivateSheet trigger for the Year filter by using the Clear field actions.

or

In sheet 2, add the OnLeaveSheet trigger for the Year filter by using the Clear field actions.

[suresh_rawat]

Hi,

For Sheet2 - Go to Properties of Sheet -> Trigger -> On Activate Sheet - > Edit Option - > Click ADD - > Select In Field - > Field Name (As per the your Field) and Search String (year(Today()).

For the same i have attached a image

For Sheet1 -  to Properties of Sheet -> Trigger -> On Activate Sheet - > Edit Option - > Click ADD -> Clear All.

For the same i have attached a image

Regards

Suresh

[ashfaq_haseeb]

Like this

Regards

ASHFAQ

[Anonymous]

Add triggers as below.

BR,

Chinna