Hi,

We've published InfoPath forms in document library 'A' and used default "ID" field of SharePoint to generate Request IDs for tickets.

As we add consequent documents(items) in library 'A', 'ID' is getting incremented properly i.e. 801, 802, 803. But sometimes, consequetive IDs generated as 815, 820, 824 even if the items/documents between them are not deleted.

Can anyone help me for the reason behind this.

T

Hello Kunal,

Could you please share your infopath logic? Basically this should not happen and i haven't seen this problem yet.

Can you also publish same form to different library and see the result?

Hi Hemendra,

Please find the sample logic below.

The last three digits depend on "ID" field (SharePoint system generated column). But sometimes, consequtive IDs are not synchronous eg. 815, 820, 822  even if the items between them are not deleted.

Thanks,

Hello Kunal,

I am just thinking if this issue is related to multiple instances of form. Just try to add one more text field in form and populate item id on form load in that field. Then use this field in your rule instead of "max(i@d)+1".

Just try this and see the result