Err… sorry i didn’t understand your problem, do you want a field that if they put more that the maximum amount it uses the maximum amount and if it is lees than the maximum amount it uses the actual amount submitted?
Sorry, I want user amount should compare with $2000 if the it is low then show the actual lower figure but if the amount is higher than $2000 then figure should show only $2000.
During my research I found a link in Google at https://goo.gl/Pkoq1R
Here, if I put Gross income $3000 then INCOME TOTAL AMOUNT shows $2770.50 BUT I want it should show only $2000 because $2770.50 is is higher than $2000.
BUT at the same time if I put gross income $2000 then INCOME TOTAL AMOUNT shows $1847 that will not change because $1847 is lower than $2000.
I don’t know what form they are using but its first three inputs (Income, FICA and Income total) will work for my model of form.
So how to configure via Formula Builder.
Ok, so if i understand correctly you will have two fields ‘Gross Income’ and ‘Income Total Amount’
Gross Income is going to be an editable field that your user is going to fill and income total is going to be a either 2000 or the same as ‘Gross Income’ whatever is less. Am i right?
If so in your ‘Income Total Amount’ field should use this formula:
Math.min([Gross Income], 2000)
Yes, you are right.
Getting Syntax Error when I use Math.min([Gross Income], 2000) OR RNFRound Math.min([Gross Income], 2000) in the Formula Builder.
Yes sorry for that, the validator doesn’t understand that Math.min, please try to execute the formula and see if it works. If it is still not working please let me know!
What formula I should use?
something like this:
Math.min([Gross Income], 2000) OR RNFRound Math.min([Gross Income], 2000)
Instead of [Gross Income] you should place the field that you want to use there.
Regards!
Used RNFRound Math.min(Gross Income, 2000)
Getting error “unexpected identifier”
Do you get that error when you execute the form?
Input field shows undefined
could you send me a link to your form please?
I have no problem but I will ask from the client first. Will update you soon.
@edgarrojas Thanks for your help… it works now by using Math.min(Gross Income, 2000)
May be spacing problem my end.
THANKS FOR YOUR TIME & GREAT HELP.
Ah great!
You are welcome =), let me know if you have any other issue or question.
Regards!
One small question…how can I add $ (dollar) sign in the amount input fields?
