Help

Thanks for this I got the correct answer but the output is showing like “”Unknown”” this. Can you tell me why I am getting this output with this “”?

Hello @arnab28

I cannot sure what is happening with your form if you don’t include the link to the page.

Best regards.

https://bsbtest.assiduusinc.com/testing2/
this is my form. May i know which link is talking about?

Hello @arnab28

I’m sorry, but I cannot help you if you decide ignoring my recommendations. In multiple entries I explained to you, that you cannot duplicate the input tags with the same names and ids into the “HTML Content” field because you are generating an ambiguity. The plugin cannot determine if using the input tag inserted by the field, or the input tag you have entered with the same name and id into the “HTML Content” field (fieldname294). Once you fix the ambiguity, if the issue persists, do not hesitate to contact me again to check your form.

Best regards.

Hello sir,

i am crete a jquery code
$(document).ready(function() {

sum();
$(“#fieldname71_1, #fieldname72_1,#fieldname73_1”).on(“keydown keyup”, function() {
sum();
});
});

function sum() {
var fieldname71_1 = document.getElementById(‘fieldname71_1’).value;
var fieldname72_1 = document.getElementById(‘fieldname72_1’).value;
var fieldname73_1 = document.getElementById(‘fieldname73_1’).value;
var result = parseInt(fieldname71_1) + parseInt(fieldname72_1) ;

if( result >100){
document.getElementById(‘sum’).innerHTML=”greater than 100″;
}
else if( result<100){
document.getElementById(‘sum’).innerHTML=”less than 100″;
}
else{
document.getElementById(‘sum’).innerHTML=””;
}

var result2 = parseInt(fieldname71_1) + parseInt(fieldname72_1) + parseInt(fieldname73_1);

if (result2){

if( result2 >100){
document.getElementById(‘sum’).innerHTML=”greater than 100″;
}
else if( result2 <100){
document.getElementById(‘sum’).innerHTML=”less than 100″;
}
else{
document.getElementById(‘sum’).innerHTML=”contact hma team”;
}

}

}
</script>

but when I am using this code, i am facing an issue. help me where i have done a mistake?

Hello @arnab28

The code you sent me does not use our plugin. You have emulated the process of the plugin with jQuery. We can help you if you use the plugin.

For example, you can insert a calculated field in the form (you can hide it by ticking a checkbox in its settings) with the equation:

(function(){
  var result = SUM(fieldname71,fieldname72),
    result2 = SUM(result,fieldname73);
	
  if(result2)
  {
    if (100<result2) jQuery('#sum').html('greater than 100');
    else if (result2<100) jQuery('#sum').html('less than 100');
    else jQuery('#sum').html('contact hma team');		
  }
  else
  {
    if (100<result) jQuery('#sum').html('greater than 100');
    else if (result<100) jQuery('#sum').html('less than 100');
    else jQuery('#sum').html('');		
  }
})()

Hello Sir,

how I got a value like $25.50?
my calculation I received value like $25.5 or 0.00

Hello @arnab28

Use the PREC operation as the outermost operation in the equation. PREC(X, Y) returns the number X with Y decimal places. In your case, you should use the PREC operation with the number 2 as the second parameter.

Best regards.

Hello sir.

I am using this equation IF(fieldname418==0, ‘Unknown’, PREC(fieldname418,2)).
its works fine but some of the calculation filed 418 has value, when i get value in filed418 then the value show like $478.14 other equation is shown unknow. but when i use $ symbol in field settings then if my feild418 value is 0 its showing like $Unknown.
How to remove $ before unknown only.

Hello @arnab28

In this case, you can include the currency symbol as part of the equation instead of the field’s settings:

IF(fieldname418==0, 'Unknown', '$'+PREC(fieldname418,2))

Best regards.

Hello Sir,

I got a result is $-1,323.72 but I want to get a value like -$1,323.72.

How can i make that?

Hello @arnab28

The currency symbol would be in front the result. If you want a different behavior, you must to implement it as part of the equation, similar to:

IF(fieldname418==0, 'Unknown', IF(fieldname418<0, '-', '')'$'+PREC(ABS(fieldname418),2))

Best regards.

I am not using any condition. in pdf I show this value. I get the value like $-1,323.72 format, But I want this value like -$1,323.72 format.
Note – It’s not applied for one particular condition

May i know why some of number filed data show in the excel sheet after form submission?

Some of Text AreaField Label and some of number field doe’s not shown value in excel sheet.

Hi! We’d like to help but we can’t reply about that in this forum. We are not allowed to support any customers in these forums.

For pro or commercial product support please contact us directly on our site. This includes any pre-sales topics as well.

Commercial products are not supported in these forums. We will happily answer this and any other questions you can have on our own site.

Thank you.