Help center
Sign inTry for free
Course contents7 lessons
Course overview
  1. How to Create a New Application
  2. How to Change Application Access Type
  3. How to Assign Tags While Saving a Record
  4. How to Use Chat Feature in Applications
  5. How to Manage Transactions in Applications
  6. How to Use The Automated Application Creation Tool
  7. 07Application migration and backup

Lesson 7 of 7

Application migration and backup

Export and import SpreadsheetWeb applications, preserve Runtime Text separately, choose a historical transaction, and transfer saved records.

2 min read

Export a SpreadsheetWeb application for backup or move it between environments, such as development, testing, and production. Application migration preserves the core design in a portable export, but several related resources must be handled separately for a complete transfer.

Export the application

Open the application in Design and select Export. SpreadsheetWeb downloads the application as an export file containing the workbook and application configuration.

You can also export from the application's history page. This option lets you choose a specific transaction rather than always using the latest version, which is useful for restoring or migrating a known published state.

Preserve resources not included in the export

The application export does not include every related resource:

  • Queries must be documented and recreated separately. Capture their source, selected fields, conditions, bindings, and other settings before migration.
  • Runtime Text changes are exported from the Runtime Text area as a separate JSON file. Keep that file with the application backup so it can be imported into the target application.
  • Saved records are transferred separately from the Data page.

Treat these files and notes as one backup set. An application export alone may not reproduce the full source environment.

Create or update the target application

To create a separate copy, open Create New Application and upload the application export instead of an Excel workbook. After creation, open Runtime Text and import the saved JSON file. Recreate any queries using the settings documented from the source.

To update an existing application, open it in Design, choose Import, and upload the exported application file. Review the new transaction before publishing it.

Transfer saved records

  1. Open the source application's Data page.
  2. Select Download All to export the records as an Excel workbook.
  3. Open the target application's Data page.
  4. Select Import and upload the saved-record workbook.

After migration, test the workbook calculations, user interface, queries, Runtime Text, saved data, events, and access rules in the target environment before directing users to it.