AppSheet Examples Gallery: 10 Practical App Templates with Tutorials [2025 Selection]

Not sure what AppSheet can do?

This article compiles 10 of the most practical examples.

Each example includes data table design and key formulas—you can directly modify them into your own version.

---

Why Start with Examples?

Designing an App from scratch often leads to wasted effort.

Three Benefits of Using Examples

1. Accelerate Learning

Seeing how others design teaches faster than figuring it out yourself.

2. Reference Best Practices

Examples are usually optimized designs—field planning and formula writing are worth learning from.

3. Modify and Use Directly

No need to start from zero. Copy an example and adapt it to your needs.

If you haven't used AppSheet yet, we recommend first reading AppSheet Beginner Tutorial.

---

How to Get AppSheet Examples?

Three ways to get examples.

1. Official Sample Library

AppSheet has an official App sample library.

Location: Log into AppSheet → Create → Start with a sample app

Categories include:

• Field Services
• Inventory
• Project Management
• CRM

2. Community Sharing

Many people in the AppSheet community share their Apps.

Google search "AppSheet template" to find many more.

3. This Article's Examples

For the following 10 examples, I'll provide complete data table designs and key settings.

You can build identical Apps based on these descriptions.

For more AppSheet features, see AppSheet Complete Guide.

---

Example 1: Inventory Management App

This is the most popular AppSheet application.

Features

• Product catalog management
• Real-time inventory tracking
• Stock movement records
• Low inventory auto-alerts
• Barcode scanning (advanced)

Data Table Design

You need two tables.

Table 1: Products

Field Name	Type	Description
ProductID	Text (Key)	Product ID, unique value
ProductName	Text	Product name
Category	Enum	Product category
CurrentStock	Number	Current stock quantity
SafetyStock	Number	Safety stock level
UnitPrice	Price	Unit price
Photo	Image	Product photo

Table 2: StockMovements

Field Name	Type	Description
MovementID	Text (Key)	Record ID
ProductID	Ref (Products)	Linked product
MovementType	Enum	In/Out
Quantity	Number	Quantity
Date	Date	Date
Notes	Text	Notes

Key Formulas

Calculate Real-time Stock (Virtual Column)

In Products table:

SUM(
  SELECT(
    StockMovements[Quantity],
    AND(
      [ProductID] = [_THISROW].[ProductID],
      [MovementType] = "In"
    )
  )
)
-
SUM(
  SELECT(
    StockMovements[Quantity],
    AND(
      [ProductID] = [_THISROW].[ProductID],
      [MovementType] = "Out"
    )
  )
)

Low Stock Alert (Format Rule Condition)

[CurrentStock] < [SafetyStock]

Set to display red background and warning icon.

Automation Setup

When inventory falls below safety level, auto-send email to purchasing team.

For detailed setup, see AppSheet Automation Complete Tutorial.

Example 2: Expense Tracker App

A financial tracking tool for individuals or small teams.

Features

• Record income and expenses
• Category statistics
• Auto-calculated monthly reports
• Chart visualization
• Budget tracking

Data Table Design

Table: Transactions

Field Name	Type	Description
TransactionID	Text (Key)	Record ID
Date	Date	Transaction date
Type	Enum	Income/Expense
Category	Enum	Category (Food, Transport, Salary...)
Amount	Price	Amount
Description	Text	Description
Photo	Image	Receipt photo (optional)

Key Formulas

Current Month Expenses Total (Virtual Column or Dashboard)

SUM(
  SELECT(
    Transactions[Amount],
    AND(
      [Type] = "Expense",
      MONTH([Date]) = MONTH(TODAY()),
      YEAR([Date]) = YEAR(TODAY())
    )
  )
)

Current Month Income Total

SUM(
  SELECT(
    Transactions[Amount],
    AND(
      [Type] = "Income",
      MONTH([Date]) = MONTH(TODAY()),
      YEAR([Date]) = YEAR(TODAY())
    )
  )
)

Current Month Balance

[MonthlyIncome] - [MonthlyExpenses]

Chart Setup

In UX → Views, add a Chart View:

• Chart type: Pie
• Data: Expense data
• Group by: Category
• Value: SUM(Amount)

This shows expense proportions by category.

---

Example 3: Task List App

A simple but practical project management tool.

Features

• Add to-do items
• Status tracking (To Do/In Progress/Completed)
• Due date reminders
• Assignee designation
• Priority marking

Data Table Design

Table: Tasks

Field Name	Type	Description
TaskID	Text (Key)	Task ID
TaskName	Text	Task name
Description	LongText	Detailed description
Status	Enum	To Do/In Progress/Completed
Priority	Enum	High/Medium/Low
DueDate	Date	Due date
Owner	Text	Assignee
CreatedAt	DateTime	Created time

Automation Setup

One Day Before Due Reminder

Set to execute every morning at 9 AM:

1. Find tasks due tomorrow that aren't completed
2. Send email to Owner

Conditional Formatting

Condition	Display Effect
Status = "Completed"	Green background, checkmark icon
DueDate < TODAY() AND Status ≠ "Completed"	Red background, warning icon
Priority = "High"	Red label

---

Example 4: Leave Request System

HR's most commonly used digitization tool.

Features

• Online leave applications
• Manager approval workflow
• Leave balance tracking
• Leave history queries
• Calendar display

Data Table Design

Table 1: Employees

Field Name	Type	Description
EmployeeID	Text (Key)	Employee ID
Name	Text	Name
Department	Enum	Department
Manager	Ref (Employees)	Direct manager
Email	Email	Email
AnnualLeave	Number	Annual leave days

Table 2: LeaveRequests

Field Name	Type	Description
RequestID	Text (Key)	Request ID
EmployeeID	Ref (Employees)	Applicant
LeaveType	Enum	Type (Annual/Sick/Personal)
StartDate	Date	Start date
EndDate	Date	End date
Days	Number	Leave days
Reason	LongText	Reason
Status	Enum	Pending/Approved/Rejected
ApproverNotes	Text	Manager notes

Automation Setup

Application Submission Notification

When new request is created, auto-send email to manager.

Approval Result Notification

When Status changes, auto-notify applicant.

---

Example 5: Customer Visit Records

Essential CRM tool for sales teams.

Features

• Customer data management
• Visit record tracking
• GPS check-in
• Photo uploads
• Visit statistics reports

Data Table Design

Table 1: Customers

Field Name	Type	Description
CustomerID	Text (Key)	Customer ID
CompanyName	Text	Company name
ContactPerson	Text	Contact person
Phone	Phone	Phone
Email	Email	Email
Address	Address	Address
Industry	Enum	Industry

Table 2: Visits

Field Name	Type	Description
VisitID	Text (Key)	Visit ID
CustomerID	Ref (Customers)	Customer
VisitDate	DateTime	Visit time
Salesperson	Text	Sales rep
Location	LatLong	GPS location
Purpose	Enum	Visit purpose
Notes	LongText	Visit notes
Photos	Image	Photos
NextAction	Text	Follow-up action

Special Features

GPS Check-in

LatLong field auto-captures current location, confirming sales actually visited.

Map Display

Use Map View to display all customer locations and plan visit routes.

Understand the examples but not sure how to adapt them? Every business process has unique needs. Schedule customization consultation and let us help build your custom App.

---

Example 6: Equipment Inspection App

Essential for factories and property management.

Features

• Inspection checklist
• On-site photo records
• Issue reporting
• Inspection history tracking
• Statistical reports

Data Table Design

Table 1: Equipment

Field Name	Type	Description
EquipmentID	Text (Key)	Equipment ID
Name	Text	Equipment name
Location	Text	Location
Type	Enum	Equipment type
LastInspection	Date	Last inspection date

Table 2: Inspections

Field Name	Type	Description
InspectionID	Text (Key)	Inspection ID
EquipmentID	Ref (Equipment)	Equipment
InspectionDate	DateTime	Inspection time
Inspector	Text	Inspector
Status	Enum	Normal/Issue
CheckItems	EnumList	Check items (multi-select)
IssueDescription	LongText	Issue description
Photos	Image	On-site photos

Automation Setup

Instant Issue Notification

When Status = "Issue", auto-send email to maintenance team.

---

Example 7: Simple Calculator App

Suitable for quotes, discount calculations, unit conversions.

Features

• Numeric input
• Auto-calculated results
• Multiple calculation logics
• Calculation history

Data Table Design

Table: Calculations

Field Name	Type	Description
CalcID	Text (Key)	Calculation ID
Input1	Number	Input value 1
Input2	Number	Input value 2
DiscountRate	Percent	Discount rate
Result	Number (Virtual)	Calculated result
Timestamp	DateTime	Calculation time

Key Formulas

Calculation Result (Quote Calculation Example)

[Input1] * [Input2] * (1 - [DiscountRate])

Example: Unit price × Quantity × (1 - Discount rate) = Final amount

---

Example 8: Event Registration System

Essential for hosting events, courses, and seminars.

Features

• Online registration form
• Registration count statistics
• Capacity limits
• Registration confirmation notifications
• Check-in

Data Table Design

Table 1: Events

Field Name	Type	Description
EventID	Text (Key)	Event ID
EventName	Text	Event name
Date	Date	Event date
Location	Text	Location
MaxAttendees	Number	Capacity limit
CurrentCount	Number (Virtual)	Current registration count

Table 2: Registrations

Field Name	Type	Description
RegID	Text (Key)	Registration ID
EventID	Ref (Events)	Event
Name	Text	Name
Email	Email	Email
Phone	Phone	Phone
CheckedIn	Yes/No	Checked in

Key Formulas

Current Registration Count

COUNT(
  SELECT(Registrations[RegID], [EventID] = [_THISROW].[EventID])
)

Capacity Full Check

[CurrentCount] >= [MaxAttendees]

Use in form's Valid If—can't register when full.

---

Example 9: Employee Directory

Internal contact information management.

Features

• Employee data search
• Department filtering
• One-tap calling
• One-tap email
• Org chart display

Data Table Design

Table: Employees

Field Name	Type	Description
EmployeeID	Text (Key)	Employee ID
Name	Text	Name
Department	Enum	Department
Title	Text	Job title
Phone	Phone	Phone
Extension	Text	Extension
Email	Email	Email
Photo	Image	Photo
Manager	Ref (Employees)	Manager

Special Features

One-tap Calling

Phone field type auto-generates call functionality.

One-tap Email

Email field type opens email app directly.

---

Example 10: Survey App

Collect feedback and satisfaction surveys.

Features

• Custom survey questions
• Multiple question types (single choice, multi-choice, text)
• Response statistics
• Anonymous option
• Results charts

Data Table Design

Table: SurveyResponses

Field Name	Type	Description
ResponseID	Text (Key)	Response ID
Timestamp	DateTime	Submission time
Q1_Satisfaction	Enum	Satisfaction (1-5)
Q2_Recommend	Yes/No	Would recommend
Q3_Features	EnumList	Favorite features (multi-select)
Q4_Feedback	LongText	Other comments
Respondent	Email	Respondent (can be anonymous)

Statistics Display

Use Chart View to show:

• Satisfaction distribution (bar chart)
• Recommendation ratio (pie chart)
• Feature preferences (stacked chart)

---

How to Choose the Right Example?

Match your needs.

Need	Suggested Example
Manage items/products	Inventory Management App
Track money flow	Expense Tracker App
Manage to-do items	Task List App
HR leave management	Leave Request System
Sales customer management	Customer Visit Records
On-site inspection records	Equipment Inspection App
Numeric calculation tool	Simple Calculator App
Event/course registration	Event Registration System
Company internal lookup	Employee Directory
Collect feedback	Survey App

---

Example Modification Tips

After getting an example, how to modify it into your own version?

5-Step Modification Method

Step 1: Understand Structure

First understand the example's data table design.

• What tables exist?
• How are tables related?
• What's each field's purpose?

Step 2: Adjust Fields

Modify according to your needs:

• Delete unneeded fields
• Add needed fields
• Modify Enum options
• Adjust Display Names

Step 3: Modify Formulas

If there are Virtual Columns or calculation formulas:

• Understand original logic
• Modify to your calculation method

Step 4: Customize Interface

Adjust Views and presentation:

• Choose appropriate View type
• Adjust sorting and filtering
• Set conditional formatting

Step 5: Test and Publish

• Run through with test data
• Confirm all functions work
• Publish for team use

FAQ

Can I directly copy official examples?

Yes.

Official examples can all be copied to your own account, then modified for use.

Will modifying examples affect the original?

No.

After copying, it's an independent App. Your modifications don't affect the original example.

Do example automation features require payment?

Yes.

Automation features require Starter plan or above.

Free plan only has basic features.

For detailed plan comparison, see AppSheet Pricing Complete Guide.

Can I combine multiple examples?

Yes, but it takes skill.

We recommend mastering single examples first, then try integrating multiple features.

Are there more complex examples?

Yes.

The official example library has advanced examples covering:

• Multi-table relations
• Complex approval workflows
• API integration

---

Next Steps

Found a suitable example?

Recommended Actions

1. Pick the closest example: Doesn't need to be a perfect match—80% similar is fine
2. Build minimum version first: Don't add all features at once
3. Optimize after actual use: You'll know what to change after using it

Continue Learning

• AppSheet Beginner Tutorial: Basic operation tutorial
• AppSheet Complete Guide: Learn all features
• AppSheet Automation Tutorial: Set up automation features
• AppSheet API Integration Guide: Advanced integration

---

Want to Customize an Example?

Examples are a great starting point, but every business has different needs.

Common customization needs:

• Modify fields and workflows to match company policies
• Integrate with existing systems (ERP, CRM)
• Set up complex permission controls
• Design special automation workflows

Schedule customization consultation and let us help build your custom enterprise App.

---

References

1. AppSheet Sample Apps Gallery
2. AppSheet Community Templates
3. Google Cloud - AppSheet Use Cases
4. AppSheet Documentation - Building Common App Types