Skip to main content
J
Jordan27718208hgs0
Known Participant
July 13, 2023
해결됨

Subtraction javascript

  • July 13, 2023
  • 1 답변
  • 950 조회

I am currently using the below formula for subtraction. However, if "FieldB.0" is empty, I do not want the script to run. When ever "FieldA.0" is filled in, it is still returning the value. I know I need to use an "if" in the script but I do not know how to do that.

 

 

var v1 = getField("FieldA.0").value;

var v2 = getField("FieldB.0").value;

event.value=v1-v2;

이 주제는 답변이 닫혔습니다.
최고의 답변: try67

Use this:

 

var v1 = getField("FieldA.0").valueAsString;
var v2 = getField("FieldB.0").valueAsString;

if (v1=="" || v2=="") event.value = "";
else event.value=Number(v1)-Number(v2);

1 답변

try67
Community Expert
try67Community Expert답변
Community Expert
July 13, 2023

Use this:

 

var v1 = getField("FieldA.0").valueAsString;
var v2 = getField("FieldB.0").valueAsString;

if (v1=="" || v2=="") event.value = "";
else event.value=Number(v1)-Number(v2);
    J
    Jordan27718208hgs0작성자
    Known Participant
    July 13, 2023

    Perfect, thank you.

    약관 및 조건Accessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices