ACROBAT INTERACTIVE PDF MULTIPLE CALCULATION OPTIONS

Forum|Forum|3 years ago
July 21, 2022
2 replies
1230 views

What I would like to do, is calculate from 3 fields.

Field one x 4 equals field 3 (in simplified field notation, I’ve put Field one name * 4)

and

Field two x 2 equals field 3 (in simplified field notation, I’ve put Field two name * 2)

I can set up the calculation in field 3 to say either of those options singly

BUT

I’d like to say both.

Does anyone know if you can ask the calculations field to do 2 different calculations to 2 different fields?

This topic has been closed for replies.

Correct answer Nesa Nurani

You can use this as custom calculation script of "P1.3" field:

var one = Number(this.getField("P1ONE").value)*4;
var two = Number(this.getField("P1TWO").value)*2;
if(one != 0)event.value = one;
else if(two != 0)event.value = two;
else
event.value = "";

Nesa Nurani

Community Expert

In field 3 (P1.3) you want to show result from field1*4 and field2*2 combined or two different results?

If combined you can still use SFN for it just add plus sign: P1ONE*4+P1TWO*2.

V

virginias10218395Author

Participant

Hi. 2 different results. Some people will fill in column one, some column 2 but not both. Thanks 🙂

Nesa Nurani

Correct answer

Community Expert

You can use this as custom calculation script of "P1.3" field:

var one = Number(this.getField("P1ONE").value)*4;
var two = Number(this.getField("P1TWO").value)*2;
if(one != 0)event.value = one;
else if(two != 0)event.value = two;
else
event.value = "";