Set trigger to select multiple values in a field from a variable

[#1]

Hi Guys,

I have created an input box where a user can paste multiple values of a field. So a user will post mutiple values for a field in the input box and I am storing that in a varibale. I am not sure how can I set up a trigger that would take the values from the variable and select a field with those multiple values.

I know how to set up a trigger if there is only one value but for mutiple values its not working.

Can anyone please suggest anything?

Thank you.

[diegofcaivano]

Hi. You need to use pipes to separate values and double quotes to define each value.

Set an action, and use this as field value:

("VALUE 1"|"VALUE 2")

Regards.

[MayilVahanan]

Hi

Are you expect like this attached file?

[#4]

Thanks for your reply everyone.

So the variable that I have set up will contain multiple values for a field seperated by comma. Eg.

ABC, EFF, (123FED), .....

So all these values are stored in one variable. But when I am setting a trigger action, its not working on these multiple values. I am not sure how can I use Pipe in this.

Gysbert - you said seperated by Pipe and enclosed in parenthesis. Can you give an example? Are you trying to say that values seperated by comma is not going to work?

Thanks again. I really appreciate all your inputs.

[#5]

Hi Mayil, yes I am expecting something like this. But my data in not in num format, its a char data type. Thanks!

[MayilVahanan · Accepted solution]

hi

PFA

[#7]

Thanks everyone for replying. It worked.

[adriano_fornoni]

Grazie, il suggerimento è stato sfruttato con successo.