I have the formula for a loan caclulator in excel and I'm trying to build it out in Jotform so clients can calculate their loans. Can someone help me?

  • Gollub
    Asked on January 5, 2022 at 11:26 PM

    I'm trying to build all this out into a "sliders with calculated result" but I'm having trouble doing it. I don't care how it looks or if there needs to be multiple tiers of calculations, etc. I just need some help actually configuring everything.


    1641443064 61d66ef8c55f2  Screenshot 10

    1641443088 61d66f10c7143  Screenshot 21


    Edit:

    There are two approval amounts: The first approval amount is purely based off monthly income and daily balance and the second one factors in the number of open positions (loans) that the client has. (In Excel, I just hide the first one so people only see the second one.)

  • Mary JotForm Support
    Replied on January 6, 2022 at 4:19 AM

    Hi Gollub,

    Thank you for reaching out.

    You would need to use the Calculation widget to make the calculations.

     Please refer to this guide for more details: How-to-Perform-Form-Calculation-Using-a-Widget.

    You may also use conditions to calculate and pass values from one field to another. Here's a guide: How-to-Insert-Text-or-Calculation-into-a-Field-Using-Conditional-Logic.

    Please let us know how it goes.