Spreadsheet to Form Widget: Not Pulling Information

  • Profile Image
    autodealersonly
    Asked on October 26, 2020 at 10:16 AM

    We use JotForm as a way to register customers for sale events. We attach a spreadsheet to the form and when you put in the 5 digit PIN code for that specific customer and click the auto populate button it says the form has been filled, but there's no information there. This seems to have just happened and has never happened before. What could the problem be?

  • Profile Image
    Jovanne_A
    Answered on October 26, 2020 at 12:07 PM

    Hi, thank you for contacting JotForm support.

    I have cloned your form, upload a test spreadsheet, and it works fine. 

    1603728106_5f96f2ea16fec_7.png

    Please make sure the value you are inputting in the Pin Code field matches the form Access code column. We have a more detailed guide here: How-to-Use-the-Spreadsheet-to-Form-Widget.

    Please give it a try and if the issue persists, kindly provide us a screenshot of the excel file so we can further check.

    We look forward to your response. Thank you.