We have made our Requisition form available in as a PDF. The problem we are having is that each requisition needs to have a unique requisition number so the customer has something to refer to when tracking the order.
Is there a way to set up the form to auto assign a unique number? This number could be tied to date and time just so that it generates an identifying number.
Yes ...there is a FormCalc function that will return the number of seconds form a point in time (called an Epoch). If you use the time() function it will return that number. As long as 2 users do not open th eform at exactly the same time then you can be guaranteed a unique number.
I found this thread on a search, as I have the same issue. Piggybacking on this question, this does work assigning a unique number, however for me, that PDF is e-mailed to another group as well as saved by the user. But now, when either of those people open that PDF, the number continues to incriment. Is there a way to make it not change once the PDF has been saved/e-mailed? My thought would be to make the entire form become read only, but I am not sure that would even fix it?
Do a check on the field to see if it is empty before doing the calculation. This way if the field is empty then the calc will fire...if there is already something in the field (presumably a form number) then it will not recalc.Something like this: