Sheet Trigers

[#1]

I have a filter/ Multibox called "Subscriber Type" having following values:

Digital

Digital + Print

Non Subscriber

Now I am trying to create an action/triger that when I open the sheet that filter should by default select "Digital" every time.

To get this I am doing followings:

Sheet properties >> Trigers >> OnActiviteSheet Add Actions >> Select in Field >> Select Field is  "= [Subscriber Type]" and String is "= 'Digital'

but it is not working and not selecting Digital in the filter.

Am I doing something wrong here?

Plesae advise?

Thanks,

TA

[MayilVahanan]

hi

Try like this

Setting->Document properties -> trigger -> onopen -> Action type:selection ->selection in field

[#3]

This is what I am doing.

Can you write how to specify the field name and Search String?

[MayilVahanan]

Hi

Do like this

Selection in field :[Subscriber Type]

Search string: = 'Digital'

[#5]

This is what I am using but not getting the desired result.

[MayilVahanan]

Hi

can you post a sample file?

[#7]

remove the = from the field name.

[#8]

I have attached a sample file. Please create a by default filter from multibox which should be pre selected automatically when app is launched. Thanks,

TA

[MayilVahanan · Accepted solution]

HI

Please check the attached file now..

Hope that helps

[#10]

That was perfect. Thanks a lot.

Here is one more questions though. Is it possible to define which sheet should open first by default when a qv document is open every time?

If yes how can I do that?

Thanks,

TA