Copy link to clipboard
Copied
Guys,
I'm trying to do a conditional formula where it compares two fields, and only calculates if one field is greater than the other. Here is the code I've cobbled together from multiple other codes that did what I wanted -in part-.
Can you guys tell me where I'm going wrong?
var 12 = this.getField("Line 12").value;
var 13 = this.getField("Line 13g").value;
if( 12 > 13) event.value = this.getField("Line 12").value - this.getField("Line 13g").value;
else event.value = "0"
Copy link to clipboard
Copied
Don't use numbers as name of variables.
Copy link to clipboard
Copied
Variable name can't start with a number.
Copy link to clipboard
Copied
In your screenshot, notice the message "illegal character 2: at line 3".
Look at the quotes used in the line of code for "var B".
It seems like you copied the code from another program ( or an open webpage in your web browser) and then pasted it directly into the JavaScript editor.
Make sure you're using the same quote typeface as you have in the rest of your script.
Also, to be on the safe side, you may want to close the last line for event.value = "0" with a semicolon ";".
Copy link to clipboard
Copied
Now your missing a quote in this line "Line 13g
Since you declared variables already your script can be typed in much shorter like:
if (A > B) event.value = A-B;
Copy link to clipboard
Copied
Don't use numbers as name of variables.
Copy link to clipboard
Copied
Thanks!
Copy link to clipboard
Copied
New error, now.
Copy link to clipboard
Copied
Variable name can't start with a number.
Copy link to clipboard
Copied
Thanks to you, too!
Copy link to clipboard
Copied
New error.
Copy link to clipboard
Copied
New error. Any help appreciated!
Copy link to clipboard
Copied
In your screenshot, notice the message "illegal character 2: at line 3".
Look at the quotes used in the line of code for "var B".
It seems like you copied the code from another program ( or an open webpage in your web browser) and then pasted it directly into the JavaScript editor.
Make sure you're using the same quote typeface as you have in the rest of your script.
Also, to be on the safe side, you may want to close the last line for event.value = "0" with a semicolon ";".
Copy link to clipboard
Copied
Thank you! That's 100% what I did. Now I'm getting this:
I'm on the last line! I'm sorry to keep posting about it, but I don't do JavaScript often, and I like to mess it up good when I do!
Copy link to clipboard
Copied
Why have you removed " after 13g?
Copy link to clipboard
Copied
Accident because I retyped the whole this to make sure the font matched and forgot the "
Copy link to clipboard
Copied
Now your missing a quote in this line "Line 13g
Since you declared variables already your script can be typed in much shorter like:
if (A > B) event.value = A-B;
Copy link to clipboard
Copied
PERFECT! Changed that line and it's working now.
Copy link to clipboard
Copied
THANKS EVERYBODY! Combination of correct answers to help me limp along! Got it worked out!

