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
Tables
Columns
- Columns: The Essentials
- Column data types
- Configure column properties
- Add, remove, or rearrange columns
- Improve performance when you add, remove, or rearrange columns
- Change a column type
- Display videos and images 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
- Customize detail and form views using Show types
User settings
Data integrations
- Use multiple data sources
- 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 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