[resolved] Error loading my app

[NicolasB]

Hello

I have an error when loading my appsheet :

• my table (in Appsheet) has 34 columns (I’ve just recounted)
• if I open the data source (with appsheet), I get the right spreadsheet - which has 34 columns.
• I’ve regenerated the schema

I deleted the 3 columns last weekend ; the application worked well on Monday, Tuesday and again this morning

is anyone else experiencing this problem or has anyone else experienced this problem?

Is anyone else experiencing this problem or has anyone else experienced this problem ?

thank you

[resolved] : there were 3 blank spaces in the last 3 (empty) columns of the spreadsheet

[PauloExpert]

The error indicates that the AppSheet application is detecting a mismatch between the number of columns in your table schema and the data source. This mismatch could be caused by:

1. AppSheet Cache Issue: AppSheet might not have updated the schema properly after you deleted the three columns, even though the app worked earlier. Cached schema information might still include the old structure.

2. Hidden Columns in the Spreadsheet: Sometimes, hidden columns in the spreadsheet are not immediately visible but still count as part of the total column count.

3. Connected View Issues: If the app is linked to a specific view or table that relies on an outdated schema, it may cause an error even if the main table is updated.

4. External Source Update: If the spreadsheet was edited directly outside of AppSheet (e.g., through another integration or by another user), this could cause schema mismatches.

Suggested Steps to Resolve:

1. Regenerate the Table Schema Again:

   • In AppSheet, go to Data > Tables.
   • Select the affected table and click Regenerate Structure.
   • Check if this resolves the error.

2. Verify Spreadsheet Columns:

   • Open the data source (spreadsheet) directly.
   • Check for hidden columns or inconsistencies (e.g., merged cells, extra rows, or non-standard formatting).

3. Delete and Re-add the Table:

   • If regenerating the schema doesn’t work, try removing the table from AppSheet and re-adding it.
   • Backup your app before performing this step.

4. Clear App Cache:

   • Clear the cache of your AppSheet app and try again.
   • Ensure you’ve refreshed your browser or reloaded the editor.

5. Inspect the Error Message:

   • Note the reference to “Data table ‘Aavas-…’” in the error message. This might indicate a specific view or linked table causing the issue.
   • Check all references to the “agenda” table in your app and confirm that they are consistent.

If the issue persists, you can try contacting AppSheet support for further assistance, as they may be able to identify backend issues affecting your app.

[NicolasB]

Thanks Paulo