- kmattlageAsked on January 06, 2018 at 01: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
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.
This is a re-post of a comment on How to Perform Form Calculation Using a Widget
- JotForm SupportliyamAnswered on January 06, 2018 at 06:48 AM
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.