Table Schema ERROR OR View/Slice issue

Hello!

Free version of appsheet. Not being shared.

Under "VIEWS" I get the error: 

The data for this view cannot be found. Please select a new data table in the view settings.

However there's no sign of which particular view it is referring to, neither is there a red error circle against any of my views.

I caused this error a few days ago when I either deleted a SLICE that was being used by a VIEW or vice versa. I solved the issue by going back to an older version.

It happened again today, same error, but this time I saw that one of my TABLES was missing, only a message telling me to delete and add the table again.  I did so, adding back all the expressions (time consuming), etc, but the error persists under my VIEWs.

I'm not sure what to try next. Have gone back many many versions and they're all with the unrunnable message, no hint at which table or view is the problem, no mention of mismatch in columns.

Can anyone help me please?  Do I have to abandon and start again (sigh)?

Screen Shot 2025-05-11 at 2.36.05 pm.png

Solved Solved
0 6 123
2 ACCEPTED SOLUTIONS

Ok, after working with Support and getting no resolution, I ended up noticing some VIEWS were using slices with a suffix of "1". Then saw that two tables had disappeared from the app (and from the GS). These were rebuilt and added to the app, eventually all came good. 

Lesson learned is to work carefully with adding new tables and changing views to look at those new tables/slices, also won't be deleting any slices/views, rather just prefixing them with "DELETE_" and maybe taking care of them at the end when I need to clean things up.

View solution in original post

Update: finally I also solved it by going into each view and looking for any views that were assigned to the deleted table and found two such views.

However the error message surely needs to be more specific or the app editor should be more intuitive to delete all the views associated with a table or slice once the table or slice is deleted.

Will request @lizlynch to update the development team on this bug.

View solution in original post

6 REPLIES 6
Top Labels in this Space