Spreadsheet to form widget is returning an error

  • Profile Image
    nituema
    Asked on March 11, 2019 at 11:58 AM

    1st - I am having problems with the extension "Spreadsheet to form":

    the data is not updated in PREVIEW.

    2º- When using "UNIQUEID" column "AO" returns the following error:

    -Internal error: Access code column must point to a single cell only.

    NOTE: The values are not the same.


    Was there an update? Already works with google spreadsheet?

  • Profile Image
    Richie_P
    Answered on March 11, 2019 at 02:08 PM

    Do note that you can only have 1 column to  access the Unique Code.

    Currently, you have added AO as the columns.

    Kindly change it to A or O column in which the Access code data is found.

    For more information, you may check this guide:https://www.jotform.com/help/442-How-to-Use-the-Spreadsheet-to-Form-Widget

    Please give it a try and let us know if the issue still remains.

  • Profile Image
    nituema
    Answered on March 12, 2019 at 08:53 AM
    The column is "AO", works from "A"-"Z", but not from "AA" - "ZZ"

    1552395027Screenshot_3.jpg

  • Profile Image
    Richie_P
    Answered on March 12, 2019 at 10:27 AM

    I have tested my sample form and Column with double letters doesn't work to select the Access code.

    Kindly select a column with a single letter for your unique code.

    Sample screenshot:

    Please give it a try and let us know if the issue still remains.


  • Profile Image
    nituema
    Answered on March 12, 2019 at 11:01 AM

    Thanks, but how about updating the data? when I replace the worksheet it is not updated, I need to remove the extension and insert it again.


    Another thing, is it working with google spreadsheets?

  • Profile Image
    Richie_P
    Answered on March 12, 2019 at 12:13 PM

    Do note that Excel data inside your Spreadsheet to Form widget is static as it is an uploaded file. If you want to update the data inside your excel file, you would have to remove and upload a new excel file in the widget.

    You may use Google Spreadsheet but you would need to download as excel file and upload to the widget.

    Hope this information helps.