DATA

How to model the data in your apps.

47 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.
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 Column Structure tab.
Written by Madeline Clarke
Updated over a week ago

Column Types: Diving Deeper

Learn more about each column type you can have when structuring your columns.
Written by Madeline Clarke
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 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.
Written by Madeline Clarke
Updated over a week ago

How do I change a column type?

Learn how to change your column's type to something that suits the data you have.
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.
Written by Madeline Clarke
Updated over a week ago

Modifying Column Names, Types, and Attributes

How to change elements of your column.
Written by Madeline Clarke
Updated over a week ago

Row Labels

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

Virtual Columns

Check out how you can use virtual columns to add more information to your app.
Written by Madeline Clarke
Updated over a week ago

Column Type: App (Deep Links)

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

Using Data from MySQL

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

Using Data from MariaDB

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

Using Data from PostgreSQL

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

Using Data from AirTable

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

Using Data from Smartsheet

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

Using Data from AWS DynamoDB

You can build an app using data from AWS DynamoDB
Written by Madeline Clarke
Updated this week

Using Data from Salesforce

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

Using Data from Socrata

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