4 Replies Latest reply on Jul 23, 2014 12:53 PM by Matty_1

    Filter Values - What am I missing?

    Matty_1

      Title

      Filter Values - What am I missing?

      Post

           I have a field called ProgressType that contains a check box with the options: Pre-Load, Delivery, Partial-Unload and Unload.  I would like to create another field that displays abbreviated versions of each so if all where selected the field would show exactly  "PL D PU U" and I can't seem to get it working if more then one item is selected.
            
           Stumped :( Could someone please help me out?
            
           Thank you.

        • 1. Re: Filter Values - What am I missing?
          philmodjunk

               By "exactly", I  take it that you want those letters separated by spaces, not returns, if all check boxes are selected.

               One option:

               Substitute (
               List (
               If ( Not IsEmpty ( FilterValues ( CheckboxField ; "Pre-Load" ) ) ; "PL" ) ;
               If ( Not IsEmpty ( FilterValues ( CheckboxField ;"Delievery" ) ) ; "D" ) ;
               If ( Not IsEmpty ( FilterValues ( CheckboxField ; "Partial-Unload" ) ) ; "PU" ) ;
               If ( Not IsEmpty ( FilterValues ( CheckboxField ; "Unload" ) ) ; "U" )
               ) // List
               ¶ ; " " )

          • 2. Re: Filter Values - What am I missing?
            Matty_1

                 Thank you Phil.  I keep getting a kick back saying I have too few parameters and the troubleshooting side of my brain is somewhere else in the world.

            • 3. Re: Filter Values - What am I missing?
              philmodjunk

                   There's a missing semi-colon.

                   Substitute (
                   List (
                   If ( Not IsEmpty ( FilterValues ( CheckboxField ; "Pre-Load" ) ) ; "PL" ) ;
                   If ( Not IsEmpty ( FilterValues ( CheckboxField ;"Delievery" ) ) ; "D" ) ;
                   If ( Not IsEmpty ( FilterValues ( CheckboxField ; "Partial-Unload" ) ) ; "PU" ) ;
                   If ( Not IsEmpty ( FilterValues ( CheckboxField ; "Unload" ) ) ; "U" )
                   ) // List
              ; ¶ ; " " )

              • 4. Re: Filter Values - What am I missing?
                Matty_1

                     Beauty, worked.  Thank you very much!