How to select more than 1 value in 2 fields with an action

[slondono]

Hi guys

Im trying to select more than 1 field value into other field when i push a button.

I´ve tried:

- GetFieldSelection(Oficina)

- Concat(distinct Oficina,',')

- Oficina

It works with "=Oficina" but just for 1 value, not for two or more.

So...when i push "Consultar" i need in the field 'Oficina_sentry' the same selections that there are in the field  'Oficina'

What expression should i use in my action?

Thanks to all

[sunny_talwar]

Try this:

='(' & Concat(DISTINCT Chr(34) & Oficina & Chr(34),'|') & ')'

or

='(" ' & GetFieldSelection(Oficina, ' "|" ', 100000) & ' ")'

Double quotes are in red

[bertinabel · Accepted solution]

Sebastian,

     Pueba con lo siguiente en tu accion, ya lo probe y funciona:

='(' & Concat(TU_CAMPO,'|') & ')'

Saludos

[slondono]

Excelente, funcionó perfecto.

Muchas gracias

[sunny_talwar]

Just a quick note: this will only work if you don't have spaces in your field value. If there are space, this will fall through. In case it does, just use one of the two expressions I provided which will take care of any spaces in the field value

Best,

Sunny

[slondono]

You´re absolutely right.

Works very good with ='(' & Concat(chr(34)&FIELD&chr(34),'|') & ')'

[sunny_talwar]

Yes you are right, I did not need double quotes with the parenthesis because I am wrapping my fields around with the double quotes.

I am glad you were able to figure this out.

Best,

Sunny