Spreadsheet to form widget: Unresponsive

  • Chris Allen
    Asked on November 1, 2022 at 9:13 PM

    I am trying to use this widget. However, I can not get it to work for me. I have uploaded a .xlxs, an xls and a csv file. None seem to work.
    I have my Unique code in column a with headings in row 1. My unique code is labeled Registration Number. ALL the headings match the form.
    I have marked "Autofill by condition" as yes.
    It doesn't fill the fields from the form I uploaded no matter which format I have the form in.
    Please HELP me.

  • Kris JotForm Support
    Replied on November 2, 2022 at 1:43 AM

    Hello Chris,

    Thanks for reaching out Jotform. We’re sorry if you’re having trouble using Spreadsheet to widget form. I’ll do my best to help you out.

    I created a demo on a sample form on how the Spreadsheet to Form widget works and it works the way is used to. Check out the sample on the screencast below:

    1667367580 6362029c34dfc 2022 11 02 13 3 Screenshot 10

    If you are doing or following what is on the video but still having issues, can you share with us the Excel file that you want to upload? You can save it to GDrive or Dropbox and make sure to set it to the public before sharing the link to access it. We will try to upload it on our end to see if we can replicate the issue and provide you with a solution to this.

    I cleared the cache of your form on our backend system for additional precautions and this fixed glitches as well. You can also perform a clear cache of your forms on your end by following the guide from this link

    Let us know if there’s anything else we can do for you.