Custom Calculation Script

Forum|Forum|8 years ago
August 25, 2017
1 reply
652 views

Need help writing a custom calculation script. The script needs to be written so that if "Field1" = 80 and "Field2" = 10 then it returns John, but if "Field1" = 99 and "Field2" = 75, then it returns Jane.

I tried using some other scripts that I found, but they wouldn't work. It would usually just always return the value of my first "if statement" regardless of whether it was true or not".

Also this is for Acrobat Standard DC.

Thanks!

This topic has been closed for replies.

try67

Community Expert

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";

wohlgang99Author

Participant

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!

try67

Community Expert

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";

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.

Scanning file for viruses.

This file cannot be downloaded