2 Replies Latest reply: Dec 5, 2011 8:40 AM by Byron Van Wyk RSS

    Input Box - Using a loaded field for values

    Byron Van Wyk

      Hi All,

       

      I want to create a input box that has a predefined drop-down list of values from a field... So that field has a distinct list...i want that list to appear in an input box for a user to select from

       

      In the 'constraints' tab for an input box, I would like to enter "=FieldName1" in the predefined listed values section. Is it possible at all to do this

       

       

      Thanks,
      Byron

        • Re: Input Box - Using a loaded field for values
          Miguel Angel Baeyens de Arce

          Hi Byron,

           

          You're almost there. Go to the inputbox properties, Constraints, Listed Values, but set instead:

           

          =Concat(DISTINCT Field, ',')
          

           

          That will return a comma separated list of all distinct values for field "Field". Note that the comma may not be your list separator, to know which one will work if that doesn't, use Ctrl + Shift + Q and search for "ListSep", and you will see something like this in the dialog that shows up:

           

          ListSep                            Doc=";"(3B)       Sys=";"(3B)
          

           

          The "Doc" is the one that matters, so in my case, the separator in that Concat() function should be ";" instead of the comma. In this regard, check (and vote if you feel like) this idea so you as developer can choose the list separator instead of using the regional settings.

           

          Anyway, once you get this working, make sure you check "Predefined Values in Drop Down" in the "Value List" section of the Constraints tab in the inputbox properties.

           

          Hope that helps.

           

          Miguel