What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Using Equations In Form Fields

    Asked by LegalJeff 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

    10,000,000                     .0040

    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

    Page URL:
    http://form.jotform.co/form/33458242133853

    JotForm problem multiple fields professional
  • Profile Image
    JotForm Support

    Answered by TitusN on December 13, 2013 at 01:22 PM

    Hello, 

    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

  • Profile Image

    Answered by LegalJeff 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...

  • Profile Image
    JotForm Founder

    Answered by aytekin on December 13, 2013 at 04:03 PM

    I forwarded your request to our developer who works on this calculation feature. Thanks. 

  • Profile Image

    Answered by LegalJeff on December 17, 2013 at 12:06 PM

    Aytekin,

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

    Thanks,

    Jeff Hunter

  • Profile Image
    JotForm Support Manager

    Answered by Jeanette on December 17, 2013 at 01:28 PM

    Hello Jeff

    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

    Cheers!