AppSheet, app development, mobile apps, offline users
How can I manage updating an AppSheet app that's deployed if I've got offline users?
How can I make sure that I don't break the app for anyone offline?
What do I do if I need to make emergency updates to the app, and those updates include adding a column to the table, but I've got users in the field without connectivity?
If you're in anything like the situations above, and you're not using the enterprise license for your AppSheet account, then you don't have access to the Stable Version feature
So if you find yourself where:
You've got users that are offline, who have been offline for awhile now, what have collected enough data that it can't be lost; and
You need to make a critical update to the app, which includes ADDING a column to a table
Unless you've taken steps ahead of time to prepare for this eventuality.... you're going to find yourself between a rock and a hard place
There are a few things you can do to help make this situation easier:
Include [Temp] columns in your tables
Schedule when you make your updates
Split off a "development" version, and use the app upgrade feature
------------------------------------------------------------------------------- 1 - Include [Temp] columns in your tables ------------------------------------------------------------------------------- One of the easiest things you can do is to add in a Temp column, or an Extra column, into each of the tables you build
And by this I literally mean... an extra column (or several) that serve no purpose - Other than standing by, waiting for when you need to add a column but you've got offline users
I'll typically include 3 or 4 of these, if I know for certain I'll have offline users
------------------------------------------------------------------------------- 2 - Schedule when you make your updates -------------------------------------------------------------------------------
Another thing you can do, which seems simple when you think about it, is to manage when you make these larger "app breaking" updates
You'll typically know ahead of time that you need to add a column
So you could hold off adding that column right then and there
Send out an email to everyone letting them know: - "This Friday at 2pm the app will be broken for about an hour"
Giving yourself a window when you can make these updates
------------------------------------------------------------------------------- 3 - Split off a "development" version -------------------------------------------------------------------------------
If you want to make 100% sure that the changes you're making to the app WON'T affect anyone that's currently using the app - the best method would be to split off a development copy of your app
You can copy your app, and un-click the toggles to copy the data source
If you do so, the app will be tied to the same data source
But... all the changes you make will be isolated into that development version
Then when you're ready, you can go back to your "Live" app and use the App Upgrade Feature to push those updates into your app
This essentially takes your live app and makes it a clone of the development app
Literally... EVERY setting is copied over
This includes things like the "App Name" - You'll need to make sure to change back to what it should be - because the Development app's name was just copied to the Live app
------------------------------------------------------------------------------- BEST OF THE BEST -------------------------------------------------------------------------------
Honestly, the best practice would be to combine all three of these strategies together - and make them your standard operating procedure moving forward
If you operate with these 3 guidelines in mind moving forward, you'll be covered in any situation you might find yourself
You can learn more in the video below: