Creating an order form from an excel sheet

  • smh3528
    Asked on April 6, 2017 at 3: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! 

  • jonathan
    Replied on April 6, 2017 at 3: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.

    Creating an order form from an excel sheet Image 1 Screenshot 20

     

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

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