Concatenate values from field in found set

[Jana]

Hello, I'd like to concatenate the contents of a field from all the records in a found set so I can use the concatenated data as the body content for an automated email.

I'm unsure of where to start for creating the calculation in the concatenated field. I can apply it to the email once I've got the calculation/script but need some direction on the creating the concatenation. Any ideas?

Thanks

[mr_vodka]

One way is to loop through the found set and set a global field with the content.

Set field [gConcat; "" ]

Go to Record [First]

Loop

Set Field [gConcat; gConcat & yourField]

Go to Record [Next; Exit after last]

End Loop

[Jana]

Thanks. I've tried to begin with this but it is not accepting:

Set Field (GCI_Members::gConcat;"")

It is asking for an operator. What is the "" indicating? I set gConcat at a text with a calculated result field type with Global storage. Does it need to be a calculation field?

[mr_vodka]

Set Field [ GCI_Members::gConcat; "" ]

"" indicates null. It is to clear out the field. So in the calculated result area, type "". Yes use global storage text field.

[Jana]

:thankyou:

Like a charm!