jowelboy

Thanks

That works a charm!
Thanks for the help.

Final question on this issue:

Currently there is a ‘insert before’ (a ￡ sign) and ‘insert after’ is the text ‘per month’.
Obviously when the calculation returns the text ‘You can’t borrow that much’ I’m actually getting: ‘￡You can’t borrow that much permonth’.

In the calculation can I add something like:
return “￡” & PREC…. & “per month” rather than use the insert before / after?
If so, what would the synatax be?
Thanks

Thought it might be the apostrophe in the text ‘can’t’ but without it, it still isn’t working.

Thanks vivanco and Codepeople – I foolishly copy & pasted the original code with the spelling mistake.
So I added the extra ‘return’ as suggested. Now the calculation is showing correctly up to the point where the text has to be displayed and nothing is shown.
here’s the link: https://biznizcash.hedjam.net/limited-company-application/
here’s the screenshot showing no text: https://dl.dropboxusercontent.com/u/4556853/calc-not-displaying.png
here’s the code:

[ Moderator note: Code fixed, please wrap code in backticks or use the code button. ]

(function(){

if(fieldname11 > fieldname16/12 ){
return "You can't borrow this that much";
}
else
{
return prec(IF(IN(fieldname12,[3,4,5]),fieldname11*0.36,IF(IN(fieldname12,[6,7,8]),fieldname11*0.19,IF(IN(fieldname12,[9,10,11]),fieldname11*0.1333,IF(IN(fieldname12,[12,13,14,15,16,17]),fieldname11*0.105,IF(IN(fieldname12,[18,19,20,21,22,23]),fieldname11*0.0767,IF(IN(fieldname12,[24]),fieldname11*0.00625)))))),2);
}
})()

HELP???!!

Oh, this is so frustrating.

Take a look at my screenshot: https://dl.dropboxusercontent.com/u/4556853/calculation-not-working.png

No matter whether the figure is above or below the limit, the calculation field does NOT display anything!!

Here’s the code that’s in the Monthly repayments field:

(function(){

if(fieldname11 > fieldname16/12 ){
reutrn “You can’t borrow this that much”;
}
else
{
prec(IF(IN(fieldname12,[3,4,5]),fieldname11*0.36,IF(IN(fieldname12,[6,7,8]),fieldname11*0.19,IF(IN(fieldname12,[9,10,11]),fieldname11*0.1333,IF(IN(fieldname12,[12,13,14,15,16,17]),fieldname11*0.105,IF(IN(fieldname12,[18,19,20,21,22,23]),fieldname11*0.0767,IF(IN(fieldname12,[24]),fieldname11*0.00625)))))),2)
}
})()

I’ve spent hours on this, why isn’t it working??!!
Thanks

I’ve test this, but rather than an alert, can the message replace the resulting calculation?
So up to the point where fieldname11 is not > than fieldname216/12, I want it to display the result of the calculation, but over that point, to display the text ‘You can’t borrow this that much’

Is this possible?

Thanks for this, however the Tip has confused me.

So in a new calculation field (say, fieldname20) I put in the calculation with the alert: “if(fieldname11 > fieldname16/12 ) alert( ‘Your message here’ );”

But does that get incorporated somewhere else?
Thanks

AMAZING! This is brilliant. Thank you very much

BEAUTIFUL!

This works very well thank you for a very fast turn-around of the problem

YESS!! Thank you this works fantastically!

Thanks for a very quick response.

Morning,

Thanks. They look really good. However there is one problem with the sliders – the number updates AFTER you release the mouse which means that if you are holding the hanldle of the sliders over, say, 10. When you let go it updates to 11 or 9 (where the slider is ACTUALLY held at).
This can be seen very clearly if you move to the very end of the slider – say the maximum was 20. While you hold the mouse over the end of the slider it reads ’19’. When you release the mouse it then reads 20.
In reality this is extremely annoying when you are trying to select the correct number as the user is constantly having to nudge up and down.
Can this be corrected?
Thanks

I too wish to combine shortcodes:
[qa searchpos=top cat=installation]

Additionally, I would like to show JUST the search and not the categories or questions at all. Is this also possible?
Thanks