dynamic input box

[#1]

i would like to display the distinct values of a specific field in an input box.

how do i declare the variable?

Thanks,

Lambert.

[#2]

Do you want all values, selected values, possible values?

For all set a variable to:

=Concat({1} FIELD)

For selected:

=GetFieldSelections(FIELD)

Possible should just be:

=Concat(FIELD)

[#3]

i would like all distinct values in a dropdown list input box.

[#4]

Sorry, I saw variables and kind of missed the input box part. It doesn't seem like a variable works on a pre-defined list in an input box. The format is 'Val';'Val2';Val3'.

To get that in a variable it would be:

=Chr(39) & Concat({1} distinct FIELD, Chr(39) & ';' & Chr(39)) & Chr(39)

Unfortunately when that is used as the PreDefined list in an input box, it doesn't seem to work. Even though manually entering the same result would. I tried a few different things, like directly entering the expression and using a variable as =vVar, $(=vVar), $(vVar), etc. I don't use Input Boxes very often, so I'm not sure if that is possible. If it is, the above expression should work to get the values set up correctly.

EDIT: Numbers seem to work just fine, but don't require the quotes. For a numeric field:

Concat({1} distinct FIELD, ',')

That should show all values for the field and work as the Pre Defined list.

[#5]

Thanks for the reply, i will see what I can figure out.

[#6]

yeah, that worked, thanks a million!

[#7]

Thanks,

this works for me as well.

K.