InfoPath Dev

Are you populating a username first via a field labeled something like User with a default value of userName()?

Thanks again Hilary. Everything is working great and the update to the form went into production this morning. All of your recommendations worked. I created a rule on the submit to check for duplicated invoice totals by using a query rule. Then setting a helper field to true if found. If an invoice total is exactly the same as the one ...

Hilary thank you it does work querying right off of the fulltotal. I added a button and it does retrieve the correct value.

Hilary maybe you can help me a little more? Could I create a query on the invoice total so I don't have to have the data connection set to always retrieve? I would query using the fulltotal on InvoiceTotal to retrieve the matching invoices. Problem is formatting again because SP has more zeros right?

NICE! That worked. Thank you so much. Will need to remember this. Now I can put this together how I want.

Hi Hilary, Thank you for the reply. I figured as much that SharePoint was returning more zeros. I went to that column and formatted it the same currency and 2 decimal places,but when it is retrieved in InfoPath it doesn't follow the column formatting. I tried using the number function as you suggested but no change. Do you have any other ...

I have a sharepoint list used as a 2ndary data connection that has two columns called Invoice # and Invoice Total. I have dragged the table onto the canvas and I am trying to add a formatting rule d:Invoice_x0020_Total != xdXDocument:get-DOM()/my:myFields/my:FullTotal. These numbers match but the table remains blank. If I do the same using Invoice ...

Glad you figured it out. Sorry I was away.

You will want to use a secondary data connection. You will want to connect that secondary data connection to a sharepoint list where you have all your selections.

The "." means you are picking the same field you are putting the rule on. When you pick a field you pick difference.