Unique code - Spreadsheet to form widget

  • Skateparktour
    Asked on June 28, 2020 at 2:22 PM

    I have set Column A as my unique code column. Each code is a sequential number, formatted as a number in excel. When I enter text to lookup and fill fields, I get "unknown access code".



    Jotform Thread 2417057 Screenshot
  • Mike_G JotForm Support
    Replied on June 28, 2020 at 3:17 PM

    What you would need to enter in the widget is the unique code under the Unique Code column on the Excel file you uploaded in it. Based on the screenshot you shared you have entered a name rather than a code, which is a sequential number as you also mentioned.

    For more information on how you can set up the widget, please refer to this guide.

    How-to-Use-the-Spreadsheet-to-Form-Widget

    Feel free to let us know if you need any further assistance.