Infopath Forms

[Donna Bailey]

When using the Office 2003 (Infopath form) How can I get the 'submit' button
on the infopath form to both submit to the database it is connected to and
submit to an e-mail address? I tried to use the customize feature in options
but as far as I can tell it only allows you to submit to multiple databases.
I need to have co-workers fill out the form (it is a customer complaint form)
and hit submit so that it creates a record in the database and at the same
time gives notification to their Supervisor that a form (customer complaint)
has been filed, allowing the Supervisor to assign it to a specific worker.
Has anyone figured this one out?

 

[Clay Fox]

You need to switch the submit options from submit to use rules and custom code.
This is via the dropdown.

Then you can add as many rules and actions as you want.
Set field values, messages, switch views,etc.
Then add an action to submit to each of your seperate data connections

 

[Donna Bailey]

Mr. Fox, Thank you for your response but I'm still fuzzy on this. When I
change the submit forms options to submit to use rules, I don't see where it
allows me to submit to a database AND submit to e-mail at the same time. I
also do not know script so I can't use the custom code option. Is there a
tutorial anywhere that would walk me through this?

 

[Clay Fox]

Hi Donna.

You cannot do them technically at the same time, it would be sequential but
in the same action.

Set to Rules.

Then you should get a rule button that becoimes visible.
Select it and add a rule
Do not put a condition so that the rule happens each time the button is
pressed.
Add an Action and set the action type to submit and select your submit to
database.
Then add a second action, select submit, and pick you email submit.

If you need additional help you can email me here.
I specialize in database integration and work flow and may be able to help
you further. http://www.infopathdev.com/members/clayfox.aspx

 

[Clay Fox]

OK I see.

You have not actually create dth eemial submit yet. So there is nothing to
call.
And the database one was created for you.

Go to tools and then data connecitons.
This is where you create a submit to email. Put in the parameters you want
and complete it. Then you can add an action and select that one in one action
and your Main submit in the other.

Do you have a way of looking up the email addresses of your users?

 

[abrown]

I was having the same problem & this information helped me figure out how to
get the form data sent via email and to the database.
I do have an additional question. I created a form where users can request
reports from the IT dept. They enter their information on the form & then
submit it. The email goes to the IT Manager (as well as the database now that
I figured that out). The IT Manager wants to then add additional data (ex.
"Assigned To" and "Completed Date") in the "For IT Use Only" area of the
form. How can this additional data be added to the form and then re-updated
to the database to reflect these changes.