Error when using spreadsheet to form widget.

  • Teiyonab
    Asked on January 22, 2020 at 9:59 PM

    Hello, I'm currently using the Spreadsheet to form widget. I keep receiving this error message, "There are errors on the form. Please fix them before continuing". Please assist.

  • Jed_C
    Replied on January 22, 2020 at 11:57 PM

    Upon checking this form https://www.jotform.com/form/200214564846150, it shows that you have uploaded a .doc file and not a xls format.

    1579755339The Easiest Online Form Builde Screenshot 10

    The widget requires an .xls, .xlsx, or even a .csv file and it won't accept any other format. Please upload the required file format and test again. 

    Guide: https://www.jotform.com/help/442-How-to-Use-the-Spreadsheet-to-Form-Widget

  • Teiyonab
    Replied on January 23, 2020 at 10:50 AM
    Hello,
    Thank you for your response. Unfortunately, I’m still having the same issue. I’ve changed the formatting of the spreadsheet, so it’s no longer a .doc form. Once saved, my form is continuing to not populate the necessary field that is connected to the spreadsheet to form document. Below I’ve copied the spreadsheet to form widget and my conditions for that widget.
    [cid:image001.jpg@01D5D1D7.EB3EE880][cid:image003.jpg@01D5D1D7.EB3EE880]
    Best,
    Teiyona Blackwell
    Manager, Program Operations
    [Logo]
    email: teiyona@good360.org
    phone: 703.299.7526
    675 N Washington St. Suite 330 | Alexandria, VA 22314
    [Facebook icon] [Twitter icon] [Youtube icon] [LinkedIn icon] [Instagram icon]
    www.good360.org
    ...
  • Richie JotForm Support
    Replied on January 23, 2020 at 12:14 PM

    Unfortunately, we cannot view the screenshot your have shared.

    To post a screenshot, kindly follow this guide:How-to-add-screenshots-images-to-questions-to-the-support-forum

    I would suggest you use the .xlsx extension for your spreadsheet.

    Let us know how it goes.