1 Reply Latest reply on Oct 31, 2011 4:54 PM by philmodjunk

    Make a Conditional Value List Unconditional if no selection

    crtopher

      Title

      Make a Conditional Value List Unconditional if no selection

      Post

      Currently if I don't select anything in the field that the conditional value list is flitered by, no values appear in the dropdown field. I would like it that if no selection is made, all the available records in the value list appear (ie sort of like selecting ALL conditions/categories rather than one)

      Is this possible? Advisable?

      CHeers,

      Chris R

        • 1. Re: Make a Conditional Value List Unconditional if no selection
          philmodjunk

          It's possible, but takes a bit of sneakiness to get it to work.

          Define a calculation field such as this to use in place of the first value list field:

          If ( IsEmpty ( FirstValueListField ) ; "**All**" ; FirstValueListField )

          Clear the Do not evaluate if all referenced fields are empty.

          Now define a new calculation in the table serving as the source of values for your conditional value list:

          List ( "**All** ; MatchFieldInCurrentRelationship )

          Now use these two fields in place of your current relationship and an empty field will match to all values in the value list.