Skip to main content
mirza5313
Known Participant
April 23, 2017
Question

Multiply numeric fields by user entered input

  • April 23, 2017
  • 1 reply
  • 575 views

Hello I am wondering if any one help me.. I have very simple calculation but got stuck I have more then 59 numeric fields that i wan to multiply by user entered data!!

I just want when any one enter at QUANTITY field 2 or whatever they want the last Grand total field will show 160 as the text1 price is 80.00 $, so far I have this js code but this code is work only one field.

// Get first field value, as a number

var v2 = +getField("Text2").value;

var v3 = +getField("Text3").value;

// Calculate and set this field's value to the result

event.value = 80 * (v2);

event.value = 80 * (v3);

So I want there will be text1 to text 59 in same condition

event.value = 80 * (v2);

will be change according to item price...

This topic has been closed for replies.

1 reply

JR Boulay
Community Expert
Community Expert
April 23, 2017

Hi.

Assuming that your fields uses the Field naming convention and are named as:

price.0, price.1, price.2, etc.

and

quantity.0, quantity.1, quantity.2, etc.

and

total.0, total.1, total.2, etc.

(Or whatever name you want for "total", here the number is the only thing that matters)

Place this script as a calculation script in all "total.n" fields:

oNomChamp = this.event.target.name;

var nNumRangee = oNomChamp.substring(oNomChamp.lastIndexOf('.')+1);

nPrice = this.getField("price." + nNumRangee).value;

nQuantity = this.getField("quantity." + nNumRangee).value;

event.target.value = (nPrice * nQuantity) * 1;

Using the Field naming convention is easier and automatic when duplicating fields via: right-clic (upon a field) : Create multiples copies…

Acrobate du PDF, InDesigner et Photoshopographe
mirza5313
mirza5313Author
Known Participant
April 23, 2017