Input Box Value List

[#1]

Hi,

Can any one tried showing a drop down list of values in Input Box?

The values should come from one field like (Country, Name etc..)

eg: I want to show all countries in my 'country' field in a input box dropdown list( to ensure no typo errors )

Is it possible?

In Input Box properties, Constraints Tab->Listed Values->

=Concat(Distinct Country,';')

I used above expression and it showing in single row, but need it in multiple rows...

Help me..

[Anonymous]

HI

Try this

=ValueList($(=concat({1} distinct chr(39) & Col1 & Chr(39),',')),$(=concat({1} distinct chr(39) & Col2 & Chr(39),',')),$(=concat({1} distinct chr(39) & Col3 & Chr(39),',')))

where col1,col2,col3 are column names

Regards

Harsha

[#3]

It's not working Harha, but thank you for responding..

[#4]

Hi ,

the below expression is working in my senario.

=Concat({1} distinct Country,',')

Thank you.