We started getting warning/error in 1 app tod...

(Tom Graham) #1

We started getting warning/error in 1 app today, after no recent changes to the app. The warning is about a column mismatch, see image.

  • though the “Data” table only has 7 fields, not the “65” if refers to - no other tables, have “65” fields

Any idea what is going on here, and how to resolve?


(Aleksi Alkio) #2

Is it possible that you have filled some cells in your Data tab manually and your columns are not empty in your spreadsheet?

(Praveen Seshadri (AppSheet)) #3

That error message is rather misleading. We should do something to improve it.

First, it is the table ‘LWD Data’. It comes fwom the worksheet called ‘Data’, and that is one source of confusion.

Secondly, the sheet itself contains only the non-virtual columns. The column structure has 76 columns but some of them are virtual columns.

So anyway, I think there is a mismatch between the sheet and the expected column structure for this table. Probably an extra column got added in the sheet by mistake. May even be an empty column on some of the rows.

(Tom Graham) #4

ahh…right, that did confuse me. Found the correct sheet and resolved issue. thanks!