APP DESIGN

App Design 101

How to think about building your app

Written by Santiago Uribe Montoya
Updated over a week ago

The Info Tab

Customize your app's look and find where errors and warnings are happening.

Written by Steve Coile
Updated over a week ago

The "Item-Detail" Data Pattern

A classic data model pattern to capture many Detail records that correspond to a single Item record

Written by Santiago Uribe Montoya
Updated over a week ago

The "Lookup/Dropdown" Data Pattern

A classic data pattern used to help users pick values from a fixed list of options

Written by Santiago Uribe Montoya
Updated over a week ago

Control Whether and When a Value Can be Edited in a Form

Design pattern to ensure that a form input can only be changed in specific circumstances.

Written by Santiago Uribe Montoya
Updated over a week ago

Make Your List into an App

Everyone has a list in a spreadsheet - a client list, an item list, etc. Here are some suggestions for building useful list apps.

Written by Santiago Uribe Montoya
Updated over a week ago

Many Identical Apps

How to make several versions of the same app that are different for each user

Written by Santiago Uribe Montoya
Updated over a week ago

Making an "AppSheet-Friendly" Spreadsheet

How to optimize your spreadsheet design so that it works better with AppSheet

Written by Santiago Uribe Montoya
Updated over a week ago

Effective Use of Column Headers

How to make sure that AppSheet can identify and locate your column headers

Written by Santiago Uribe Montoya
Updated over a week ago

Working with a Spreadsheet and the Editor

How to understand and control the process of getting your spreadsheet to work well with the AppSheet Editor.

Written by Santiago Uribe Montoya
Updated over a week ago

Spreadsheet Cell Formats

You can assign a "cell format" to a cell in your spreadsheet to control how the data stored in that cell is displayed.

Written by Santiago Uribe Montoya
Updated over a week ago

Spreadsheet Formulas

How formulas you write in your spreadsheet impact your app creation process

Written by Santiago Uribe Montoya
Updated over a week ago

Mismatched Spreadsheet Formulas

Diagnosing Mismatched Formulas in a Column

Written by Santiago Uribe Montoya
Updated over a week ago

Using Spreadsheets with Pivoted Data

Most spreadsheet data uses field names as column headers and data entries in each row.

Written by Santiago Uribe Montoya
Updated over a week ago

Google Sheets having Protected Sheets or Protected Ranges

Appsheet Does Nothing Special for Google Sheets Containing Protect Sheet or Protected Ranges

P

Written by Philip Garrett
Updated over a week ago