DATA

How to model the data in your apps.

Madeline Clarke avatar
49 articles in this collection
Written by Madeline Clarke
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.
Madeline Clarke avatar
Written by Madeline Clarke
Updated over a week ago

Column Types and Properties

Learn more about column type, column order, and virtual columns in the Columns tab.
Madeline Clarke avatar
Written by Madeline Clarke
Updated over a week ago

Column Types: Diving Deeper

How to choose which column type suits your data best.
Madeline Clarke avatar
Written by Madeline Clarke
Updated over a week ago

Editing Your Columns

How to change column properties.
Madeline Clarke avatar
Written by Madeline Clarke
Updated over a week ago

When and How to Regenerate Your Columns

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

App Formulas and Initial Values

How you can set app formulas and initial values to dynamically assign values.
Madeline Clarke avatar
Written by Madeline Clarke
Updated over a week ago

Modifying Column Names, Types, and Attributes

How to change various column elements.
Madeline Clarke avatar
Written by Madeline Clarke
Updated over a week ago

Row Labels

How to determine which columns are prominently displayed in a view.
Madeline Clarke avatar
Written by Madeline Clarke
Updated over a week ago

Virtual Columns

How to use virtual columns to add more information to your app.
Madeline Clarke avatar
Written by Madeline Clarke
Updated this week

App Column Type (Deep Link)

Learn how to use deep links so that you can navigate to different views in the same app, or in another app.
Madeline Clarke avatar
Written by Madeline Clarke
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.
Madeline Clarke avatar
Written by Madeline Clarke
Updated this week

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.
Madeline Clarke avatar
Written by Madeline Clarke
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.
Madeline Clarke avatar
Written by Madeline Clarke
Updated over a week ago

Using Data from Google Calendar

How you can build an AppSheet app with data from Google Calendar.
Madeline Clarke avatar
Written by Madeline Clarke
Updated over a week ago

Using Data from SQL Server

How you can build an AppSheet app with data from SQL Server.
Madeline Clarke avatar
Written by Madeline Clarke
Updated over a week ago

Using Data from MySQL

How you can build an AppSheet app with data from MySQL.
Madeline Clarke avatar
Written by Madeline Clarke
Updated over a week ago

Using Data from MariaDB

How you can build an AppSheet app with data from MariaDB.
Madeline Clarke avatar
Written by Madeline Clarke
Updated over a week ago

Using Data from PostgreSQL

How you can build an AppSheet app with data from PostgreSQL.
Madeline Clarke avatar
Written by Madeline Clarke
Updated over a week ago

Using Data from AirTable

How you can build an AppSheet app with data from AirTable.
Madeline Clarke avatar
Written by Madeline Clarke
Updated over a week ago

Using Data from Smartsheet

How you can build an AppSheet app with data from Smartsheet.
Madeline Clarke avatar
Written by Madeline Clarke
Updated over a week ago

Using Data from AWS DynamoDB

You can build an app using data from AWS DynamoDB
Madeline Clarke avatar
Written by Madeline Clarke
Updated over a week ago

Using Data from Salesforce

How you can build an AppSheet app with data from a Salesforce instance.
Madeline Clarke avatar
Written by Madeline Clarke
Updated over a week ago

Using Data from Socrata

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