InfoPath Dev

Hi Hilary Yes, I'm submitting the form to SharePoint. Sorry, I'm not sure how to query the list to retrieve the last record in the list base on the year field. I do have a Year field in the form, and the autonumbering field with this formula in the field "max(ReqNumber[CustPreFix = ReqPrefix]) + 1". it will look for the ...

Hi I'm trying to create a form to capture Change and need to have AutoNumbering on the form base on Current Year and customer Prefix. The auto number need to be reset when it cross over the year. The format will be yyyy[Customer Prefix][AutoNumber], so example the form capture 2019AB01, 2019BC01, 2019BC02..2019AB35... Then in year 2020, ...