How to show data from a spreadsheet to form?

  • Profile Image
    kiriakos83
    Asked on March 11, 2018 at 03: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

  • Profile Image
    Mike_G
    Answered on March 11, 2018 at 05: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.

  • Profile Image
    kiriakos83
    Answered on March 11, 2018 at 06:43 PM
    I would like the customer to complete the quantity in the product he wants


    ...
  • Profile Image
    Kiran
    Answered 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.