InfoPath Dev

Your rules are on the field you wish to set (this is a common mistake, I used to do this all the time!) and they need to be on the fields that will be changing. That is, rules fire when a field changes, so you don't want them on your target. Instead, put the rules on NRD CPQJ.

Attached. Be aware it does have a connection to my sharepoint and it may ask for credentials. You should be able to cancel on that. The GOOD, BAD, and OK fields are hidden but lay at the bottom of the form.

If you are using a browser other than IE, or typing things up in some other application and pasting in that may cause the issue. If you attach a copy of your form under the Options tab in a reply, I'd be happy to give you a hand.

Yes, I understood this - were you able to put the batch node on your form? Is the data populated both in the browser & in preview?

I had everything typed up. But not everything appears when I post it here. I continued my question over at msdn. https://social.msdn.microsoft.com/Forums/office/en-US/d6c608f4-a88d-495c-b095-b8e6c0e5ae3e/display-text-based-on-field-value?forum=sharepointcustomizationlegacy#d6c608f4-a88d-495c-b095-b8e6c0e5ae3e

From the preview mode everything works exactly as desired. The problem occurs once the form is published and submission takes place from the browser. That is what I am racking my brain trying to figure out.

So - are you looking to create a calculated column in a SharePoint list that reflects this formula? Or are you working on an InfoPath form and need help with the logic to set the field? If this is in InfoPath, you'd use rules with conditions to accomplish this. If you attach your form under the Options tab in a reply, with some info on what ...

Really new to Infopath. I did do some searching and I found rules as there is no IF statement for xpath. What I am trying to do is move a spreadsheet to SharePoint. One of my cells for calculation has this formula: =IF(C26>=H26,"BAD",IF(C26>=G26,"OK",IF(C26= BAD (Set a fields Value: BAD) NCPQI >= OK (Set a fields ...

If your web service submit is submitting the batch node, you'd expect to see the values there in the list - since your form is succeeding in Filler, you could always verify this in preview.

When you drag the batch node to the form and preview the form entries created in the form should be mirrored in the batch table as well. Is that correct?