InfoPath Dev

So, if there are multiple Amount fields - there will also be multiple Total Recieved fields? Do you need to be comparing the total of both?

dfs:dataFields/my:SharePointListItem_RW/my:TotalRecieved != sum(xdMath:Nz(dfs:dataFields/my:SharePointListItem_RW/my:Amount))

The controls on your form are bound to fields in your data source. If your "Staff ID Number" text box had been a dropdown instead, I wouldn't be able to tell from the screenshot if the values were the same. They sure look the same, don't they? You could add an expression box (calcuated value) in the repeating section with the ...

So, since you are using 2010, you should be able to create a REST data connection to the owssvr.dll. And then for your filter field, use whatever column returns the link - I usually start with Query=* to get back everything. Try the URL in the browser first - probably look something like ...

I'm using SP2010 and IP 2010, but the form template is saved for the  IP 2007 Client. yes, i'm using the List data connection. Does anyone have any ideas why this column would not be available?

Can you change the first dropdown of the condition to "The expression" and paste in the resulting XPath so I can see the whole condition?

It makes total sense, but it doesn't seem to work. I have a rule on the submit button so if Total Received is not equal to sum(amount), the Submit button is hidden. Here is the XPath of the sum(amount) sum(dfs:dataFields/my:SharePointListItem_RW/my:Amount) But it only seems to work in the first Amount field. It's not adding up all the ...

[quote user="Hilary Stoupa"]Hi! I think you can get the ID back using the URL if you use FilterOwssvr or REST - are you using ShP & IP 2010? or 2007? [/quote] We're using 2010 for both. I'll investigate that as an option. Thanks Dan

Hi there - I believe you can only do one or the other for a single button though someone out there can correct me if I'm mistaken.

[quote user="ErnestoM"]Hi Dan, Thanks for the info. Sorry, there's nothing inherent in qRules to achieve this functionality. If the FileName is unique (I assume it must be) couldn't the form use that to query the library and find the newly created item?  [/quote]That's the SharePoint conundrum. Oddly enough, you ...