Get started with AppSheet by using the sample apps that demonstrate common use cases. The sample apps are summarized in the following table.
See also the product App templates.
To use a sample app, click its link to open it in the AppSheet editor (in a new tab). Then, do one of the following:
- View and interact with the app to learn more about the sample use case and its implementation. (The sample app is read-only.)
- Copy the app to use it as a an initial starting point for your own app.
Sample app | Description |
Activity schedule |
Track a student's extracurricular activities. Students use the app to track schedules as well as important notes for each individual activity. Note the following about the sample app:
|
Add multiple photos |
Add multiple photos to a single row. In the |
At most one value true |
Prevent setting more than one status value to The sample app has a column called
If the current row's status is set to |
Attendance |
Track attendance by clicking thumbs up or thumbs down icons. The app defines actions to trigger the following updates:
The |
Bulk actions |
Apply an action to multiple rows using bulk select. Click the checkbox in the upper-right corner of the app to select multiple rows. Then, click More to select an action. On mobile devices, you can long press on a row to enable bulk action mode. See also Use bulk actions. The sample app:
|
Calculate distances |
Calculate the distance from a user's current location to a designated location (such as the location of a building), identified as a The sample app:
|
Change columns |
Record the timestamp when specific columns are changed. Change type columns are useful for keeping track of how many changes have happened to a row and when they happened. A set of columns are used to track changes to the |
Change view on row selection |
Dynamically change views based on row selection. This sample app defines an action called Change View that uses the
|
Chart of related records |
Display a chart view (histogram) of the related records for a particular row. Each row in the The sample app provides the following views:
Try selecting a person to see a chart of the person's related items by size. |
Click to send email | Description coming soon. See the app documentation. |
Conditional format rules | Description coming soon. See the app documentation. |
Contractor costs |
Keep track of contractor project costs. The sample app is connected to a spreadsheet where all the project information, including costs, is tracked for a project. The contractor can track the project estimate, actual costs, and progress of the different jobs performed in the project. Each view displays a slice of the The sample app allows you to do the following:
|
Custom map pins | Description coming soon. See the app documentation. |
Custom maps | Description coming soon. See the app documentation. |
Custom reports | Description coming soon. See the app documentation. |
Custom tour guide | Description coming soon. See the app documentation. |
Deep links | Description coming soon. See the app documentation. |
Dependent drop-downs | Description coming soon. See the app documentation. |
Distinct pairs | Description coming soon. See the app documentation. |
Distinct value drop-down | Description coming soon. See the app documentation. |
Drill-down | Description coming soon. See the app documentation. |
Drop-downs | Description coming soon. See the app documentation. |
Dynamic form action | Description coming soon. See the app documentation. |
Dynamic inventory | Description coming soon. See the app documentation. |
Dynamic inventory with quantity | Description coming soon. See the app documentation. |
Employee training |
Give visual instructions to employees of a company on how to administer CPR in the event of a medical emergency. The app uses a spreadsheet with four rows: One of the most important aspects of this sample app is the images it features that show employees exactly how to perform each step. The spreadsheet includes an The sample app provides a Steps deck view that allows you to view each step in a specific order. This is necessary as it could be a matter of life and death if steps are not followed in the correct order. In the Steps deck view, the app gives general information; clicking each item gives a more detailed description of how to perform the step. By contrast, the gallery view sets items adjacent to each other and would not be appropriate for this particular app.
|
Builds the following drop-downs from a simple list of values:
The following illustrates how the drop-downs appear in the app. For more information, see Display a drop-down with a simple list of values. |
|
Equipment inspections | Description coming soon. See the app documentation. |
Export CSV | Description coming soon. See the app documentation. |
Export CSV of filtered rows | Description coming soon. See the app documentation. |
Field survey | Description coming soon. See the app documentation. |
Formatting dates | Description coming soon. See the app documentation. |
Form with tabs | Description coming soon. See the app documentation. |
Geofencing | Description coming soon. See the app documentation. |
Hide field in form | Description coming soon. See the app documentation. |
Hierarchical menu | Description coming soon. See the app documentation. |
Histogram | Description coming soon. See the app documentation. |
Home inspection | Description coming soon. See the app documentation. |
Sort your data by a column. The sample app provides two table views, one that sorts by values in the |
|
How to use slices | Description coming soon. See the app documentation. |
Hyperlinks | Description coming soon. See the app documentation. |
Icon main menu | Description coming soon. See the app documentation. |
ICS example | Description coming soon. See the app documentation. |
Image annotations | Description coming soon. See the app documentation. |
Images in forms |
Include an image in a form that is not stored in your data. The app includes a table with a |
Images in sheets | Description coming soon. See the app documentation. |
Initialize to nearest location | Description coming soon. See the app documentation. |
Inspection app upgrade | Description coming soon. See the app documentation. |
Inspection template | Description coming soon. See the app documentation. |
Interactive dashboard | Description coming soon. See the app documentation. |
Interactive map dashboard |
Develop an interactive dashboard view using a map. (View app in full-screen mode.) The sample app provides the following views:
|
Item reservation | Description coming soon. See the app documentation. |
Lead tracking | Description coming soon. See the app documentation. |
Link to form | Description coming soon. See the app documentation. |
Local events calendar | Description coming soon. See the app documentation. |
Log chart viewer | Description coming soon. See the app documentation. |
Lookup function |
Access the value of a column that corresponds to the column value in the same row. In the
|
Lookup table | Description coming soon. See the app documentation. |
Media budget |
Review budgeting data by time period and by media type. You can view how a marketing budget has been spent in different media and the total amount of marketing budget by quarter. The app also lets you review all items in the budget and update them if necessary. The app doesn't let you add data but it lets you edit any entry to the budget section. Additionally, it enables you to search the key partners involved in each marketing initiative and details their duties. The sample app provides the following views:
|
Most recent child row | Description coming soon. See the app documentation. |
Most recent value | Description coming soon. See the app documentation. |
Multi-page forms | Description coming soon. See the app documentation. |
Nested forms | Description coming soon. See the app documentation. |
OCRTEXT() demo | Description coming soon. See the app documentation. |
Order capture how-to |
Manage customers, products, and orders. The sample app allows you to:
The sample app leverages the following AppSheet features:
|
Ordered drop-down | Description coming soon. See the app documentation. |
Out of office app | Description coming soon. See the app documentation. |
Partitioning | Description coming soon. See the app documentation. |
Pie chart | Description coming soon. See the app documentation. |
Project management | Description coming soon. See the app documentation. |
Property management | Description coming soon. See the app documentation. |
Quote calculator | Description coming soon. See the app documentation. |
Quote and proposal | Description coming soon. See the app documentation. |
Ref list filter | Description coming soon. See the app documentation. |
Use reference actions. Reference actions are used to modify a row in one table using an action defined in another table. In this sample app:
|
|
Reminders | Description coming soon. See the app documentation. |
Repair manual |
Provide an instruction manual to employees or customers. The app is created from three tables. In each case:
The deck view displays steps in a vertical presentation in the order that they are intended to be performed accompanied by helpful images that demonstrate the step. |
Repair requests | Description coming soon. See the app documentation. |
Row labels and keys | Description coming soon. See the app documentation. |
Safety reporting | Description coming soon. See the app documentation. |
Sales reporting | Description coming soon. See the app documentation. |
Search in form | Description coming soon. See the app documentation. |
Search using a form | Description coming soon. See the app documentation. |
Share button | Description coming soon. See the app documentation. |
Ship inspection | Description coming soon. See the app documentation. |
Slice based on user input | Description coming soon. See the app documentation. |
Slice by date | Description coming soon. See the app documentation. |
Sliders | Description coming soon. See the app documentation. |
Split on newline | Description coming soon. See the app documentation. |
Sum by date | Description coming soon. See the app documentation. |
SUM() and COUNT() | Description coming soon. See the app documentation. |
Switch expressions | Description coming soon. See the app documentation. |
Table references | Description coming soon. See the app documentation. |
Time clock | Description coming soon. See the app documentation. |
Timer app | Description coming soon. See the app documentation. |
Top related items | Description coming soon. See the app documentation. |
United states population | Description coming soon. See the app documentation. |
Video columns | Description coming soon. See the app documentation. |
Video comments | Description coming soon. See the app documentation. |
View counter |
Count the number of times a row has been viewed in your app. Each row has a The app defines custom actions to override the default behavior when you click a row in a table view, including:
The Row Selected behavior in the View Counter1 view is configured to call the Increment and Navigate action. |
Wind turbine inspection | Description coming soon. See the app documentation. |
Workflow when children added | Description coming soon. See the app documentation. |