#ADOBE ACROBAT VERSIONS PERCENT OF USERS HOW TO#
#ADOBE ACROBAT VERSIONS PERCENT OF USERS PDF#

This was only used for the final TOTAL (all the sub-total fields used the built in SUM function). I finally found a simple Javascript online that I was able to modify. Each time I tried this the error did not occur until adding the fouth set of fields and it ALWAYS occured. Reviewing those files, all of them are in proper sequence. This included recreating the form, multiple times, from scratch, with ONLY the required fields that had calculations. I went on vacation for a couple of weeks and am just now seeing the response to my query “I have a form that requires simple multiplication and addition using both default numbers and user input data.”īetween posting my query and then going on vacation, I experimented with a number of methods. Var p=this.getField(“Marketing 1”) var q=this.getField(“Furniture 1”) Įvent.value=a.value+b.value+c.value+d.value+e.value+f.value+g.value+h.value+i.value+j.value+k.value+l.value+m.value+n.value+o.value+p.value+q.value+r.value+s.value+t.value+u.value+v.value+w.value+x.value+y.value+z.value+aa.value+bb.value Var o=this.getField(“Application Fee 1”) All of the fields are defined as “Number”. I build this formula and it works but assumes all fields are “not null.” As you add values, the sum concatenates instead of adds to the total. I have a similar issue with summation of numeric fields using Javascript for Adobe. The fields that are set to calculate are not showing up in the “Set Calculation Order” dialog box and there is no way to change this unless, like I said before, out of the several dozen tries to use the Pick… selection box, it will work, once and only once and then it’s two hours later, two days later, and still nothing… nothing… nothing works…įYI, I have over 500 fields in a two page document. They are set correctly but not represented in the “Set Calculation Order” dialog box. I’ve checked all the fields that are not listed in the “Set Calculation Order” dialog box to see if they were set to calculate. I looked back in the “Set Calculation Order” dialog box and it had appeared at the very bottom, well after I re-arranged them. Luckily, I was able to change the calculation to be the 3s. I tried the last 3 I needed “3MaterialColorPrice” and it had a calculation but wasn’t on the list. So I checked to make sure they are set to calculate something. They are on the form but not represented in the “Set Calculation Order” dialog box. The 4s, 5s & 10s are not in the field box. All the 1s, 2s, 3s, 6s, 7s, 8s and 9s show up. Only a fourth of the calculable fields show up in the Calculation Field box. So now your form not only looks great, it also gives you and your users immediate information. Unless you write the JavaScript, leave the field unformatted as Acrobat will still calculate the proper value. The only way to guarantee a seamless division operation is to use a JavaScript IF statement to define conditions for the field when it's blank. If you open the Format tab and choose Number from the Format category, you'll see an error message. If you leave the default settings for the field as unformatted content, the field shows NaN-which means Not a Number. You won't have any surprises with adding, subtracting, or multiplying, but a division calculation can cause display problems. Click Preview to toggle the Preview mode to test your work.Click OK and you'll see the expression on the Properties dialog box. Again, make sure you don't have any spaces.

In the JavaScript Editor, type FieldB/FieldA.

In the Calculate tab for the results field, choose Simplified Field Notation, and click Edit.

Click OK and you'll see the expression show on the dialog box.

Type the expression in the editor, such as Field1-Field2.

click Edit to open the Javascript Editor.

Now click the Simplified Field Notation radio button.

Open the Properties for the results field.

Subtraction and division are a bit harder since you don't have a simple option to pick.

Click Pick to open a list of the fields in your form, select the fields you want to multiply, and click OK to list the fields in the dialog box.

To multiply the values entered into fields, click the Value Is The radio button.

Click Pick to open a list of the fields in your form, select the fields you want to add, and click OK to list the fields in the dialog box.

To add the values entered into fields, click the Value Is The radio button.

Double-click the field where you want to display the result to open the Properties dialog box.

#ADOBE ACROBAT VERSIONS PERCENT OF USERS PDF#

Follow these steps to set calculations in text fields and drop-down boxes that appear in your fillable PDF forms: To add text fields

#ADOBE ACROBAT VERSIONS PERCENT OF USERS HOW TO#

In this tutorial, learn how to calculate fillable PDF forms using Adobe Acrobat X or XI.

Adobe acrobat versions percent of users