in

InfoPath Dev

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

Last post 09-30-2008 07:42 PM by proudestmonkey. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 09-29-2008 07:40 PM

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

     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!

  • 09-30-2008 07:08 AM In reply to

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

    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!

    Hilary Stoupa / InfoPath Developer
    Qdabra® Software / Streamline data gathering to turn process into knowledge
  • 09-30-2008 07:42 PM In reply to

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

     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!

Page 1 of 1 (3 items)
Copyright © 2003-2007 Qdabra Software. All rights reserved.
View our Terms of Use.