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)
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
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?
Use a script for this.
I apologise for not knowing what I should be writing??? Can you give me an idea? Is it just in the calculation section?
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.
Hi. 2 different results. Some people will fill in column one, some column 2 but not both. Thanks 🙂
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;
event.value = "";
Yay! Thank you very very much Nesa, I appreciate your help and have learned a lot today 🙂