Regenerating schema broken

AppSheet AppSheet Q&A
,
1

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;

OracleNick_0-1681495123431.png
OracleNick_0-1681495123431.png1567×721 83 KB

OracleNick_1-1681495294622.png
OracleNick_1-1681495294622.png507×936 48 KB

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. [?](https://www.appsheet.com/support/errormessages#WARNING_APPDEF_INCORRECTCOLUMNNUMBERS)
*Error: *Data table 'NewBusinessLog2022-5358664:1.000424:Current Data' is not available [?](https://www.appsheet.com/support/errormessages#ERROR_TABLE_CANTREAD)
*Error: *The data for this view cannot be found. Please select a new data table in the view settings.[?](https://www.appsheet.com/support/errormessages#ERROR_INTERNAL_TABLENOTACCESSIBLE)
  • Adding another blank column then regenerating also does nothing

Thank you for your time

2
Make an “AppSheet-friendly” spreadsheet - AppSheet Help

Remember that your worksheet should just be a database to hold your apps’ data, not a user-focused thing

3

IIRC, the last time I tried to load a pivot table sheet into Appsheet, it didn’t work. But I was able to just put =arrayformula(pivot!A:C) into another sheer, and load that in.

4

Any insight as to why it imported perfectly fine, but only broke when the schema was regenerated?

5

It’s not supported. The fact that worked doesn’t mean it should