InfoPath Dev

Sorry, I miss spoke. I first created a rule to submit to both SP list connections but it did not work. All the fields in the main source data list. I have created a SP workflow to copy the list items to the second list. I think I could explain it better if I could privately share the form.

Here's what you said in your initial post: "... it calculates to 21.9279 I need that to turn into $21.90" - if all you really want is to display with two decimals, the formatting you said you have set up should already do that. I'm obviously not understanding what you are trying to do. Attaching a file with a text box w/ ...

Thank you, but I think IP is doing the math incorrectly. Wouldn't 25.972 equal 25.97? Instead, the form is setting the number to 25.10. Would you happen to know how I would set up the math?

The main reason I'm confused is that it isn't actually possible in InfoPath to create a submit connection to a list. :-) If the form is a list form, it will have a default submit connection to that list, but it isn't possible to create another submit connection that submits to a second list, unless you are using the lists web service ...

Unfortunately, I cannot share the actual form. The form does submit to the second list, but it only submits the data from the default view page. It does not submit the data from the second view page (although I set the second page submit rule to submit to both SP list). These are list not libraries.

So - does the form currently submit data to the second list? Submitting data to a SharePoint List from InfoPath is not very straightforward - there are ways to do it, but it isn't supported out of the box except in List forms, which only submit to a single list. Or are these form libraries? and you submit to both libraries? Sorry to be ...

The form gives the user an option to submit the second view page only when there is a discrepancy associated with there Audit. The second view page is a discrepancy form. The second SP list has the same form that is used only for discrepancies for our Units, this is why I wanted the second view page to submit the data to the second SP list. ...

Yuck. Have you tried from a different machine?

Weird. I know the form is set to close after each rule, but perhaps try checking the "don't run remaining rules" checkbox in each of your submit rules and republish. See if that helps. I realize that you have the form set to close after the actions run, and that your conditions are exclusive.... but at least it is something to try.

Any chance I can see your form? You can attach it under the options tab. If not - can you tell me what approach you took for submitting to two lists? These are lists, not libraries? You are using code, CAML, or some other approach?