App Does not load successfully after data updates to Google Sheet

[Gregory_McIntyr]

Are there any specific rules that need to be followed to update the data in my Google Sheet which will prevent it from causing the App to error on load or not load successfully.

I have a public facing App that is Read-Only for App users.

I have updated rows of data via the Source data Google Sheets, this usually involves adding new rows AND deleting others. Would this cause the App to error?

If so, how can I make changes via the Google Sheet with causing these problems

[Rafael_ANEIC-PY]

Hello @Gregory_McIntyre , the app editor should display an error that would provide us with more information about why exactly your app is not loading, could you please share a screenshot of it?

As far as my experience goes, as long as you don’t make changes to the google sheet structure that is connected to appsheet (changing column header names, deleting sheets), there shouldn’t be any problem with you managing your data, have you checked that your structure is intact?

[Gregory_McIntyr]

Hi @Rafael_ANEIC-PY Thanks for responding. There were no structural changes made, I was finding that although updates were made to the sheet these were not updating on the App.

I checked the Offline/Sync setting and these were properly configured. The error message I got was this…

Hi haven’t changed the column name [Call] but for some reason the App can’t seem to find the column.

I recognise the expression I was using was incorrect, previously I had just used a simple [Call] expression which seemed to be fine.

I initially assumed this might be a referencing issue but I don’t understand why the App can’t read my [Call] column, is it perhaps because it needs a different label?

[Gregory_McIntyr]

Hi @Rafael_ANEIC-PY Thanks for responding. There were no structural changes made, I was finding that although updates were made to the sheet these were not updating on the App.

I checked the Offline/Sync setting and these were properly configured. The error message I got was this…

Hi haven’t changed the column name [Call] but for some reason the App can’t seem to fins the column.

[Rafael_ANEIC-PY]

Gregory_McIntyre:

Hi haven’t changed the column name [Call] but for some reason the App can’t seem to find the column.

Hello @Gregory_McIntyre, have you tried regenerating your “Hospital” table?, if it doesn’t appear on your column structure that’s your only option, since that means appsheet isn’t aware of his existence in your google sheets.