DATA

How to model the data in your apps.

S +1

56 articles in this collection
Written by Santiago Uribe Montoya, Dinh Nguyen Nguyen, Steve Coile and 1 other

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

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 this week

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

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 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 Dinh Nguyen Nguyen
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

Content from AWS S3

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

Image and file content from a relational database

Image and file content can be stored and retrieved from a database table

Written by Santiago Uribe Montoya
Updated over a week ago