Skip to main content
MRahnemun
Inspiring
Mar 3, 2019 8:00 PM UTC
Answered

field calculation

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 is closed to new replies. Start a new post to keep the conversation going.
try67
try67Correct answer
Community Expert
Mar 3, 2019 8:20 PM UTC

You need to place it as the custom calculation script.

4 replies

try67
Community Expert
Community Expert
Mar 3, 2019 8:02 PM UTC

Change this:

event.("Balance.0").value

To:

event.value

Translate
MRahnemun
MRahnemunAuthor
Inspiring
Mar 3, 2019 8:18 PM UTC

Hi,

Did not worked...

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

Regards,

Jeff P.

Translate
try67
Community Expert
try67Community ExpertCorrect answer
Community Expert
Mar 3, 2019 8:20 PM UTC

You need to place it as the custom calculation script.

Translate