Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Use Sheet triggers for this Settings >> Sheet Properties >> Add actions >> On Leave Sheets >> Add >> Clear All
Regards
Anand
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
Use Sheet triggers for this Settings >> Sheet Properties >> Add actions >> On Leave Sheets >> Add >> Clear All
Regards
Anand
you can achieve this by creating sheet level trigger.
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.
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
Like this
Regards
ASHFAQ
Add triggers as below.
BR,
Chinna