Copy link to clipboard
Copied
They are exclusive of each other. What I want is, if a value is entered in field A, make field B = 0 [or blank]. The problem is, if a value if placed in field C, then field B, which is not related go blank. Why? there is no other formula for that value.
This is how I have the formula set up in each field.
this.getField("TRADollar").value = "";
this.getField("TRAPct").value = "";
this.getField("Rothdlr").value = "";
this.getField("RothPT").value = "";
The calculation order is correct and listed as follows.
Don't use calculations. Use a validation script.
For example the validation script for A would be:
this.getField("TRADollar").value = "";
This will solve your issue. It works like this. The user enters a value into A. When the user hits return or tabs or clicks out of the field the validation script is called, which clears B. Repeat the pattern for each field.
And I'll repeat this one more time. DO NOT USE A CALCULATION
Copy link to clipboard
Copied
You didn't add any conditions to your code...
Copy link to clipboard
Copied
Is the condition applicable on all four fields? Should I use a, b, c, d for fields to create conditions? This is not my forte. I appreciate the feedback.
Copy link to clipboard
Copied
I don't know... It depends on how you want it to work.
Copy link to clipboard
Copied
What is A, B, and C?
Copy link to clipboard
Copied
those are fields.
If A has a value, then B should be zero or remain blank.
If B has a value, then make A blank
If C has value, then D is blank
if D has value, then make C blank
I had this for the calculation in each field, but if I add a value in C, B becomes blank. That should not happen.
In field "RothPCT"
this.getField("Rothdlr").value = "";
and so on...
I don't know where the condition should be.
Copy link to clipboard
Copied
Don't use calculations. Use a validation script.
For example the validation script for A would be:
this.getField("TRADollar").value = "";
This will solve your issue. It works like this. The user enters a value into A. When the user hits return or tabs or clicks out of the field the validation script is called, which clears B. Repeat the pattern for each field.
And I'll repeat this one more time. DO NOT USE A CALCULATION
Copy link to clipboard
Copied
Thanks so much! That was easy, my favorite kind of answer! I'm a novice and this is frustrating! thanks again.