Skip to main content
C
Charles5C81
Inspiring
September 16, 2022
Answered

PDF auto numbering for Invoices

  • September 16, 2022
  • 1 reply
  • 1922 views

I need to add unique invoice number to a form that will auto-populate the new number every time the form is saved. The number needs to be 2022-IN-20000 with the new number following as 2022-IN-20001 and so forth. Can anyone help? Thanks

This topic has been closed for replies.
Correct answer Charles5C81

This works perfectly. Thank so much for your help and have a great week. 


I am noticing one problem if you can help. When I add my digital signature to the document and save it and then reopen the saved document later it advances the saved number to the next number. Saving the document after signing marks all fields as read only and I cant change the number back. Is there a way to lock that number once it is saved so that it wont advance when I reopen it later. 

1 reply

try67
try67
Community Expert
September 16, 2022

Will there be only one copy of this file? If not, you will get duplicates values, as one copy can't know which numbers have been used by the other.

C
Charles5C81Author
Inspiring
September 16, 2022

There will only be one copy for each number. I am a Justice of the Peace and this is a form that I open and fill out each time I conduct an Inquest and each form has to have a separate case number that runs in order. After I fill the form out, I save it to a file on my computer. The number needs to start with 2022-IN-20000 and advance to the next number each time the document is saved. Thank you!

try67
try67
Community Expert
September 16, 2022

OK, then create a (read-only) text field in the location where you want this number to appear and call it "InvoiceNumber". Then go to Tools - JavaScript - Set Document Actions and place the following code under the Will Save action:

 

var f = this.getField("InvoiceNumber");
var s = f.valueAsString;
if (s=="") f.value = "2022-IN-20000";
else {
	var parts = s.split("-");
	var currentNumber = Number(parts[2]);
	f.value = "2022-IN-"+(currentNumber+1);
}
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices