Output unique text to an HTML field based on result of a calc

Also, check your e-mail please. I would like to get an hour of your time to work through this calculation fully as it’s going to be a bit more complex.

Hello,

You simply need something similar to:

(function(){
var values = [fieldname2,fieldname6,fieldname73,fieldname321,fieldname325,fieldname74],
total = 0,
counter = 0,
result, letter;

for(var i in values)
{
if(values[i]) counter++;
total += values[i];
}
result = PREC((counter)?total/counter:0, 1);
if( 90 < result ) letter = "A+";
else letter "A";
jQuery('.result').html( letter );
return letter;
})()

Best regards.

Hmm, that looks fine to me but it’s not outputting the value. The calculated field should output the (letter) value “A+” or “A” depending on what the value of (result) is, correct?

result is working correctly, but something isn’t working when converting it to letter.

Hello,

I’m sorry, I’ve a typo in the code I sent you previously, the assignment symbol in the “else” statement:

(function(){
var values = [fieldname2,fieldname6,fieldname73,fieldname321,fieldname325,fieldname74],
total = 0,
counter = 0,
result, letter;

for(var i in values)
{
if(values[i]) counter++;
total += values[i];
}
result = PREC((counter)?total/counter:0, 1);
if( 90 < result ) letter = "A+";
else letter = "A";
jQuery('.result').html( letter );
return letter;
})()

Best regards.

I’m a bit embarrassed I couldn’t figure that out for myself. Code works. Thank you.

Now for the last step. I need to hide the calculated field from my form while still displaying the output in my e-mail. Currently when I hide my calculated form from the page, the e-mail will not pick it up.

I am outputting it to an HTML field to display on my form, but you cannot display those in an e-mail. I don’t think there’s a way to output this value to any other field that will display and also look nice.

So the only thing I can assume is that we need to somehow hide the calculated field without actually hiding it.

That is unless you can remove the border around a calculated field and format it like an HTML field. In that case I will use the calculated field for everything.

• This reply was modified 8 years, 1 month ago by chadtesting.
• This reply was modified 8 years, 1 month ago by chadtesting.

Hello,

You simply should tick the property: “Hide Field From Public Page” in the calculated field, and the calculated field should not be a dependent field.

Best regards.

Oh wow, it does work. My apologies, I thought if I hid the calculated field from the public page that the it wouldn’t show up in my e-mail.

It turns out that it does. Thanks!

• This reply was modified 8 years, 1 month ago by chadtesting.