Error of mismatch columns

AppSheet AppSheet Q&A
1

Dear community,

I am dealing with the following error message:

Unable to add/edit/delete row in table ‘Form’. → Error: There is a mismatch in the number of columns between the spreadsheet for Gespräch Form and the table schema. The table has 87 columns but the schema has 86 columns. Please regenerate the table column structure. Error: Data table ‘Mitarbeiterentwicklung-1560327:3.000020:Gespräch Form’ is not available Error: Data table ‘Gespräch Form’ is either inaccessible or empty.

I already looked up similar questions here and have considered their solutions in deleting (not just blanking, but actually removing entirely) all columns I am not using and re-selecting the Source Path and Worksheet Name/Qualifier and of course regenerating structure (all and several times). None has worked.

Anyone able to help?

2

Well, sounds like you’ve already done everything I would have suggested! Next step: contact support@appsheet.com so they can look at you app.

1 Like
3

Hello,

Go to DATA > COLUMNS, select your table where you added new columns, and in the top press “Regenerate Structure”.

4

Hi @Marian_Costache,

Thank you, for your suggestion. That was one of the first things I tried. I guess clearing cache (or giving it time) was what solved the issue.

1 Like
5

What is happening maybe you have a column without a title with some data in some field, delete all the empty columns that you are not using.

1 Like
6

What is happening maybe you have a column without a title with some data in some field, a solution can be delete all the empty columns that you are not using

1 Like
7

My users are experiencing this same issue. I make an update to a table and regenerate the structure. 90% of the users are fine as they re-sync automatically, but the other 10% get errors. I eventually have to tell them to clear their cache to fix it.

8

in appsheet why the first row become column name and error goes

9

this errors may be related to this issue

10

regenerate goes, but firs rows appears in column name, i dont understood this error, in my opinion this issues solution not written in this community, please help me for solve this issue

11

in appsheet, all tables related to ref column any other table, but in not related tables this issues goes, is this true, please check this solution

12

Are you sure you are using the correct Google Sheets? Sometimes it could be confusing.

13

I am pretty sure I am editing the correct table. As I mentioned, 90% of the users get the new updates, and the other 10% work fine but only after they clear their browser cache.

Thanks