Best practice for changing data structure of a deployed app

Deployed app. Pro license. Need to add a column to a table/spreadsheet.

How do you handle it with the least impact on your users?

Do you send out a Broadcast Notification?

Do you try to only make that change when most users won’t be in the app?

Looking for best practice now that I’m not in prototype any more.

I don’t want my users to get the following type of error:


That particular user had to eventually delete the app, delete AppSheet and start from scratch to install.

I’ve since suggested best practices but I’ll make that a topic of another post.

Thanks.

0 1 292
1 REPLY 1

Austin
Participant V

I think the delete appsheet and start from scratch is a bit much. Normally an option is to make a copy of your app that you change the data structure in. Then use the Upgrade App in Manage-Versions. Also when adding columns you are generally safe from my experience. Deleting columns is a pain and always breaks everything. It is definitely best to make the updates at the end/beginning of a day.
The error in your screenshot happened to me once and seemed to be a very bizarre occurrence that columns were not coming in when I would regenerate and eventually stopped occurring.
There is also a Switch to recovery mode in Manage-Deploy that can help any pending changes come through when you make structure changes. In summary just go fast and hard at making sure the changes take the least amount of time to make.

Top Labels in this Space