Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I hav ebeen asked to list only two selection out of several in a list box, has anyone done this ie if selection a,b,c,d,e is available, I only want to show a,c and d?
Has anyone done this if yes please can you guide me on how.
List box-->Field-->Expression
=if(match(Staff,'A','B','C'),Staff)
Create a list box by using expression
IF(Match(YourFieldName,'a','c','d'),YourFieldName)
Mina,
See attachment and follow the concept in your case.
Thanks,
AS
might be i'm wrong here,are u looking for alternatives in list box instituted of showing all?
exmple: at present ur having: a,b,c,d,e
expecting:a,c,e?
Create List box
and in expression add below to see A,C and D .
=if(match([Field] 'A','C','D'),[Field])
Thanks works perfect