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";
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!
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";
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?
1. At the end of the code add this:
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.