How to show data from a spreadsheet to form?

  • kiriakos83
    Asked on March 11, 2018 at 3:45 PM

    there is an application that I could pass an archive example of a price list in a spreadsheet and my client could order but in the file I would be interested to put only quantities

    Jotform Thread 1411676 Screenshot
  • Mike_G JotForm Support
    Replied on March 11, 2018 at 5:27 PM

    To my understanding, you are trying to show in the form the data from a spreadsheet, is that correct?

    If that is the case, I suggest that you add in your form the Spreadsheet to Form widget.

    Here's a guide that you may use as a reference when using the widget — How-to-Use-the-Spreadsheet-to-Form-Widget

    If, in any case, I have misunderstood your concern, please do not hesitate to let us know and give us more details.

  • kiriakos83
    Replied on March 11, 2018 at 6:43 PM
    I would like the customer to complete the quantity in the product he wants


    ...
  • Kiran Support Team Lead
    Replied on March 11, 2018 at 10:46 PM

    The Spreadsheet to Form widget should work if there is only one product since it requires a unique code to be entered. If you want to enable the user to enter only the quantity while displaying the products on the form, you may consider using Spreadsheet widget on the form. Alternatively, you may also have separate fields to display the products and have the user to enter the quantity to perform calculation manually by following the guide below:

    https://www.jotform.com/help/259-How-to-Perform-Form-Calculation-Using-a-Widget

    Hope this information helps. Please give it a try and let us know if you need any further assistance. We will be happy to help.