ACROBAT INTERACTIVE PDF MULTIPLE CALCULATION OPTIONS

[virginias10218395]

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?

 

[Bernd Alheit]

Use a script for this.

[virginias10218395]

I apologise for not knowing what I should be writing??? Can you give me an idea? Is it just in the calculation section?

[Nesa Nurani]

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.

[virginias10218395]

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

[Nesa Nurani · Accepted solution]

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 = "";

[virginias10218395]

Yay! Thank you very very much Nesa, I appreciate your help and have learned a lot today 🙂