Skip to main content
MRahnemun
Inspiring
March 3, 2019
Answered

field calculation

  • March 3, 2019
  • 1 reply
  • 1914 views

Hello,

I do have a form and I would like to do a simple calculation of a fields... here is what I have coded that does not work.

event.("Balance.0").value = this.getField("Credited.0").value - this.getField("Debited.0").value - this.getField("AmtDistributed.0").value;

Balance.0 is a read only field, when I enter number in Credited.0, Debite4d.0 or AmtDistribute.0 still Balance.0 stays blank.

What I am doing wrong?

Regards,

Jeff P.

This topic has been closed for replies.
Correct answer try67

You need to place it as the custom calculation script.

1 reply

try67
Community Expert
Community Expert
March 3, 2019

Change this:

event.("Balance.0").value

To:

event.value

MRahnemun
MRahnemunAuthor
Inspiring
March 3, 2019

Hi,

Did not worked...

I have the formula under the Action tab of Balance Field.

Regards,

Jeff P.

try67
Community Expert
try67Community ExpertCorrect answer
Community Expert
March 3, 2019

You need to place it as the custom calculation script.