5 Replies Latest reply on Aug 26, 2017 12:45 PM by try67

    Custom Calculation Script

    wohlgang99
    wohlgang99 Aug 25, 2017 1:57 PM

      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!

      • 339 Views
      • Categories: Windows
      • Tags:
        • 1. Re: Custom Calculation Script
          try67 MVP & Adobe Community Professional
          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 Level 1
            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 MVP & Adobe Community Professional
              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 Level 1
                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 MVP & Adobe Community Professional
                  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.