- LegalJeffAsked on December 13, 2013 at 10:42 AM
My problem is figuring out how to use equations with multiple fields as the variables. I have created a simple version in google apps https://docs.google.com/spreadsheet/ccc?key=0ArwMnS1q-vhXdEtOd1pEVk1iemYweFpwS0NvM0JOQ0E&usp=sharing but I want to create a more professional form for potential clients so they can determine if they qualify for our funding program.
My first problem is the bonding fee which the multiplyer is not linear, example:
Funding Amount Multiplyer Change in multiplyer / million
500,000,000 .00048 .00000048
250,000,000 .0006 .00000107
25,000,000 .00297 .00000645
My second problem is The "Cash Reserve" is dependent on the "Funding Amount" + "Bond Program" as you can see in the google doc, the math is much easier but how do I get the variables "fields" to work together?
My third is simpler but I haven't figured it out completely (simplified) - the "Equity share" which is dependent on the program only.
any help would be much appreciated....
My Jotform is located at http://form.jotform.co/form/33458242133853
- JotForm SupportTitusNAnswered on December 13, 2013 at 01:22 PM
Thank you for letting us know. We will try and assist you ro resolve this as much as possible.
Please help us understand what you would like the form to do for you:
I understand that you may have an equation that is based on certain variables which the user will enter on the form, for instance, the Funding Amount/Cash Requested and the Bond Program
Lets break down your challenge into sections:
1. Please provide the equation/s you would like the form to calculate, for instance, Bonding fee = Funding Amount x Multiplier, or Cash Reserve = Bond Program + Funding Amount
2. What would you like the form to do with the result of each calculation based on the equations above? (For instance, send the answer to you or the form user, or send the form user to a billing platform etc)
The reason why I ask this is because we can add a calculation field that can be manipulated to to give the output you desire as shown below:
Please let us know how we can help further
- LegalJeffAnswered on December 13, 2013 at 02:01 PM
Thanks Titus for your response, the output would be to the corresponding field the calculation is being preformed in. the end result would be to add three fields "Bond fee" + "Retainer" + "Cash Reserve" and output to the "Cash Requirement" field (not yet created on form).
The Bond fee is the most difficult for me to determine, it's a quadratic equation with three variables: (Y) Value = Funding Amount, (X) Multiplyer which is dependent on (Y), the larger (Y) the small the multiplyer, unfortunately the slope of the multiplyer is not linear otherwise the equation would be y=mX + b. Again refer back to my original post for the sample (Y) value and (X) Multiplyer.
The other problems I would think are a matter of familiarity with JotForm.
Thanks again for any help provided...
- JotForm FounderaytekinAnswered on December 13, 2013 at 04:03 PM
I forwarded your request to our developer who works on this calculation feature. Thanks.
- LegalJeffAnswered on December 17, 2013 at 12:06 PM
Would like to thank you for such a great product, if you can get this form working like I hope you can I will be very thankful, I already share my thoughts of JotForm on my social networks with several business associates already taking advantage of JotForm. I'm hoping your developers and support staff can get this form up and working so I can further impress my associates and social friends...
- JotForm Support ManagerJeanetteAnswered on December 17, 2013 at 01:28 PM
We are very happy hearing your feedback toward our product. We also appreciate you help us to spread the word about us
Hopefully this feature will be implemented soon. You'll get un update on this thread