Import data to spreadsheet widget

  • Profile Image
    Kelley_rkelley
    Asked on February 26, 2021 at 05:55 AM

    Hello,

    is it possible to import data from a csv/excel spreadsheet into the jotforms spreadsheet widget which we are using for a parts order/authorisation form. This would save us having to type everything in twice.

    I would be happy with being able to copy and paste but that only works one cell at a time.

    Is there a better way to have a spreadsheet type format for parts order. or am using the wrong thing?

    New to jotforms so still finding my way around this.

    The attached pic shows an example - what we need is;

    Line 1 Description, Part No, Unit Cost, Qty (calculated subtotal)

    x 70 lines

    Grand Total last line (calculated total of lines 1-70 subtotals )

    hoping for some clever solutions!

    Thank you

    Screenshot
  • Profile Image
    Bojan_J
    Answered on February 26, 2021 at 07:52 AM

    Greetings.

    Unfortunately, it is not possible to import data to the Spreadsheet widget, however, you can upload it to Google Sheets, and then display it in your form using the iFrame widget.

    Let us know if this solution works for you.