create string from possible values in a field

[#1]

Hi All

I have a table with names, email addresses, statuses etc. of all my users, some of them are active some are inactive. What I want is to create a button that for a selection of users e.g. those with staus=active will create a draft email in my outlook and paste all the email addresses from the table. I have already added ';' at the end of each address so it would separate one from another. It does work if i choose just one address with ='maito:' [field name]

I assume I have to create a sting of values from the possible email adresses to then put it into [field name] place.

Has anyone tried it before? Any advice?

Cheers for your help. Tom

[#2 · Accepted solution]

The Concat() function gives possible values of a field.

Concat(Email, ';')

You can also add Set Analysis:

Concat({<Status={'Active'}>} Email, ';')

[#3]

Perfect.

That's all i wanted.

Cheers

Tom

[#4]

Dear Miller,

I would like to obtein the followin result from a concat function:

'field(i)','field(i+1)','field(i+2)',...,'field(n)'

ex:

'1/1/8','2/6/90','4/14/45'

i'm not able to concatenate the:   '  

i need this solution, because i'm tring to update in a dinamic way the result of a match function, without changing the script (but only a variable in an input box and adding a line in an excel document)

I wanted to explain this becase if you have another way of thinking should be great!

Thank You !

Smirik