boxes and lists

[#1]

please help

I create a list, select the list type field.

in the field there are several types (type 1, type 2, type 3).

I need to be seen in the list of type1 and type2 only.

[rustyfishbones · Accepted solution]

Create a Calculated Expression in the List Box and say

IF(typ <> 'typ 3', typ)

[alexandros17]

in that object instead of selecting a field select expression and write :

if(typ <> 'type1' or typ <> 'type2', '', typ)

hope it helps

[rustyfishbones]

you can create the calculated expression by selecting Expression at the bottom of the list

[Anonymous]

Hi,

In your list box settings, tab General, choose the field expression and write this expression:

=if(typ<>'typ 3', typ)

Hope this helps,

Quentin