Expand my Community achievements bar.

Don’t miss the AEM Skill Exchange in SF on Nov 14—hear from industry leaders, learn best practices, and enhance your AEM strategy with practical tips.
SOLVED

Calculating 2 fields without a script error.

Avatar

Level 3

Is there a way to make a calculation of two fields not calculate until the 3rd field is reached.  I have a calculation that takes (field1/field2)*100.  Once the user puts in field1, it throws a script error, which is annoying.  Anyway around this???

Thanks for your help.

1 Accepted Solution

Avatar

Correct answer by
Level 10

You need to test to make sure there is a value in the fields first.

Using FormCalc:

if (HasValue(field1) and HasValue(field2)) then

    $ = field1 / field2 * 100

endif

Or JavaScript:

if (!field1.isNull && !field2.isNull) {

     this.rawValue = field1.rawValue / field2.rawValue * 100;

}

View solution in original post

2 Replies

Avatar

Correct answer by
Level 10

You need to test to make sure there is a value in the fields first.

Using FormCalc:

if (HasValue(field1) and HasValue(field2)) then

    $ = field1 / field2 * 100

endif

Or JavaScript:

if (!field1.isNull && !field2.isNull) {

     this.rawValue = field1.rawValue / field2.rawValue * 100;

}

Avatar

Level 3

Jono - thank you so very much!  That worked like a charm.

I really wish I could pick up some more scripting knowledge!

Gretchen