What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Something went wrong with loan simulator

    Asked by afckredieten on January 27, 2016 at 05:50 AM

    Hello,

    I already asked a lot of question for this calculation tool i'm building. https://form.jotformeu.com/60262108035343

    I've made an englisch version (the important fields are translated)

    My problem

    1. the monthly payement calculation, is not correct

    2. the total amount is not coreect calculated.

    This becouse the hidden field duration, which was a tip from one of you, to make the calculation part in th monthly field easier. Instead of using all the different duration fields, make a workaround and let the duration be filled with the choosen duration, once its filed than we can use only that field for making our calculation.

    But, for some reaso its not working.

    When i make the unhide the duration field, i see that for instance when i choose 36 months, in that field shows up 390 number, and that that number is used to calculated the amortization, and total cost. Off course that is not the way to work. So

    Why is the hidden field, filled with a number that doesn't correspond with the choosen duration?

    I think that when we could resolve this problem my simulator will work

    Could you check why the duration field gives a number that doesnt correspond the choosen duration

     

     

    problem hidden workaround check
  • Profile Image

    Answered by victor on January 27, 2016 at 10:02 AM

    I have just reviewed your form and noticed that you have a condition that is adding all the duration fields together. Since all your duration fields have a default value and when the amount field is filled, the total duration will never be the same as the individual fields.

    Since you will only be showing one duration field at a time, you can create a new condition. Depending on the amount enter, it should copy only that duration field and not add all of them

     

    Please let us know if you require further assistance.

  • Profile Image

    Answered by afckredieten on January 27, 2016 at 11:21 AM

    Sorry, but this way of working was proposed by a collegeau of yours.

    But never mind in meantime i think i found the solution, if i marke in advanced option for the calculated field the " Ignore Hidden fields." option  (the one with alle the durations in it)  than i get the months correct in the field and the calculation is correct.

    Thanks for an alternative way,

    Kim

  • Profile Image

    Answered by victor on January 27, 2016 at 01:17 PM

    Sorry for the misunderstanding. I am also glad you found a workaround to your issue. 

    If you have any other question or issue, please let us know and we will be glad to help the best we can.