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

    Looking for the best options or widgets to create an online version of the attached image

    Asked by Calikids50 on April 20, 2017 at 01:16 PM

    I am trying to create an online version of the attached and post the data to our mysql database.

    Looking for the best options or widgets to get this done

  • Profile Image
    JotForm Support

    Answered by Kevin_G on April 20, 2017 at 03:39 PM

    You could use some fields to achieve a layout similar to the one on your image, but it would require a bit of modification in the style to achieve an exact layout. 

    However, you could do the following to start building your form, first you could request the "Sold To" and "Ship To" info through a text area field (Long Text Entry in JotForm v4 builder): 

    You could then display them inline by following this guide: https://www.jotform.com/help/90-Form-Field-Positioning 

    For the next info you could use the Configurable List widget since it allows to have multiple fields already inline and add rows if needed: https://widgets.jotform.com/app/configurable_list 

    Although you could also use basic fields and display them inline following the guide provided above. 

    Now, for the main table you have on your form where you have quantity and price, you could use the Input Table, it will allow you to calculate a sub total in each row with calculations based on conditions. 

    To perform the calculation you will need to use the "Update / Calculate Field" condition: 

    This condition will allow you to select the fields from the input table that you need involved in the calculation as well as select the field where the result should be inserted to. 

    While setting the condition click on the add field and select the matrix field (Input Table), once there select the fields you need involved in the calculation: 

    Once you have  performed the calculation you need to select the field of the Input Table where the result will be added to: 

    This way you will have a sub total calculated for each line in the Input Table, finally to get a total you could use the Form Calculation widget, it will also allow you to get fields from the Input Table. 

    https://widgets.jotform.com/widget/calculation 

    Here are also some related guides that will help you: 

    How-to-Perform-Form-Calculation-in-the-Matrix-Field

    How-to-Perform-Form-Calculation-Using-a-Widget

    How-to-Add-a-Widget-to-your-Form

    Please, give it a try and let us know if you have any question.