1 Reply Latest reply on Jul 18, 2013 8:24 AM by philmodjunk

    Conditional value list omitting some result, need help

    TaylorJansen

      Title

      Conditional value list omitting some result, need help

      Post

           I may have a conditional value list with the following result:

           Field A | Field B | Field C

           1    |  XXX  |   20

           2    |  XXX   |  30 

           3    |  YYY   |  40

            

           The value list display Field B in 1st column & Field C in 2nd column, but in the drop down list only 2 choices are shown:

           XXX 20

           YYY 40

            

           Omitting one record. I think it is due to same value XXX.

            

           So how to make the value list shows all 3 options in this case?

        • 1. Re: Conditional value list omitting some result, need help
          philmodjunk

               Optiion 1:

               Sort your value list on Field c

               Option 2:
               Construct a calculation field or text field with an auto-entered calculation that combines FIelds B and C in the same field. Use that for field two and hide field 1.

               Option 3:

               Don't use a value list. Use some other method, such as a portal that lists the values with a button for selecting one.