Particular field values retrive at a time

[Surya]

Hi,

I Have an a field,on that field i have 1000 records for example 1-1000.

when i want multiple values to select at a time just drag and drop and randomly selected values purpose we need to check one by one.

but my user want hey need some input box on that he just pasted the values and automatically retrive all matching values.

i.e., 1,4,13,67,234,655,6789

these values pasted into particular input box then he retrive all the related data.

Thanks. 

[arpitkharkia]

if they search in the following way,

(1) | (4) | (13) | (67) | (234) | (655) | (6789)

in the search option of a list box.

I hope this helps and makes sense.

[jyothish8807 · Accepted solution]

Hi Prakash,

Check the attached, hope this is what you want:

I just created Select in filed trigger for variable vSearch:

[Surya]

Thank you so much Broo

[Surya]

Bro.,

Thank you for that.but as my requirement we need directly copy from excel into our application.please give me some solution for that also

[jyothish8807]

You can always copy paste data from excel as well, Just make sure the data in this format:

1,3,4,5

else let me know how it will be copied.

[Surya]

We are giving detailed charts all the cases for users.

users directly taken send to excel or those are already having all the field values.

so now we need to copy data from excel and directly pasted in a input box.

Thanks 

SP

[jyothish8807]

So you are going to copy the text at row level ? Like below :

1

2

3

4

[jyothish8807 · Accepted solution]

try replacing the trigger with the below:

='('&Replace(trim(vSearch),' ','|')&')'