Avoid conflict when adding new field to published app

I have an app that is published and being used by several users. In the past when I have made changes to the underlying data I have had instances where the app crashes with the warning that the number of columns don’t match. That turns into a major exercise, especially for Android users, who sometimes end up having to empty the cache, remove appsheet, reinstall appsheet and reopen the app.

I now have to, once again, add a few columns to some of the data. What is the recommended approach to do this and avoid issues?

2 Likes

Never add new columns between or before existing ones; only add new columns after existing columns.

When removing columns, only blank them, do not delete them.

This may reduce problems, but may not eliminate them.

3 Likes

Thanks Steve. I was worried that may be the case. I guess I can reduce the risk a little more by adding columns as late as possible and hope someone else still isn’t logged in.

1 Like

Is there any way I can tell, or keep track of, who is actively logged into the app? If I can be sure all my users are logged off I should be able to safely add fields.

1 Like

Not really. The best you can do is see when someone’s device last exchanged data with the servers.

AppSheet apps are fundamentally distributed apps: the app has its own copy of the data and the user interacts with that local copy. Occasionally, the app syncs with the server. Until and unless the app syncs with the server, you have no visibility into the user’s interaction with the app.

2 Likes

Thanks Steve.

2 Likes