Need Suggestion for Selections

[aveeeeeee7en]

Hi Community

I am Stuck at one place.

I Need different Default Selections on every Sheet even in case the user uses Clear Option, it should show Default Selections but it should be different on each Sheet.

I have 3 Sheets in my Application

Eg.

Sheet 1  :  To show 2nd Quarter Default Selection even  if the user uses Clear Option

Sheet 2  :  To show  2nd Quarter and 1 Status coming from List Box as Default Selection. Even on Clear it should work

Sheet 3  :  To Show Max Year

I have used many Alternatives:

Lets Start with 1st one:

S.No.	Sheet Name	Triggers
1	Sheet 1	1) Clear All	2) Select in Field
	Using 2 Triggers		Field Name: Quarter  & Search String: Qtr2
2	Sheet 2	1) Clear All	2) Select in Field	3) Select in Field
	Using 3 Triggers		Field Name: Quarter  & Search String: Qtr2	Field Name: Status  & Search String: Active
3	Sheet 3	1) Clear All	2) Select in Field
	Using 2 Triggers		Field Name: Year  & Search String: =Max(Year)

2nd Alternative I have used "Set Clear State"

It is working on All Sheets .

Since when i used Clear, it is showing same default selection for every sheet.

But I want different Default Selections on every Sheet.

So, Can't use Clear Set State.

Any Suggestions?

Regards

Aviral Nag

[#2]

Hey Nag,

Just a suggestion. Not sure if it fully fits your needs though/or if you have already tried it.

Why don't you clear all when leaving a sheet and when entering a new sheet make your default selection.

So all this to be done in Sheet Properties > Triggers,

Sheet1     when leaving Clear All

Sheet 2    when entering make your default selection

Similarly,

For all the other sheets.

Hope it helps.

Thanks

AJ

[aveeeeeee7en]

Hey Ajay

Thanks for the Logic. It's working.

But I have one Question???

After Applying Triggers on Leave Sheet - Clear All and other Triggers on Activate Sheet, when I am switching to other Sheet, they are working Perfectly as per the Triggers but my area of concern is that I want to show this value even on clear option present in the window above.

Do you have some ideas???

Regards

Aviral Nag

[#4]

Hi Aviral,

Setting clear state would be one option but as you mentioned it won't work if you need different selections on different sheets. In this case, you might consider creating a clear button on every sheet and then giving specific triggers on that button.

Might not be what you require exactly but just an alternative since clear state can't be set separately for every sheet.

Hope this helps!