-
1. Re: Custom Calculation Script
try67 Aug 25, 2017 2:58 PM (in response to wohlgang99)Try this:
var v1 = Number(this.getField("Field1").value); var v2 = Number(this.getField("Field2").value); if (v1==80 && v2==10) event.value = "John"; else if (v1==99 && v2==75) event.value = "Jane";
-
2. Re: Custom Calculation Script
wohlgang99 Aug 25, 2017 5:35 PM (in response to try67)Hmm. Not having luck with that. I'll try being a little more specific. Field1 is actually titled Customer Office Code and field2 is titled Department.
Let's assume this is what I need it to return:
If Customer Office Code = "90 - Maine", and Department = "12 - Maintenance" = John Doe
and Customer Office Code = "80 - Ohio, and Department = "15 - Tech" = Jane Doe
Would that change how the code needs to be written?
Thank you again!
-
3. Re: Custom Calculation Script
try67 Aug 26, 2017 12:37 AM (in response to wohlgang99)var v1 = this.getField("Customer Office Code").valueAsString; var v2 = this.getField("Department").valueAsString; if (v1=="90 - Maine" && v2=="12 - Maintenance") event.value = "John Doe"; else if (v1=="80 - Ohio" && v2=="15 - Tech") event.value = "Jane Doe";
-
4. Re: Custom Calculation Script
wohlgang99 Aug 26, 2017 9:58 AM (in response to try67)Yes! This is what I was looking for. Now is there a way to add a catch all? Meaning if they try choosing a selection that doesn't fit the script then it will say "invalid combo"?
Also, is there a limit to the number of combinations that can be included in the script?
Thank you!!!
-
5. Re: Custom Calculation Script
try67 Aug 26, 2017 12:45 PM (in response to wohlgang99)1. At the end of the code add this:
else {
app.alert("Invalid combo!");
}
I also recommend you add this line before the first if-condition:
event.value = "";
2. No, there's no limit to the number of combinations.