Please help to convert this excel formula in java script if(text32>601,text32*1,text32*text10) Thanks in Anticipation

[malhis18382203]

if(text32>601,text32*1,text32*text10)

Please help to convert above mentioned formula in java script

Thanks in anticipation

[BarlaeDC]

Hi,

Assuming the fieldNames are text32 and text10

then the if would be

var text32Value =  this.getField("text32").value;

if ( text32Value <= 601) {

     var result = text32Value * 10;

} else {

     var result = text32Value;

}

As to what you want to do with result, you would need to explain more about your form? This would probably be best placed on the Validate of text32, as then it is only run if text32 changes.

Regards

Malcolm

[Bernd Alheit · Accepted solution]

Why does you multiply with 10?

[malhis18382203]

Text10 is the qty and Text 32 is value the logic is if text32 value goes beyond 602 $ it will remain 602 in the total result.

if Text32 is lower then 602 $ it will multiply with qty and give the result as given in image.

Kindly help to provide the script

Thanks in advance.

[try67]

Use this code as the custom calculation script of the field where you want to display the results:

var text32Value =  Number(this.getField("text32").valueAsString);
if ( text32Value <= 601) {
    event.value = text32Value * 10;
} else {
    event.value = text32Value;
}

[Bernd Alheit]

Why do you multiply with 10?

[try67]

Sorry, I just adjusted the code provided before. I see now it should be a field... Will post an updated version shortly.

[try67]

Fixed version:

var text32Value =  Number(this.getField("text32").valueAsString); 
var text10Value =  Number(this.getField("text10").valueAsString); 
if (text32Value <= 601) { 
    event.value = text32Value * text10Value; 
} else { 
    event.value = text32Value; 
} 

[malhis18382203]

Hi Thanks, But still it is not solving the problem

[try67]

You need to provide more information about what goes wrong...

[malhis18382203]

post insertion of code in form it is not giving the result as it comes as blank

[try67]

Check the JS Console (Ctrl+J) for error messages.

[malhis18382203]

send me your mail ID i will mail you the file as i am completely noob in this

[try67]

[try6767 at gmail.com]

[malhis18382203]

Hi Sent

[malhis18382203]

Thanks it is solved

[malhis18382203]

Text10 is the qty and Text 32 is value the logic is if text32 value goes beyond 602 $ it will remain 602 in the total result.

if Text32 is lower then 602 $ it will multiply with qty and give the result as given in image.

Kindly help to provide the script

Thanks in advance.