I added a column to my spreadsheet and โregeneratedโ. I received this error (โThe app template diff data is too largeโ) and canโt figure out how to fix it without rolling back to a previous version. I understand Appsheet thinks a bunch of changes have been made, but I all I did was add one column. Any ideas?
Is this an error, or merely a message? I see this message routinely, and it does not indicate a problem.
I believe itโs tied to an error Iโm getting. Thatโs what Iโm trying to figure out though.
@Eric Silver What is the problem you believe the message is tied to?
Can you see the original post? Iโm adding a column to my spreadsheet and regenerating in AppSheet. When I do apparently AppSheet canโt read the spreadsheet any more and my app stops working.
@Eric Silver The โapp template diff data is too largeโ message is not an error, and is normal when sufficient changes have been made.
Please describe the way in which your app does not work.
Iโm not sure how else to describe it other than what I posted above. When I add a column to the spreadsheet and regenerate the table I get a message saying the app canโt read the spreadsheet any more.
Here are the specific error messages I just received
The only way I can get the app to work again is to restore a previous version. When I try to do this without removing the column I just added I get this message.
โUnable to fetch app definition: Error:Error: There is a mismatch in the number of columns between the spreadsheet for FieldEstimate-129634:1.041493:Field Estimate and the table schema. The table has 36 columns but the schema has 35 columns. Please regenerate the table column structure. Error: The table FieldEstimate-129634:1.041493:Field Estimate is not available Error: Data table โField Estimateโ is either inaccessible or empty./nError: There is a mismatch in the number of columns between the spreadsheet for FieldEstimate-129634:1.041493:Field Estimate and the table schema. The table has 36 columns but the schema has 35 columns. Please regenerate the table column structure. Error: The table FieldEstimate-129634:1.041493:Field Estimate is not available Error: Data table โField Estimateโ is either inaccessible or empty./nError: There is a mismatch in the number of columns between the spreadsheet for FieldEstimate-129634:1.041493:Field Estimate and the table schema. The table has 36 columns but the schema has 35 columns. Please regenerate the table column structure. Error: The table FieldEstimate-129634:1.041493:Field Estimate is not available Error: Data table โField Estimateโ is either inaccessible or empty./nโ
This would appear to be a bug with AppSheet. As the error messages suggest, you should email support@appsheet.com for help. Theyโll need the screen capture you posted above.
I donโt use Office360, so have no experience diagnosing those specific errors.
I will email them. Thanks. The spreadsheet is actually a Google sheet. Not sure why it says Office 360.
User | Count |
---|---|
35 | |
35 | |
28 | |
23 | |
18 |