I added a column to my spreadsheet and "regen...

(Eric Silver) #1

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?

(Steven Coile) #2

Is this an error, or merely a message? I see this message routinely, and it does not indicate a problem.

(Eric Silver) #3

I believe it’s tied to an error I’m getting. That’s what I’m trying to figure out though.

(Steven Coile) #4

@Eric Silver What is the problem you believe the message is tied to?

(Eric Silver) #5

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.

(Steven Coile) #6

@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.

(Eric Silver) #7

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.

(Eric Silver) #8

Here are the specific error messages I just received

(Eric Silver) #9

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”

(Steven Coile) #10

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.

(Eric Silver) #11

I will email them. Thanks. The spreadsheet is actually a Google sheet. Not sure why it says Office 360.