Skip to main content
D
DEE29938451e9aw
Participant
May 17, 2023
Answered

Need help writing a custom calculation script using if, then

  • May 17, 2023
  • 2 replies
  • 1844 views

My first time trying to creat a custom calculation script in an Adobe form and I need some help on writing a conditional script. If my weighted score (which is a percentage) is 1-49% then I want it to yield a "Low" priority score and if my weighted score is 50-74% then I want it to yield a "Medium" priority score and if my weighted score is 75-100% then I want it to yield a "High" priority score. Could you assist in writing the script? Also when I try to put the script in the Custom Calculation script box, I type in the script and then what? My options are Cancel or Go To Line, how do I get it to enter the script?

    This topic has been closed for replies.
    Correct answer Nesa Nurani

    Use this as 'Custom calculation script' of "Text5" field:

    var per = Number(this.getField("nSum").valueAsString);
if(per>=.01&&per<=.49)
event.value = "Low";
else if(per>=.5&&per<=.74)
event.value = "Medium";
else if(per>=.75&&per<=1)
event.value = "High";
else
event.value = "";

    2 replies

    Nesa Nurani
    Community Expert
    Nesa NuraniCommunity Expert
    Community Expert
    May 18, 2023

    If you only see 'Cancel' and 'Go To Line' try to resize JavaScript editor.

    What are the names of the percentage field and the field where you want to show 'Low', 'Medium', 'High'?

    How do you calculate percentage?

    D
    DEE29938451e9awAuthor
    Participant
    May 18, 2023

    Hello,

     

    Thanks in advance for your help.  I have copied and pasted below my form.  The weighted score is the product of “Sum of Total Score”, “Weight” which gives the “nSum”.  Then based on that percentage, I would like to assign a low, medium, or high score in “Text 5”

     

    The priority score would assign Low, Medium or High based on: low (zero-49%), medium (50-74%), or high (75-100%).

     

     

     

     

     

     

    Thank you also for the tip about resizing the JavaScript editor.  I was able to resize and found the “OK” button.

     

    Nesa Nurani
    Community Expert
    Nesa NuraniCommunity ExpertCorrect answer
    Community Expert
    May 18, 2023

    Use this as 'Custom calculation script' of "Text5" field:

    var per = Number(this.getField("nSum").valueAsString);
if(per>=.01&&per<=.49)
event.value = "Low";
else if(per>=.5&&per<=.74)
event.value = "Medium";
else if(per>=.75&&per<=1)
event.value = "High";
else
event.value = "";
    Peru Bob
    Community Expert
    Peru BobCommunity Expert
    Community Expert
    May 17, 2023

    I've moved this from the Using the Community forum (which is the forum for issues using the forums) to the Acrobat forum so that proper help can be offered.

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices