Hi All,
I have a InfoPath form published on Share point where users raise their requests. recently my Sharepont site has been changed and now I made all data connections again with new site name and published the form again but I am facing an issue now. whenever I am raising new request its not giving me new Form number for example:- FW001100, FW001101 and so on. in my earlier site it was working fine.
I have data connection where I have made a data connection Retrieve ID and then in form using a concat("FW00", max(@ID) + 1)
There are around 3766 requests on site and now whenever I am raising new its giving me a same number all time 3534 only. Have given below one screen shot for ref. Please help how I can sort this out.
