Get Value for input box from drop down list?

[picturebox]

Hi,

I'd like to offer the user a range of values from an existing field to "pick list" from for the input box. I can't seem to be able to make it work... what is the syntax I require? The field name is CWNumber and has 106 values 201033, 201032, 201031, ...., 200815. This example is based on numerical calendar weeks...

Thanks,

Petra

[johnw]

Input box properties, Constraints, Value List, select "Predefined Values in Drop-Down". Under Predefined Values, checkmark Number Series, from 201033 to 200815, step -1.

[rwunderlich · Accepted solution]

On InputBox properties, Constaints, PreDefined Values, check "Listed Values" and for the expression use:

=concat(TOTAL DISTINCT CWNumber',')

-Rob

[picturebox]

Thanks John,

this is not a series, so cannot use -1 backstep.

Petra

[picturebox]

Thanks Rob,

this works perfectly once I got the proper syntax for my region, i.e. semi colon instead of comma. But what happens if I move the app onto a pc with comma separator? (local set Germany == 😉

Regards,

Petra

[tanelry]

Based on my test the function accepts document-based ListSep, not system-based one. So no worries.

[picturebox]

thanks!