Balance at last column

[mirza5313]

HI,

I have a pdf fillable form that having very simple calculations i.e total at bottom of the columns but at last column "New Payment" will show figure before entering any amount at Min Payment? there is any other way to code to overcome this issue so that figure will show after user enter the amount at Min Payment?

Basically, I am using Value is the Sum function to add two fields i.e

Min Payment fields + New Payment Fileds just and show balance to total new entered payment and plus previous figure and show at new payment box BUT only show figure when user enter any figure at Min Payment.

This is very urgent any help will be highly appreciated.

Here is the form

Thanks

[Bernd Alheit]

As custom calculation script use this:

if (getField("payment2").value != "") {

    event.value = getField("payment2").value + getField("new payment.0").value;

}

[mirza5313]

Thanks for your code, this custom code for the first field? I just tired but this will add all amount at the second field?

[Bernd Alheit]

I have posted the code for the field "new payment.1". Why does you change the code?

[mirza5313]

because when I enter this code to third filed this will must be changed to work with second filed? this cannot use for all fields I just change fields name etc.

[Bernd Alheit]

But you use a other code in field "new payment.1".

[mirza5313]

okay if I use the same code for new payment.1 what about next fields? Will other fields need to change the code in terms of fields name? can you please explain what other code I have used on new payment.1?

the main problem with this code this will show amount at all fields without entering any data from top to bottom, If I not change any field name then also this will not works

[Bernd Alheit]

For the next field you must use "payment3" and "new payment.1" and so on.

[mirza5313]

I already doing that to change filed name but all fields will show payments just like my snap shot attached?

[Bernd Alheit]

I have posted following code:

if (getField("payment2").value != "") {

    event.value = getField("payment2").value + getField("new payment.0").value;

}

But you have entered following code:

if (getField("new payment.0").value != "") {

    event.value = getField("payment2").value + getField("new payment.0").value;

}

Why did you change this?

[mirza5313]

Actually, this code working but show amount at all fields of New payment?

There are six fields that having the code and when I enter any amount at first or second fields this will show that amount in all fields?

I know there is some thing missing or am I doing wrong?

HERE is form with filled amount