Data Connections

Re: Generating an email recipients list from selected checkboxes in a list.

proudestmonkey — Wed, 01 Oct 2008 02:42:23 GMT

Hi Hilary,

Thanks for that read. I'll have to give it a go but I'll need to extend it to be looking into the external datasource as the @emailaddress property isn't displayed/stored in the Multi-Selection Listbox.

Cheers!

Re: Generating an email recipients list from selected checkboxes in a list.

Hilary Stoupa — Tue, 30 Sep 2008 14:08:12 GMT

Check out this post, about using Eval and Concat to create a string from a repeating group. Let me know if you need help with this, and welcome to the forum!

Generating an email recipients list from selected checkboxes in a list.

proudestmonkey — Tue, 30 Sep 2008 02:40:34 GMT

Hi all,

I have a connundrum trying to set an Expression Box to a concatenated string based on user selections from a Multiple-Selection List Box. I'll try my best to describe the issue as follows:

I have an external data source that is populated when the form loads. It's structure is:
<myFields>
<dataFields>
<d:UserGroups @UserGroupID="int" @Description="string" @ManagersEmail="string">

This structure is used to populate a Multiple-Selection List Box using the @UserGroupID for the checkbox value and the @Description for the checkbox text. This is working fine... happy days! :)

So, beneath this I want to have an Expression Box that includes all the "checked" checkboxes from the above Multi-Selection List Box, adding the @ManagersEmail + ";". So when a user selects item 1 from the list, the corresponding email address stored in the @ManagersEmail is concatenated to the expression box text, thus generating an email recipients list.

Hopefully that makes a bit of sense.

Thanks in advance!