This topic refers to functionality that is only available to accounts on the Quick Base Platform or Quick Base Unlimited plans. If you do not see the functionality described here, either your account or realm has not been configured to show it, or your account is not on one of those plans.
The basic flow for updating an application using an sandbox application appears below:
If you've decided to create a sandbox application, it's because you want to develop and test some major changes and updates to your live application. During this kind of application development, it's important that you restrict all development changes to the sandbox. Therefore, when you create a sandbox, Quick Base locks the live application. At that point, no users can make any changes to the application.
Note: The app manager (and only the app manager) has the ability to unlock the live application. This action is restricted to only the app manager (and not allowed for other app admins) because it could result in unexpected changes or in blocking an update entirely. As a best practice, app managers should avoid unlocking live applications manually. Only unlock the live application when you've decided to discard the sandbox application without applying changes.
Quick Base, of course, expects you to make some changes to the sandbox application; therefore, a locked sandbox doesn't mean you can't make any changes. Locks in the sandbox application prevent you from making any changes that could cause issues when applied to your live application. For instance, Quick Base won't let you delete fields, tables, or relationships in the sandbox application. Quick Base enforces these locks through both the UI and the API.
Quick Base gives you some visual cues as to what's locked and what's not in the sandbox application. For instance, you'll see lock icons in the sandbox application. Lock icons identify those objects that existed in the live application when the sandbox application was created. Quick Base doesn't let you delete these objects in the sandbox application. (You can change their properties, though, if you'd like).
Quick Base does not allow you to apply updates from the sandbox before you perform a compatibility check between the live application and the sandbox application. During the compatibility check, Quick Base compares the sandbox application to the live application and checks to make sure you are not trying to apply any destructive changes to the live application.
If Quick Base finds issues, you will not be able to proceed with the update. Instead, Quick Base points out exactly what caused the problem, and provides tips as to how you might fix the problem and proceed with the update.
Yes, you can indeed create several sandbox applications from the same live application. You might, for instance, want to test two or three different approaches using sandbox applications created from the same live application.
While creating multiple sandbox applications lets you compare your approaches, remember that Quick Base unlocks the live application when you apply changes from any one sandbox application. In other words, if you create and test two sandbox applications from the same live application:
Quick Base locks the live application when you create the first sandbox application
Quick Base keeps the live application locked when you create the second sandbox application
Once you've applied changes from either sandbox application, Quick Base unlocks the live application. Quick Base also deletes the sandbox application you used to apply your changes.
At this point, you've got another "active" sandbox application. But remember, your live application is no longer locked. That means that the sandbox application is not necessarily an accurate "snapshot" of your live application and shouldn't really be used to apply changes.
Therefore, if you have created multiple sandbox applications from the same live application, you should follow the best practice of deleting all sandbox applications that remain after you apply changes from one sandbox application.
If no issues are found during the compatibility check, Quick Base:
Unlocks the live application.
Applies the sandbox updates to the live application. Changes to your app's schema are applied to the live application, but any records created in the sandbox will be lost.
This article doesn't point out that when the sandbox app is applied to the main app, any records created within it will be lost. It's only the schema changes that are applied currently.
Deletes the sandbox application.
If you cancel the update instead of clicking Apply Changes, the live application lock stays in place. Only the app manager can unlock the live app when sandbox updates have not been applied. See About live application locks, above.
© 1999-2018 QuickBase, Inc. All rights reserved. Legal Notices.