Group 65
Go to AppSheet
All Collections
DATA
DATA
How to model the data in your apps.
+2
61 articles in this collection
Written by
Santiago Uribe Montoya,
Steve Coile,
Derek Covey
and 2 others
How to refresh database access credentials?
This quick guide helps you understand how to update data source information for databases connected to your AppSheet apps.
Written by
Santiago Uribe Montoya
Updated over a week ago
Data: The Essentials
A high-level overview of concepts for organizing and using data in AppSheet.
Written by
Santiago Uribe Montoya
Updated over a week ago
Tables
Tables: The Essentials
Key insights to add tables in your app.
Written by
Santiago Uribe Montoya
Updated over a week ago
Tables: Diving Deeper
How to add tables in the editor.
Written by
Santiago Uribe Montoya
Updated over a week ago
Controlling Add, Update, and Delete
How to determine how much your app users can modify data.
Written by
Santiago Uribe Montoya
Updated over a week ago
Localization, Access, and Source Info
What you can do when you select "More Settings" for your table.
Written by
Santiago Uribe Montoya
Updated over a week ago
How to Use Multiple Sheets in Your App
You might want to use data from more than one spreadsheet in your app. There are two ways to do this.
Written by
Santiago Uribe Montoya
Updated over a week ago
Private Tables
Learn how to use tables in cases where each user needs their own individual data.
Written by
Santiago Uribe Montoya
Updated over a week ago
Locales: Diving Deeper
Learn how to ensure that your data makes sense for your locale.
Written by
Santiago Uribe Montoya
Updated over a week ago
Supported Locales
Locales supported by Appsheet
Written by
Santiago Uribe Montoya
Updated over a week ago
Keys
What is a Key?
Learn the purpose of keys and why they’re necessary.
Written by
Santiago Uribe Montoya
Updated over a week ago
Sequential Keys
A technical rationale for why AppSheet can't support sequential keys.
Written by
Santiago Uribe Montoya
Updated over a week ago
Editable Keys
How to make key values work well in your app.
Written by
Santiago Uribe Montoya
Updated over a week ago
Manually Generating UNIQUEID() Key Values
How to manually generate UNIQUEID() key values.
Written by
Santiago Uribe Montoya
Updated over a week ago
Columns
Columns: The Essentials
Once you have tables in the editor, you can use the Columns tab to categorize each column and give it a role in the app.
Written by
Santiago Uribe Montoya
Updated over a week ago
Column Types and Properties
Learn more about column type, column order, and virtual columns in the Columns tab.
Written by
Santiago Uribe Montoya
Updated over a week ago
Column Types: Diving Deeper
Learn more about each column type you can have when structuring your columns.
Written by
Santiago Uribe Montoya
Updated over a week ago
Editing Your Columns
An in-depth look at what you can do to change the properties of your columns.
Written by
Santiago Uribe Montoya
Updated over a week ago
How to add, remove, or rearrange columns
Regenerating your columns is a necessary step in making sure changes in your spreadsheet are reflected in your app's structure.
Written by
Santiago Uribe Montoya
Updated over a week ago
Improving Performance When Adding, Removing, or Rearranging Columns
Reducing the time required to regenerate a table
Written by
Santiago Uribe Montoya
Updated over a week ago
How to Change a Column Type
Learn how to change your column's type to something that suits the data you have.
Written by
Santiago Uribe Montoya
Updated over a week ago
How to Display Videos and Images in Your App
There are a few ways to show images and videos in your app.
Written by
Santiago Uribe Montoya
Updated over a week ago
App Formulas and Initial Values
How you can set app formulas and initial values to dynamically assign values.
Written by
Santiago Uribe Montoya
Updated over a week ago
Modifying Column Names, Types, and Attributes
How to change various column elements.
Written by
Santiago Uribe Montoya
Updated over a week ago
Row Labels
How to determine which columns are prominently displayed in a view.
Written by
Santiago Uribe Montoya
Updated over a week ago
App Column Type (Deep Link)
Learn how to use deep links to navigate to another view in the same app, or in another app.
Written by
Santiago Uribe Montoya
Updated over a week ago
Virtual Columns
Check out how you can use virtual columns to add more information to your app.
Written by
Steve Coile
Updated over a week ago
References
Displaying Referenced Records
How to seamlessly display data that is referenced from another table.
Written by
Santiago Uribe Montoya
Updated over a week ago
References Between Tables
Learn about references, when to create them, and how to use them so your data makes sense.
Written by
Santiago Uribe Montoya
Updated over a week ago
Slices
Slices: The Essentials
Display only certain rows or columns of your table with slices.
Written by
Santiago Uribe Montoya
Updated over a week ago
Slice Row Filter Conditions
Explore how to use row filter conditions to build different slices of data.
Written by
Santiago Uribe Montoya
Updated over a week ago
Slice Columns
How to define a slice by choosing columns from your original table.
Written by
Santiago Uribe Montoya
Updated over a week ago
Slice Actions
Learn how to define a slice by choosing actions from your original table.
Written by
Santiago Uribe Montoya
Updated over a week ago
User Settings
User Settings: The Essentials
Give users more control to customize app behavior.
Written by
Santiago Uribe Montoya
Updated over a week ago
User Settings: Appropriate Use and Limitations
When and why to use user settings.
Written by
Santiago Uribe Montoya
Updated over a week ago
Using Different Data Sources
Apigee Data Source
Using APIs from Apigee to build Apps in AppSheet
S
Written by
Scott Haaland
Updated over a week ago
Using Multiple Data Sources
Build an AppSheet app with data from multiple sources and providers.
Written by
Santiago Uribe Montoya
Updated over a week ago
Migrating Apps Between SQL Databases
Move your app's data from one SQL database to another using AppSheet.
Written by
Santiago Uribe Montoya
Updated over a week ago
Copying an Existing App to a SQL Database
How to move an app's data into a SQL database.
Written by
Santiago Uribe Montoya
Updated over a week ago
Data Integrations
Using Data from Google BigQuery
Written by
Ty Alevizos
Updated over a week ago
Using Data from Google Sheets
The easiest way to build AppSheet apps from Google Sheets is to use the AppSheet add-ons found in the Google add-on gallery.
Written by
Santiago Uribe Montoya
Updated over a week ago
Using Data from Excel spreadsheets in Office 365 and SharePoint
How you can build an AppSheet app with data from Office 365, Excel, and Sharepoint.
Written by
Santiago Uribe Montoya
Updated over a week ago
Using Data from Google Forms
The easiest way to build AppSheet apps from Google Forms is to use the AppSheet add-ons found in the Google add-on gallery.
Written by
Santiago Uribe Montoya
Updated over a week ago
Using Data from Google Calendar
Build an app with data from Google Calendar.
Written by
Santiago Uribe Montoya
Updated over a week ago
Using Data from Smartsheet
How you can build an AppSheet app with data from Smartsheet.
Written by
Santiago Uribe Montoya
Updated over a week ago
Create a MySQL Database Hosted in Google Cloud
How to create a MySQL database instance in Google Cloud and connect to your AppSheet account.
Written by
Derek Covey
Updated over a week ago
Connecting to an On-Premises Database
How to use DreamFactory and its REST API.
Written by
Santiago Uribe Montoya
Updated over a week ago
Using data from an OData feed
Written by
Santiago Uribe Montoya
Updated over a week ago
Using Data from MySQL
How to build an AppSheet app with data from MySQL.
Written by
Santiago Uribe Montoya
Updated over a week ago
Using Data from PostgreSQL
How to build an AppSheet app with data from PostgreSQL.
Written by
Santiago Uribe Montoya
Updated over a week ago
Using Data from SQL Server
How you can build an AppSheet app with data from SQL Server.
Written by
Santiago Uribe Montoya
Updated over a week ago
Using Data from MariaDB
How to build an AppSheet app with data from MariaDB.
Written by
Santiago Uribe Montoya
Updated over a week ago
Using Data from Oracle
How to build an AppSheet app with data from Oracle
Written by
Santiago Uribe Montoya
Updated over a week ago
Using Data from AirTable
How you can build an AppSheet app with data from AirTable.
Written by
Santiago Uribe Montoya
Updated over a week ago
Using Data from AWS DynamoDB
You can build an app using data from AWS DynamoDB.
Written by
Santiago Uribe Montoya
Updated over a week ago
Using Data from Salesforce
How you can build an AppSheet app with data from a Salesforce instance.
Written by
Santiago Uribe Montoya
Updated over a week ago
Using Data from Socrata (Deprecated)
How you can build an AppSheet app with data from Socrata.
Written by
Santiago Uribe Montoya
Updated over a week ago
Object Store Integrations
Understanding Cloud Object Stores
Written by
Santiago Uribe Montoya
Updated over a week ago
Configuring Google Cloud Storage as a Cloud Object Store
Configuring Google Cloud Storage for image and file upload
Written by
Santiago Uribe Montoya
Updated over a week ago
Configuring AWS S3 as a Cloud Object Store
Images and documents associated with a table can reside and be saved to AWS S3.
Written by
Santiago Uribe Montoya
Updated over a week ago
Configuring a Relational Database as a Cloud Object Store
Image and file content can be stored and retrieved from a database table
Written by
Santiago Uribe Montoya
Updated over a week ago