Invoice Number Increment Shared Drive

Avatar

Avatar

catherines19033

Avatar

catherines19033

catherines19033

21-12-2017

I have a form fillable PDF that is located on our website. It has two buttons, a PRINT and CLEAR. I also have a text field called InvoiceNumber. What I want is every time a user clicks the button PRINT, the InvoiceNumber text field increments and stays that number.

I made it the text field to increment using the following script:

var f = this.getField("InvoiceNumber");

f.value = Number(f.value)+1;

f.defaultValue = f.value;

BUT, when someone or the same one opens it up or refreshes the page, it goes back to a blank text field, then when that person clicks print it increments again.

I am wondering if there is a way to have a text field increment after a person prints the form, close it and when it opens again the number is the next number. Is this possible?

1378409_pastedImage_0.png

Accepted Solutions (0)

Answers (4)

Answers (4)

Avatar

Avatar

altrue990

Avatar

altrue990

altrue990

21-01-2018

Access connectivity is not an internet ready solution (they will need access to the DB). If you really need to do this via internet, consider using a SOAP service or manually compose a REST call to get the current invoice number.

Avatar

Avatar

MinusZero

Avatar

MinusZero

MinusZero

18-01-2018

I have had limited success connecting a database, but you can bind a field to a database so I think it would be possible.

Avatar

Avatar

catherines19033

Avatar

catherines19033

catherines19033

18-01-2018

Is it possible to connect a PDF form to a Microsoft Access database using javascript? I want a read only text box on the form to get the autonumber field from Microsoft Access database I created.

Avatar

Avatar

MinusZero

Avatar

MinusZero

MinusZero

21-12-2017

It would reset when someone else opens the form or refreshes because it will open the saved version for your website.

The only way you could do it is if you saved the pdf after printing, that way the updated number would be saved into the form...obviously being on a website that is a problem.