Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Thanks Miguel...was actually just about to close this post cause I found a discussion you replied to with that function...worked like a charm... Thanks a lot mate for the detailed reply and answer. Full points