Objective
This document serves as a guide for the production deployment of AppSheet applications. Here the “service account” is the owner of the production version of the application.
Checklist:
- Launch the deployment check on the DEV version.
- If any checks are not green, correct the errors.- Deploy the application.
- Share the application with the service account.
- Transfer ownership of the DEV version to the service account.
- Make a copy of the PROD version as a backup (no backup possible).
- Put the application in maintenance mode (Manage → Deploy → Pause app).
- Copy the name of the application in PROD to the clipboard.
- If PROD and DEV have the same data structure
- Perform an App Upgrade without a major version change (AppName in the DEV app URL).
- Connect the data sources to the PROD data.- If PROD and DEV do not have the same data structure (adding/removing columns or tables):
- Perform an App Upgrade with a major version change in PROD (AppName in the DEV app URL).
- Modify the PROD data source to match the DEV data source.
- Connect the data sources to the PROD data (tables settings → source path → browse new data → pick up your file).- Rename the application to match the PROD name.
- If there are any hardcoded URLs, update them.
- If there is group management redefining Google Groups, ensure it is updated.
- If there are scripts running:
- Change the script or its parameters to adapt it for production.
- Grant the service account access to the script.- Verify that the service account has access to all external files added to the application (email template format, Doc, etc.).
- Run the application (Manage → Deploy → Resume Paused app).
- Redefine the stable version (Manage → Versions → Stable Version).
- Verify that PROD is functioning correctly.
- Undeploy the DEV version.
- Transfer ownership of the DEV version back to the developer.
I hope it helps you out 