Speadsheet: Internal error

YO UTILIZO UN WIDGET PARA EXTRAER DATOS DESDE UN EXCEL PRECARGADO, PERO HOY VEO QUE ME SALE ESTE ERROR EN TODOS MIS FORMULARIOS

Hi Santos,

Thanks for reaching out to Jotform Support. Our Spanish Support agents are busy helping other Jotform users right now, so I'll try to help you in English using Google Translate, but you can reply in whichever language you feel comfortable using. Or, if you'd rather have support in Spanish, let us know and we can have them do that. But, it might take a while until they're available again.

Now, coming back to your question, about the issue with a Column not being identified in the Spreadsheet to Form widget. Can you provide us a link to the spreadsheet so we can download and try it on our end?

When you upload your spreadsheet to the widget, it is important to ensure that the column names in your spreadsheet exactly match the field labels on your form, including the Approval Code column. The widget requires you to select the correct column as the Access Code Column from a dropdown list after uploading the file. If the Approval Code column is not showing up or being recognized, please check the following:

• File format: Make sure your spreadsheet is in XLS or XLSX format, as other formats are not supported.
• Column naming: Verify that the column header for the approval code is spelled exactly as you intend, with no extra spaces or special characters.
• Sheet selection: If your spreadsheet has multiple sheets, ensure you select the correct sheet name in the widget settings.
• Refresh the widget: After uploading, click the wand icon again and check the Access Code Column dropdown to see if the Approval Code column appears.

If the column still does not appear, try opening your spreadsheet and re-saving it as a new XLSX file, then upload it again. Sometimes formatting issues in the spreadsheet can cause the widget to not recognize columns properly. Once the Approval Code column is correctly identified and selected as the Access Code Column, the widget will use it to match the entered code to the corresponding row data.

Give it a try and let us know how it goes