Is it possible to copy past a list of values into a selection box?

[lmonincx]

Hi,

Is there a way to copy a list of values, i.e. 1234,5678,9100 into the selection "DeptId", in order to select those values with only a paste action, without selecting them manualy one by one?

Hope this is possible, would make live much easier

Kind regards,

Linda

[flipside]

Hi Linda,

Create an inputbox so you can paste the comma-separated list into a variable. Then create an action linked to e.g. a button to select in your field this formula ...

='(' & Replace('$(vList)',',','|') & ')'

... where vList is your variable. All it does is replace the commas with pipe symbols and wrap brackets around the list.

flipside

[AbhijitBansode]

May be, you would also like to have a look on this very useful post by Barry Harmsen.

Regards,

Abhijit

[swuehl]

If your numbers are all of the same length, try creating your list of values space separated

1234 5678 9100

then copy the line into the search bar of your list box. Press Enter.