Limit selection possibilities in selection box

[#1]

Hi!

I have 5 different factories but I only want 4 of them to be visible in my selection box. Is there any way of limiting the selections to be visible in my selection box?

Thanks!

[CELAMBARASAN]

Hi,

     Yes its possible.Try with this

     =if(WildMatch(Factory,'Factory1','Factory2','Factory3','Factory4'),Factory)

     as a expression in listbox

Hope it helps

Celambarasan

[swuehl]

Or just exclude the one you don't want to show:

=if(Factory <> 'FactoryNotToShowName', Factory)

as the list box field expression (open the drop down field list in general tab, select <Expression> from the very end).

[jagan]

Hi,

This is the better option to exclude one Factory

=if(Factory <> 'FactoryNotToShowName', Factory)

Regards,

Jagan.

[#5]

Thanks!!

[#6]

Thanks a lot!!

[CELAMBARASAN]

Hi,    

     Close this discussion by marking as correct answer.

Celambarasan

[Anonymous]

How about more than one exclusion?

[#9]

In order to handle more than one exclusion you could just do =if(Factory <> 'FactoryNotToShowName' AND Factory <> 'FactoryNotToShowName2', Factory) ... I think in set analysis something like =only({<Factory -= {'FactoryNotToShowName', 'FactoryNotToShowName2'}>}Factory) would work as well.

[Anonymous]

Thank you Christian, a great help.