Participant

Question

Help with javascript to calculate many fields

7 replies
487 views
Translate

Hello,

I need help with my java code. I got a form with 3 columns with 160 text fields in each column. They are named A1.0.0-A1.15.9, B1.0.0-B1.15.9, C1.0.0-C1.15.9.

What i want to do is take (value of) B1.x.x - C1.x.x and if the difference is more then 1.0 and less then 1.9 i want to give a message to controll that number.

So far i got this code:

(function calculate() {

var fieldNumber = event.target.name.replace("A", "");

var v1 = +this.getField("B"+fieldNumber).value;

var v2 = +this.getField("C"+fieldNumber).value;

var v3 = v1 - v2;

event.value = v3;

})()

else if ((v3 >= 1.0) && (v3 <= 1.9)) {

app.alert = ("controll this");

}

else {

event.value = "";

})();

I get a syntex error on row 9, what did i miss? My idea is to call on this function in the calculate tab in the A.x.x column. Please help a novice thats trying to learn java

This topic is closed to new replies. Start a new post to keep the conversation going.

T

Test Screen Name

Legend

Look at line 8. It starts with "else". Why?

Translate

try67

Community Expert

There are a lot of errors in your code. You have lines outside the function. You have an else if without a preceding if. You have a mismatched number of parentheses, etc.

Translate

T

Test Screen Name

Legend

The error is on the app.alert line. The = sign does not belong. = is used only to set one value to another, but you aren't changing app.alert.

Translate

T

Test Screen Name

Legend

Oh, and you have an "else" without an "if". When you've fixed this I think you will find the messages very annoying as there will be far too many of them.

Translate

A

adrianholmAuthor

Participant

Thank you. Yes i guess it can be annoying with alot of messages. I was thinking about highlighting the fields instead of message. Something like this:

(function calculate() {

var fieldNumber = event.target.name.replace("A", "");

var v1 = +this.getField("B"+fieldNumber).value;

var v2 = +this.getField("C"+fieldNumber).value;

var v3 = v1 - v2;

event.value = v3;

}()

else if ((v3 >= 1.0) && (v3 <= 1.9)) {

fillColor = color.red;

}

else if {

event.value = "";

})();

@try67 if you could please point out the errors you mentioned, that would help alot. Im just starting to learn java. i dont think i can use above code to fill/highlight cells, any ideas how to improve the code?

Translate

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.