I wish to create a Purchase Order form that can sit on our computer SharePoint server. I want all staff (at different locations) to be able to access it, and use it at any time. I need to have a field that when the form is opened it will generate a new number. The next time someone else uses it, the new number will be continuous. I also don't want the number to go up unless the user actually sends the email to their supervisor from the email link that I have embedded. So, if someone just opens it, then closes the form, then number should stay the same.
I would also like the form to clear every time it is open, except for the PO number of course. I'm not sure if this is even possible, but any assistance will be greatly appreciated.
If you need any clarifying questions, then please ask.
I would look at adding the serial number at the point the form is submitted for further processing. Setting it when the PDF is opened could cause an issue if the action is canceled when someone else has opened a copy before the original form was canceled.