Add to field for every record in found set...

[deego55]

This is driving me nuts...

I need to create a field that will take the values of a NOTES field from every record in the found set and combine them into one field. I need this combined field to be the body of an email. As of now I can only figure out how to set the message to be the NOTES field of the current record.

For instance, if I have 10 records and they all have something in the notes field, I need to create a field that would have Notes1</p>Notes2</p>Notes3</p>etc...

Aside...why doesn't the Send Mail function have an option for "Get values from every record" for the Message section? That's exactly what I would need.

Can this be done?

[Sxeptomaniac]

If you are using a script for the send mail function, why not use a looped script to make a global your message body as part of that?

Just create a global for your message body (message_Body), and add script steps something like this:

Go to Record/Request/Page [First]

Loop

Set Field [message_body; message_body & "

[deego55]

ah, that worked beautifully! thank you! i had tried this before but forgot to set the field as "message_body &"

thanks again!

[-Queue-]

Note that you can use a single

[Sxeptomaniac]

Thanks Queue, I guess I missed seeing that change.

It will still probably take me quite a while to get over that habit, though.