LinkedIn
Twitter
Imported my table into appsheet and everything worked perfectly, until I deleted a few columns and decided to regenerate the schema to reflect this change. Then, the only column that appeared was the _RowNumber, and I got the following error message;
"
Unable to fetch app definition.
Error: There is a mismatch in the number of columns between the spreadsheet for Current Data and the table schema. The table has 3 columns but the schema has 0 columns. Please regenerate the table column structure. Error: Data table 'NewBusinessLog2022-5358664:1.000424:Current Data' is not available Error: The data for this view cannot be found. Please select a new data table in the view settings.
"
Regenerating the schema again does nothing, and the 3 columns that are in my sheet do not transfer over as they should;
THINGS TO NOTE;
- I have the correct sheet selected
- Everything was working fine before I regenerated the schema
- Deleting the data in appsheet and reading it does nothing
- Clicking preview data brings the following errors;
Error: There is a mismatch in the number of columns between the spreadsheet for Current Data and the table schema. The table has 3 columns but the schema has 0 columns. Please regenerate the table column structure. ?
Error: Data table 'NewBusinessLog2022-5358664:1.000424:Current Data' is not available ?
Error: The data for this view cannot be found. Please select a new data table in the view settings.?
- Adding another blank column then regenerating also does nothing
Thank you for your time
Solved
1 ACCEPTED SOLUTION
