APP DESIGN

How to think about the design of your apps.

P

15 articles in this collection
Written by Santiago Uribe Montoya, Philip Garrett, and Steve Coile

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

Modeling tables and columns

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

UX design patterns

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

App design patterns

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

Spreadsheet design

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

Written by Philip Garrett
Updated this week