Spreadsheet to form widget is returning an error

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?

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.

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.

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?

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.