Skip to main content
J
John5E59
Participant
December 14, 2020
Answered

Custom Calculation Script Assistance

  • December 14, 2020
  • 1 reply
  • 691 views

I have a formula in excell that calculates the numbers for me but I have been asked to convert it to a pdf format and I am not familiar with pdf calculations. Can anyone share with me the formula I need to calculate this?

I have a column that is labeled, "Drop (paig)", first box below is labeled, "Drop paigRow1". Beside that I have a  column labeled, "Pass", and the box below is labeled, "PassFailRow1". When someone types in the "Drop paigRow1" field a numeric character greater than  0.5, it will display, "Fail" in the "PassFailRow1" field. If the user types anything less than or equal to 0.5, it will display, "Pass" on the "PassFailRow1" field. 

 

Thanks in advance.

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

You can use this code in "PassFailRow1" field:

if(this.getField("Drop paigRow1").value > 0.5){
event.value = "Fail";}
else if(this.getField("Drop paigRow1").value <= 0.5){
event.value = "Pass";}
else event.value = "";

1 reply

Nesa Nurani
Community Expert
Nesa NuraniCommunity ExpertCorrect answer
Community Expert
December 14, 2020

You can use this code in "PassFailRow1" field:

if(this.getField("Drop paigRow1").value > 0.5){
event.value = "Fail";}
else if(this.getField("Drop paigRow1").value <= 0.5){
event.value = "Pass";}
else event.value = "";
    J
    John5E59Author
    Participant
    December 14, 2020

    It worked! Thank you Nesa. I hope you have a wonderful day!

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