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?

  • Profile Image
    Gollub
    Asked on January 05, 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_

    1641443088_61d66f10c7143_


    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.)

  • Profile Image
    Mary_F
    Answered on January 06, 2022 at 04: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.