How can I set a calculation for my application form?

  • kmattlage
    Asked on January 6, 2018 at 1:02 AM

    I'm trying to do some calculations on a grant application form, where I want it to calculate if the applicant has enough in matching funds (33%). How would the formula be entered?

    On the form, the applicant is required to fill in these numbers: Requested Grant Funds, Matching Funds, Total Project Cost

    Calculation:

    Total Project Cost x .33 = Y

    Then I would like if "Y" equals more than the number they filled out for Matching Funds, a message pops up that reads: You do not have the required amount of Matching Funds for this project. Please reduce your Requested Grant Funds or increase your Matching Funds.

  • liyam
    Replied on January 6, 2018 at 6:48 AM

    Hello,

    There are two methods to achieve this:

    1) Using the calculation method via conditions - Here, you will set your formula using the fields on your form, and you can also set your constant numeric values like that of your 33% rate. You can check this guide for more information: https://www.jotform.com/help/414-Calculate-Values-in-the-Input-Table-Through-Condition

    2) Using the form calculation widget - Using this widget, it has the same functionality like that of the calculation with using conditions, but with this you can pass the values to a payment integration field. Please check this guide for more information: https://www.jotform.com/help/259-How-to-Perform-Form-Calculation-Using-a-Widget

    In addition, with regard to the matching of the result, you can display a text content to display the result from the value entered. You can make this happen by using the show/hide condition. This guide can walk you through with using this condition: https://www.jotform.com/help/316-How-to-Show-or-Hide-Fields-Base-on-User-s-Answer

    If you need assistance over this matter, please let us know.

    Thanks.