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

    Calculations depending on a previous field/loan amount

    Asked by afckredieten on November 05, 2015 at 11:10 AM

    Hello, 

     

    I already posted, and mailed my problem with my car loan calculator twice. Youd made my a perfect working car loan calculator, which a cloned and i'm futher working on it. But i'm still having a big problem.

    https://form.jotform.com/53035203816952

    But, i have looked, and tested a few options, i'm stuck.  In Fact the loan duration has a min numbre of months, and different max number of months depending on the loan amount.

    How can i integrate this option, i've tried with different duration fields and then worked with rules show, field 1 if loand amount is between X and Y. But this doesnt seem to be working. And at the start everything is shown what makes the calculator tool a bit messy.

    So, please could you help me

    this table gives you the wright min and max numbers of months (the min is always the same)

    Loan amount min duration max duration
    25001 3700 24 30
    3701 5000 24 36
    5001 5601 24 36
    5601 7500 24 42
    7501 10000 24 48
    10001 15000 24 60
    15001 20000 24 84
    20001 999999999 24 120
           
           
    Duration: steps off  6 months untill the max duration

     

    The table itself must be hidden, it mus only give the wright min and max validation on the field desired duration

    Thanks for you're help

    field validation custom calculations
  • Profile Image
    JotForm Support

    Answered by david on November 05, 2015 at 01:21 PM

    Hi,

    From the sounds of things, you could use "Update a form field value" conditions.   

    http://www.jotform.com/help/286-How-to-Populate-Field-with-a-Value-from-another-Field

    You could base the updates off of the loan value.  You would need to set your conditions for range of values.

    IF loan amount > 0

    If loan amount < 2500

    Insert 30 into max duration

    Something of that nature.  I am not sure exactly what you are looking for, if you wouldn't mind letting us know how you would like the updates to be made, we can likely help you get it set up properly.

  • Profile Image

    Answered by afckredieten on November 05, 2015 at 02:17 PM

    Well, if the loan amount (leenbedrag) is

    between 2501 an 3700, the max numbre of months is 30

    If the loan amount is btweet 3701 and 5000 € the max duration is 36 months, and so one

    meaning that visitors cant choose more months than the max in the table above, in the duration field.

    so for instance a dropdown, or a spinner, field for loan duration and then the numbers

    24, 30

    24, 36

    24,36,42,

    24 36 42 48

    ... for every loan min and max in the table above

    i would preffer the spinner

    attention, the number must be taken with in the following monthly payement calculation

    I've tried to work with the populate, but for sure i do something wrong, but i cant get it working. Now i tried it again, and i get wrong form when i hit preview button.

    So i would be a happy customer if you could make this for me

     

  • Profile Image

    Answered by afckredieten on November 05, 2015 at 02:19 PM

    What i forgot

    the visitors must be able to choose the months, with the min and max off the table. But also in steps of 6 months. So for 20.000€ they can choose 24 months but also 54/60/6.... with 120 the max

  • Profile Image
    JotForm Support

    Answered by david on November 05, 2015 at 03:35 PM

    For this, you would need to create a specific spinner for each range, then show the appropriate spinner for each range.  The spinner field can be set with a minimum value, maximum value and a stepping amount:

    You would also need to replace your text boxes with number fields.  Your loan amount field "Kostprijs van het voetuig" is a text box so greater than/less than conditions will not work.  Once you have a number field for your loan amount, you can create a condition such as this:

    Then create a new condition for each range of values to show a different spinner that has a different maximum.

    I set up the first few spinner and conditions to show you how it works:

    https://form.jotform.com/53086184079967

    You can clone the form to your own account to inspect the setup further:

    http://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL

  • Profile Image

    Answered by afckredieten on November 05, 2015 at 03:47 PM

    Wait, i translated my form, the form is already made by a collegeau of yours

    https://form.jotformeu.com/53085661448360

    The goal is to calculate the monthly payements, and that part works, with the duration to fill in.

    What you propose is not what i"m looking for.

    In fact when somebody buys a car, 25.000€, an dos a downpayement of 5000€, the loan amount (calculation) will be 20.000€, the duration possibility's will be from 24 months tot 120 months

    but for instance when somebody would pick 140 months, there must be an error that the max is 120.

    When the loand amount is for instance 9000€, the duration max is 48 months, and when the client put 54 in, there need to be an error message.

    Or when working with a dropdown, the choices stops at 48 for the 9000€, of with a spinner the max is 48 and doesnt go futher.

    I hope i made myself clear what i'm looking for. And hoping i can do this in jotforms

     

  • Profile Image

    Answered by afckredieten on November 05, 2015 at 03:49 PM

    the way it works now with textfields, is composed by a collegeau, i only made the totall loan amount at the end of the period, so if he works with textfields he woudl have it's reasons for it

  • Profile Image

    Answered by afckredieten on November 05, 2015 at 03:57 PM

    i cloned you're form proposition

    and i see that the calculation is complety wrong.

    I'm looking for the monthly payements

    AND

    the there are some more rules needed.

    The first is the car age

    1. new

    2. between and 3 and 5 years

    3. older than 5 years.

    This age determines the APR % (needed for the calculation later)

    new is 3.24

    between 3 and 5 years is 5.25%

    and for older than 5 years

    there is a seccond rule, for this option

    the sub rule to determinate the APR is again the loan amount

    Loan amount    
    25001 5000 13,50%  
    5001 999999999 10,50%  

     

    The calculator worked, the monthly payement is correctly calculated.

    Now i would like to integrate the loan duarion rule which depends also on the loan amount for the 3 ages of cars.

    this is the complete logic needed in the tool

    thanks for you're time and assistance

  • Profile Image
    JotForm Support

    Answered by david on November 05, 2015 at 03:59 PM

    That is the same setup I presented.  You would just need to setup the conditions based on the calculation field instead of the number field I added. 

  • Profile Image

    Answered by afckredieten on November 05, 2015 at 04:00 PM

    OK i will try it.

    Thanks

  • Profile Image

    Answered by afckredieten on November 05, 2015 at 04:07 PM

    Is there a way to hide duration 1, 2, 3 and so one. 

     

  • Profile Image

    Answered by afckredieten on November 05, 2015 at 04:15 PM

    A last question, i promise

    For today anyway (-:

    the monthly payement uses the duration normal field for its calculation

    Do i also need to make the same number of "monthly payements" field so i can change everytime the "gewenstelooptijd"=duration in the calculation? and also with a rule somewhere that shows the right calcul. Probably also in the loan amount rules with the 2500 3700 show duration 1, than calcul monthly 1

  • Profile Image
    JotForm Support

    Answered by Mike on November 05, 2015 at 06:26 PM

    I am having hard time understanding the current requirements.

    Are you still working on the min and max numbers of monthly duration (original post), or do you need help with the ARP part now?

    What is the current form link?

    If you need help with the ARP based calculations, I would like to suggest opening a new thread. Please also provide us with a form link in question, so we will be able to properly address everything.

  • Profile Image

    Answered by afckredieten on November 06, 2015 at 02:51 AM

    no i'm still working on the months part.

     

    But my questions is if i have 8 duration spinners ( between 2500 and 3700, and futher up)

    do i need also 8 different monthly payements calculation field, where you see above the formula, because the formula contained the old duration field. So if have now 8 different fields, i suppose i have to have 8 different monthly payement fields, so i can change resp the duration field in the calculation part?  or is there another way to work

  • Profile Image
    JotForm Support

    Answered by Boris on November 06, 2015 at 05:04 AM

    I believe that this is the form that you were working on: http://www.jotformeu.com/form/53064268766363

    The setup is a little confusing, but I have gone ahead and implemented the recommendations of my colleagues. You can see a simplified and edited form here:

    http://form.jotformpro.com/53092038091956

    As you can see, there is no need to have a separate Calculation field for each of the possible "Gewenste looptijd" Spinner fields that hold month values. What I have done is the following:

    1. I have enabled the option on this form to Clear Hidden Field Values > Clear On Being Hidden. (This option is found under Preferences > Advanced Settings.) This allows us to ignore the Spinner fields by simply conditionally hiding them.

    2. I have used a Number field for "Te lenen bedrag", as recommended by my colleagues above. This allows for the Greater than and Less than conditions to work, based on teh value of the Number field.

    3. I have used a Number field for storing "Gewenste looptijd", and I have set up conditions to update this number field with the value of "Gewenste looptijd" spinners.

    This field was also made hidden by clicking on its gear-shaped icon > Hide Field, so that your users can't see this field on the form.

    4. I have updated all your conditions and calculations to use these two Number fields instead, so there is no need to have multiple Form Calculation fields on your form.

    5. I have fixed some of the OR (if ANY match) conditions to be the correct AND (if ALL match) rules.

    I believe you will be able to set conditions further to your liking. Please try out the edited form, and let us know if you need further assistance. Thank you.

  • Profile Image

    Answered by afckredieten on November 06, 2015 at 05:43 AM

    Thanks for all the work you guys already did. Realy helpfull, and apreciated.

    But, when i open you're edited form, or http://form.jotformpro.com/53092038091956 for that matter

    the duration (gewenste looptijd) is gone? so the monthly payement is not calculated?

     

  • Profile Image

    Answered by afckredieten on November 06, 2015 at 06:23 AM

    I given it another look to youre form and explination.

    The point is that you hidden quite a lot. So the duration "gewenste looptijd" is not shown on the public form. That's the point, the visitors need to choose a desired duration, and the possibility's in duration is set by the loan amount. But now the field duration is complety gone on the public part. So what do i need to do to fix this

  • Profile Image

    Answered by afckredieten on November 06, 2015 at 06:56 AM

    sorry, never mind my last two comments, when i cloned youre form, and hit preview the form works.

    So thanks, i'll work on this form to complete the calculator

  • Profile Image
    JotForm Support

    Answered by Jan on November 06, 2015 at 09:34 AM

    I understand, glad to hear that it is working now. Let us know if you encounter a problem and you need our help. Thank you.