Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi friends,
I having two sheets , in each sheet it is having clear buttons ok
In the first sheet , i have used the activation of sheet object ,then it going fine.
when i am clicking the clear buttons, it should clear the current sheet and the sheet should be the current sheet , it should not go to another sheet,(i.e it should clear all the selection in the sheet and it should not go to another Sheet)
I am trying this to do , but when i was trying to clearing the sheet it is clearing the selection and it is going to another page ,
So i want to restrict that , it should not go to another page.
Can any one suggest me solutions freinds,...
Thanks
Kumar
Yes, the same expression should work. That is =If(GetSelectedCount(Date1),'SH02')
Write this expression on Triggers of "On Any Select"->Activate Sheet.
Kindly Find the attached Sample.It's Working.
Hi Praveen,
I guess you are using any trigger which is taking you to another page, check if any trigger is there or not. If yes then delete the trigger. When you clear it is supposed to be on the current page.
Regards
KC
Hi Kumar,
Have you got any sheet activation triggers on your clears? Or any conditions on shows?
If you have different fields/filters on each sheet you could clear just those particular field selections with a clear button, otherwise you'd need an alternate state on each sheet to ensure selections are only cleared on one or the other.
It shouldn't switch sheets unless a condition forces it to.
HI Jyothish,
Yes i am using the trigger , if i remove the trigger then how can i go to another page .
my requirement is if,i select any column in the first sheet it should navigate to another sheet.
So that's i am using the trigger.
Is their any other way to navigate page with out the trigger.
Thanks
Kumar
Hi Aarogn,
Thanks for reply,
Yes i am having the sheet activation triggers.
Can you give me small example please..
Thanks
Kumar
Can you upload an example app?
Where is your sheet activation trigger? Or what determines which sheet you go to?
You can create a textbox/button that has a trigger attached that will clear a particular field or set of fields, unless your trigger is determined by a particular field that you want to clear!
Separately if you want your selections to only affect a particular sheet, have a look at alternate states (settings > document properties > alternate states) as a way to ensure it only affects a particular sheet.
Hi,
In your case the clear all button is linked with triggers, why don't you clear the triggers and use a different button to move to next page, it is inbuilt with in QV.
Regards
KC
Hi Kumar,
Can you post sample file?
And list all the actions you want to perform in order you want it executed
Many thanks
Hi ALL,
Here i am attaching sample qvw.
In this ,first sheet if i select any row or column then it go to the next sheet , is that ok but whent i do clear the selection by using the button then also it is going to another sheet.
When i do the clear selection , It should not go to another sheet
Is that am i wrong?
Thanks
Kumar
When you are activating sheet on field selection, write expression like:
=If(GetSelectedCount(Date1),'SH02')
Similarly for other fields.