Creating an order form from an excel sheet

  • Profile Image
    smh3528
    Asked 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
    jonathan
    Answered 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