Spreadsheet to form widget: Unresponsive

  • Profile Image
    Chris Allen
    Asked on November 01, 2022 at 09: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.



    This is a re-post of a comment on How to Use the Spreadsheet to Form Widget

  • Profile Image
    Kris
    Answered on November 02, 2022 at 01: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

    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.