nonconformistdoc
Forum Replies Created
-
Forum: Plugins
In reply to: [Calculated Fields Form] Having problems with functionHi, sorry I still cant figure it out,
my fieldform that is calculated is this:
fieldname21=
(function(){
if(fieldname19 == 1){
return 1/(1+exp(-((-0.4499)+(0.8085*fieldname20)-(0.0835*fieldname6)-(1.743*fieldname1))));
}else if(fieldname19 == 2){
return 1/(1+exp(-((-2.5355)+(0.9934*fieldname20)-(0.0651*fieldname6)-(1.136*fieldname1))));
}
})()the fieldform that should if blank, fieldform21 is void, is fieldname6
i tried modifying your equation of
IF( AND(fieldname1,fieldname2), fieldname1/fieldname2, ” )but because i already have an if,if else condition of
if(fieldname19 == 1){
return 1/(1+exp(-((-0.4499)+(0.8085*fieldname20)-(0.0835*fieldname6)-(1.743*fieldname1))));
}else if(fieldname19 == 2){
return 1/(1+exp(-((-2.5355)+(0.9934*fieldname20)-(0.0651*fieldname6)-(1.136*fieldname1))));
}sorry very new
Forum: Plugins
In reply to: [Calculated Fields Form] Having problems with functionif i turn off the dynamic evaluation it still doesnt solve the problem of
null =/= 0i have an “x” field that is not necessary, but feeds into a formula as an addition. Without the “x” field the formula is void, but mathematically it is not because it is just an addition
Forum: Plugins
In reply to: [Calculated Fields Form] Having problems with functioni tried to put in if formfieldx is null, return “Please fill in” but didnt work
Forum: Plugins
In reply to: [Calculated Fields Form] Having problems with functionHi thanks for your fast response. Sorted the 1st problem
zero is a possible entry.
I just dont want the default value to be zero.
Can null and zero be different, not the same value?Forum: Plugins
In reply to: [Calculated Fields Form] Having problems with functioni also used the switch function for fieldform cSBP but no return as well
sorry new to coding here.
Also another question, why does the fieldform cAGE has 0 pre-filled. I want to remove that because that field will be used as input for another calculation and I dont want wrong calculation to happen because of that