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

    Can I make calculations?

    Asked by Ariel Leon on September 02, 2013 at 05:43 PM

    Hi;

    I've been looking for form builder. There are so many in the marked. You are the number one on the list.

    I want to know if I can get what I need building my form with JotForm. if yes I will immediately buy a subscription.

    I know you have a lot of templates and very good design tools, but besides that I will need to perform some calculation.

    I will try to do my best in order to you undestand me well.

    The master page must have a page named: "Rates Calculation," containing a form where the customer will type four numerical values: 

    weigh(lbs), deep(inch), width(inch), and height(inch).

    and an option from a drop box(with 16 options).

    Using this five values I need to perform some logical process and calculation. I will try to explain using a basic programming code. The syntax is no important in this case I just want to explain you in another way

     

    variables:

    int Wg  //Weigh in pounds. Value typed in a numeric field by customer

    int D //Deep in inch. Value typed in a numeric field by customer

    int W //Width in inch. Value typed in a numeric field by customer

    int H //Height in inch. Value typed in a numeric field by customer

    int index // Index number from drop box. Selected choice by customer in the drop box. Location

    double Pf //Final price 

    double Pv //Price per volume 

    double Pw //Price per weigh

     

    Program:

    Pw = Wg x 1.65 // Price according to the weigh

    Pv = D x W x H/1728 // Price according to the volume.

    if Pv>Pw  // The bigger price is the important

    Pf = Pv

    else

    Pf = Pw

    end if

    Pf = Pf + Table(Pw,index) // Add to the final price handling fees that depend on the weigh and location

     

     

    The value of Pf (final price) must be shown to customer in any way. Can be as text.

    Table is a 17x100 table with fixed values. I also need to know if I can host this table with you or build with your tools. I can do this table using Microsoft Excel for example.

    This table should not be visible for customer, this main function is as a reference.

    I just need a way to reach my goals.

     

    I have worked hard in order to explain you about my needs, but if I would not reach my goal please just let me know.

     

    Thanks

     

    Ariel Leon

    calculations Form Builder excel
  • Profile Image
    JotForm Support

    Answered by Tasha on September 02, 2013 at 06:32 PM

    Hi Ariel,

    Performing the calculations that you outlined above is possible with jotform if you download the source code for your form and add additional scripts that you would need to perform your calculations. For more information on how to get the source code please review this link.

    Please let us know if you have any further questions.

    Thanks.

  • Profile Image

    Answered by mihkelkohava on September 05, 2015 at 11:35 AM

    I have same need. Looking forward for that functionality in future editions.
  • Profile Image
    JotForm Support

    Answered by jonathan on September 05, 2015 at 04:29 PM

    @ mihkelkohava

    We will resolve your question separately here http://www.jotform.com/answers/655682