Skip to main content
cohen812
cohen812
Participant
September 1, 2020
Question

Invoice generator with acrobat

  • September 1, 2020
  • 1 reply
  • 1169 views

Hi everyone !
I might be really off here so let me know if u think theres a better way to do this.

So I made an invoice template on illustrator.
I wanted people from the team to be able to fill it out with just adobe reader. So I went to acrobat pro and prepared form. Everything is fine until I got to the part where the invoice needs to be filled by products. And, all of the sudden it doesnt make so much sense to me (for instance an automatic second page, subtotal, tax, etc etc) anyone has an idea how to make that more seamless through our large group that is focused on sales and not design softwares.
I wanted to make it easy on them to fill this out.
(So far they were using excel, but I wanted the document to look much better with graphics and layouts that cant be done with excel and even when I convert the pdf to excel, the document changes completely)..

Any thoughts are so welcome !

This topic has been closed for replies.

1 reply

try67
Community Expert
try67Community Expert
Community Expert
September 1, 2020

So what exactly is the issue? What do you want to implement, but don't know how? Adding an extra page automatically? Applying calculations? Exporting to Excel? Your description is not really clear.

The first thing (adding a page) is possible, but a bit complicated to set up and requires some scripting know-how.

The second thing (applying calculations) can be very simple or quite complicated, depending on the calculations.

The third thing (export to Excel) is not possible in Reader at all, although the form data itself can be exported from a PDF file even in Reader, but again it requires some advanced scripting knowledge.

cohen812
cohen812Author
Participant
September 2, 2020
First off thank u so much try!
I was able to get it going, added calculations and some scripts. But now
I'm getting this weird result when I multiply (product) two fields to give
me a total. And the weird result is %,0.2f

What is that???

Thank u
ls_rbls
Community Expert
ls_rblsCommunity Expert
Community Expert
September 2, 2020

Maybe you were trying to employ the util.printf() method but incorrectly.

 

Check the custom calc script of the field where this is happening.

 

Util.printf() should be phrased in the "event.value =" part like:

 

var a = this.getField("Field1")* this.getField("Field2").value;

 

 event.value =util.printf("%.2f", a);

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices