1 Reply Latest reply: May 20, 2015 10:58 AM by Jonathan Poole RSS

    List Box Properties query

    Stephen Verso

      Hi All,

       

      If I have a list of activities in a List box, is it possible to add an expression or definition to group some activities together?

       

      For example my current list box is:

      Event - rock climbing                                         

      Event - hill climbing                                           

      Event - swimming

      Training - presentation

      Training - one to one

       

      Outcome I want is:

      Event

      Training

       

      Many thanks.

        • Re: List Box Properties query
          Jonathan Poole

          You can alter the list box to show the results of an expression rather than a field with this:

          Untitled.png

           

          Then bucket the values with an expression . Lots of possibilities. Here is one with wildcard matching and i threw in an 'other' category if you get unexpected values.

           

          if(  wildmatch([FieldName],'Event*'),'Event', if( wildmatch([FieldName],'Training*','Training','Other'))