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

    Creating an order form from an excel sheet

    Asked by smh3528 on April 06, 2017 at 03:18 PM

    Hello - I would like to make an order form - its for a wholesale nursery that has up dated long invenotry lists - is there an easy way to insert the list and the price into a form so customers can select the item and quanity ?  Of will I have to insert all the data each time ?

     

    it will be an a list that has the name, item code, price and they insert the quanity for each othe their order and submit -  

     

    Thank you!  

  • Profile Image
    JotForm Support

    Answered by jonathan on April 06, 2017 at 03:52 PM

    You will have to create the list manually into your form. There is no means to import the list from your Excel sheet into the form to have the items/data available in the order form.

    You can use the Matrix table field to create your spreadsheet like items list into the form.

     

    Using the Matrix table you can create custom calculations using the quantity input.

    User guide: Calculate-Values-in-the-Input-Table-Through-Condition