Spreadsheet to form no longer work

  • hrlmw
    Asked on October 28, 2020 at 10:26 PM

    Hi support,

    Sorry English isn't my main language. So, I post my problem on this page. https://www.jotform.com/help/442-how-to-use-the-spreadsheet-to-form-widget?if_id=442 (id hrlmw).

    My form https://www.jotform.com/build/202031916491045

    My problem file http://www.mediafire.com/file/986j5nf8lg26yhs/letter.xlsx/file

    Usually the widget will populate data from the excel file and fill my form. Now it's not work and you can try delete and reupload it.

    I'm not sure that your widget has limit maximum size of excel file or not?. Then I try recreate another file with same columns structure like this http://www.mediafire.com/file/0fivzou3cwxxwx7/Book1.XLSX/file , then upload to form and it works.

    Please help and thanks alot,

    Sirapat


    Jotform Thread 2664500 Screenshot
  • Girish JotForm Support
    Replied on October 29, 2020 at 2:38 AM

    I can see that the file contains a number of worksheets with a large number of additional columns.

    The excel file that you upload on the widget should contain the exact form field labels as column titles and should not contain formulae.

    Then the fields will be filled up using the widget.

  • hrlmw
    Replied on October 30, 2020 at 11:27 PM

    This file worked very well with this widget for 4 months with these worksheets and columns until last Monday.

    This's not first time with this widget.

    What happened with my file and this widget? And I read on your forums, not only me that has this problem on the same time.

    Why?

  • roneet
    Replied on October 30, 2020 at 11:55 PM

    We are sorry for the inconvenience this has caused.

    We were experiencing a temporary issue on Oct 29th which was solved in some time on that day only. The users also confirmed.

    I see there are 2 erroneous columns in the Excel sheet.

    1604116168 5f9cdec86fba5  Screenshot 10

    Also, you should have only a single tab on the Sheet. Delete all the extra tabs on the form:

    1604116460 5f9cdfec4d979  Screenshot 21

    Then re-upload the Sheet on the form.

    Please give it a try and let us know how it goes.

    Thanks.