Conditional mail addresses

[Larry W. Virden]

In an InfoPath form that I am beginning to design, the user clicks
some combination of checkboxes to indicate the type of information
required. The requirement is there are one or more email addresses
associated with each checkbox.

The intent is not to send individual emails to each set, but to
accumulate the email addresses and then send one message requesting
information to the group.

It is not clear to me how to go about accomplishing this. There are
too many combinations to create a data connection for each one (25 !
has 26 digits in it ...).

So, what kinds of techniques have developers designed for this type of
situation?

Thank you so much for your ideas.

 

[Perplexed Access Designer]

This can be accomplished through Submit Rules
Step 1: For each control that will determine the end email address create a
data connection.
Step 2: In the button properties select Submit, in the Submit Options Menu
choose custom code
Step 3: Create/Add conditional rules on the use of each of the emails based
on the values of the fields.

Example: The form asks the user if they would like Cheese, Pickles and
Tomatoes each indicated by a check box. Data connection 1 would say if Cheese
Checkbox is true then use this data connection rule to submit to X email
address. Repeat as necessary with additional rules for Pickles and Tomatoes.

 

[Larry W. Virden]

In an InfoPath form that I am beginning to design, the user clicks
some combination of checkboxes to indicate the type of information
required. The requirement is there are one or more email addresses
associated with each checkbox.

The solution I ended up with here was a bit complex. I created a
sharepoint list that contained an area identifier along with 4 fields
for individual peoples (people picker fields). I had to choose to
display the domain\address format to display the names.

Then, in infopath, I created my series of checkboxes, along with a
series of text fields that are not displayed. When a checkbox is
selected, I have a rule to look up the area associated with that
checkbox in the list, and then append the names, separated by semi-
colons, into the text field. If the checkbox is unchecked, this text
field is blanked out.

I create another text field, hidden, that is filled at the submit
button time, At submit time, a rule concatenates all the checkbox text
fields into this text field, and then the next submit rule makes use
of this field as the To list.

There's other rules to make certain that the submit doesn't send a
message if no checkboxes are set, etc.

It took a while to figure out. I wasn't able to figure out how to get
a sharepoint list column which allows multiple people into Infopath,
but this hard coded approach works for my specific case.