Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
May be, you would also like to have a look on this very useful post by Barry Harmsen.
Regards,
Abhijit
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.