Data management
You create apps from your data. Learn best practices for organizing and managing your data in an app-friendly way.
Get started managing data
Data design patterns
AppSheet databases
- What is an AppSheet database?
- Create and copy databases
- Manage databases using the database editor
- Use databases in your app
- Build automations using AppSheet databases
- Quick start: Build your first automation using an AppSheet database
- Migrate to an AppSheet database
- Share databases
- Manage and monitor databases in your account
- Disable AppSheet databases
- Before you delete data in your AppSheet database
- Delete databases
- Restrictions, limits, and known issues
- Troubleshoot AppSheet databases
Tables
Columns
- Columns: The Essentials
- Column data types
- Configure column properties
- Set up email auto-completion for Email columns
- Add, reorder, or delete columns
- Improve performance when you add, remove, or rearrange columns
- Change a column type
- Display images and videos in your app
- Define app formulas and initial values
- Add row labels
- App column type (deep link)
- Use virtual columns
- Access column values before and after an update
- Improve the presentation of detail and form views using Show types
- Search and filter on column values
User settings
Data integrations
- Manage data sources
- Use Google Cloud Integration Connectors with AppSheet
- Use data from Airtable
- Use an Apigee data source
- Use data from AWS DynamoDB
- Use data from Excel spreadsheets in Office 365 and SharePoint
- Use data from Gmail
- Use data from Google BigQuery with AppSheet
- Use data from Google BigQuery with the BigQuery data source
- Use data from Google BigQuery with Connected Sheets
- Use data from Google Calendar
- Use data from Google Drive
- Use data from Google Forms
- Use data from Google Sheets
- Use data from MariaDB
- Use data from MySQL
- Use data from an OData feed
- Use data from Oracle
- Use data from PostgreSQL
- Use data from Salesforce
- Use data from Smartsheet
- Use data from SQL Server
- Create a MySQL database hosted in Google Cloud
- Migrate apps between SQL databases
- Copy an existing app to an SQL database
- Connect to an on-premises database
- Prevent app creators from using external data sources