arnab28
Forum Replies Created
-
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 Sir,
how I got a value like $25.50?
my calculation I received value like $25.5 or 0.00Hello 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?
https://bsbtest.assiduusinc.com/testing2/
this is my form. May i know which link is talking about?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 “”?
I am using PREC(IF(fieldname187==0, Unknown, fieldname187),2) code in a calculated field. but I am getting a result always 0 but I want an answer Unknown. help me where I am doing wrong?
I want to use this formula in the calculated field. is it possible to use?
Can you help me how this formula I can use this cff plugin?
IF(fieldname1=0,0,1) – this is an excel formul.
How can I use this formula here?Can you help me why this Cff form not submitted. full up all the details after that form is not submitted, please help me what is the issue.
https://bsbtest.assiduusinc.com/testing2/Is like that i capture but calculated field value showing like “\”Test facility\””
3)How to change mandatory fill/error input alert system to only appear after submission.Please answer my other two questions?
Hello Sir
I have a three-question here
1) how to create a customize the alert message for some of the fileld.
2)How to capture Text Area filed data in a calculated field. I capture text data but it’s showing like “\”Test facility\”” .
3)How to change mandatory fill/error input alert system to only appear after submission.Thanks for your code. this code use for read only show.
i used this code
(function(){
var f_a = getField(fieldname81|n).jQueryRef().find(‘input’),
f_b = getField(fieldname82|n).jQueryRef().find(‘input’),
f_c = getField(fieldname83|n).jQueryRef().find(‘input’);
f_d = getField(fieldname91|n).jQueryRef().find(‘input’),
f_e = getField(fieldname92|n).jQueryRef().find(‘input’),
f_f = getField(fieldname93|n).jQueryRef().find(‘input’);f_a.prop(‘readonly’, true);
f_b.prop(‘readonly’, true);
f_c.prop(‘readonly’, true);
f_d.prop(‘readonly’, true);
f_e.prop(‘readonly’, true);
f_f.prop(‘readonly’, true);
if(IN(1, fieldname71)) f_a.prop(‘readonly’, false);
if(IN(2, fieldname72)) f_b.prop(‘readonly’, false);
if(IN(3, fieldname73)) f_c.prop(‘readonly’, false);
})()i want like when i enter value in Field(71,72,73) then read-only will be disabled.like
if i enter the value in filed 71 then field (81 and 91) field will be disable the readonly other with it will be enable readly always1)i am using this jquery code for when user check into checkboxes then other filed is disapper on read only. this i am using for check box only .
to use this code
<script>
jQuery(document).on(‘change’, ‘[id*=”fieldname93_1_cb0″]’, function(){
var readonly = !this.checked;
jQuery(‘[id*=”fieldname82_1″]’).prop(‘readonly’, readonly);
});
</script>
2)but now I need when the user enters some value then other fields disappear read-only.
can you help me with which code I need to change to work on my 2nd question?I am using the three number field. I want the sum of three input values adds to 100.
if user enters three filed value below 100 or up 100 then the user shows an alert like (“this three filed doe’s not added 100”)