DATA

How to model the data in your apps.

Santiago Uribe Montoya avatar
52 articles in this collection
Written by Santiago Uribe Montoya
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.
Santiago Uribe Montoya avatar
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.
Santiago Uribe Montoya avatar
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.
Santiago Uribe Montoya avatar
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.
Santiago Uribe Montoya avatar
Written by Santiago Uribe Montoya
Updated over a week ago

When and How to Regenerate Your Columns

Regenerating your columns is a necessary step in making sure changes in your spreadsheet are reflected in your app's structure.
Santiago Uribe Montoya avatar
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.
Santiago Uribe Montoya avatar
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.
Santiago Uribe Montoya avatar
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.
Santiago Uribe Montoya avatar
Written by Santiago Uribe Montoya
Updated over a week ago

Modifying Column Names, Types, and Attributes

How to change various column elements.
Santiago Uribe Montoya avatar
Written by Santiago Uribe Montoya
Updated over a week ago

Row Labels

How to determine which columns are prominently displayed in a view.
Santiago Uribe Montoya avatar
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.
Santiago Uribe Montoya avatar
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.
Santiago Uribe Montoya avatar
Written by Santiago Uribe Montoya
Updated over a week ago
Data Integrations

Using Data from Excel and Office 365

How you can build an AppSheet app with data from Office 365, Excel, and Sharepoint.
Santiago Uribe Montoya avatar
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.
Santiago Uribe Montoya avatar
Written by Santiago Uribe Montoya
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.
Santiago Uribe Montoya avatar
Written by Santiago Uribe Montoya
Updated over a week ago

Using Data from Google Calendar

Build an app with data from Google Calendar.
Santiago Uribe Montoya avatar
Written by Santiago Uribe Montoya
Updated over a week ago

Connecting to an On-Premises Database

How to use DreamFactory and its REST API.
Santiago Uribe Montoya avatar
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.
Santiago Uribe Montoya avatar
Written by Santiago Uribe Montoya
Updated over a week ago

Using Data from MySQL

How to build an AppSheet app with data from MySQL.
Santiago Uribe Montoya avatar
Written by Santiago Uribe Montoya
Updated over a week ago

Using Data from MariaDB

How to build an AppSheet app with data from MariaDB.
Santiago Uribe Montoya avatar
Written by Santiago Uribe Montoya
Updated over a week ago

Using Data from PostgreSQL

How to build an AppSheet app with data from PostgreSQL.
Santiago Uribe Montoya avatar
Written by Santiago Uribe Montoya
Updated over a week ago

Using Data from Oracle

How to build an AppSheet app with data from Oracle
Santiago Uribe Montoya avatar
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.
Santiago Uribe Montoya avatar
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.
Santiago Uribe Montoya avatar
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.
Santiago Uribe Montoya avatar
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.
Santiago Uribe Montoya avatar
Written by Santiago Uribe Montoya
Updated over a week ago

Using Data from Socrata

How you can build an AppSheet app with data from Socrata.
Santiago Uribe Montoya avatar
Written by Santiago Uribe Montoya
Updated over a week ago