Skip to main content
J
Jordan27718208hgs0
Known Participant
July 13, 2023
Answered

Subtraction javascript

  • July 13, 2023
  • 1 reply
  • 950 views

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;

This topic has been closed for replies.
Correct answer 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 reply

try67
Community Expert
try67Community ExpertCorrect answer
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
    Jordan27718208hgs0Author
    Known Participant
    July 13, 2023

    Perfect, thank you.

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