InfoPath Dev

Hi all,

I have a data connection set up that queries a Sharepoint form library and returns the ID field.

In Infopath, I have set up a field to contain max(@ID) +1
This worked fine until I reached ID 190, now this is the only ID that the data connection returns.

The form uses this field as the file name.

This means all new forms created have a filename of 191.

I have checked the list, and there are definitely 191 entries. The latest ID was 191.
I then tried uploading a document to take the place of 192.
It is in the list, but Infopath still says Max(@ID) +1 results in 191.

Any ideas why the data connection is failing?

Oh, I have created a different form, just for the purpose of testing the data connection, and the new form also picks up 190 as the highest ID in the list.

Hi GreenAnt,

Are you sure you are checking the default view in the SharePoint list?

Anyway, this is not a good way to increment the value because it depends on the default view which doesn't necessarily have all items in it and it doesn't protect against two simultaneous submitters getting the same value. You should submit the form and then query to get the ID and add it to the form and submit again. That's a bit of a hack (since you have a dual submit), but it's an easy way to do what you want without this issue.

Best of luck!