Appsheet A to Z with Practice Projects

Name: Appsheet A to Z with Practice Projects
Rating: 4.4 (7 reviews)

Master AppSheet formulas and expressions and build apps for HR, finance, safety and educational purposes.

Created byJohn Shiburah

Last updated 5/2025

English

English [Auto],

What you'll learn

How to create an App from a spreadsheet with AppSheet.
How to create custom expressions using various AppSheet functions.
How to create actions for easy navigation by users.
How to slice a data set manipulate tables in Appsheet
Create views in Appsheet and a central Home view
How to create charts in Appsheet

Course content

3 sections • 14 lectures • 2h 11m total length

Introduction1:05
Learn to build a no-code app with Google Sheets and Appsheet to record daily observations, aggregate them, and track corrective actions and their status, including inspections and audits.
Spreadsheet7:32
Learn to build a data management app with AppSheet by organizing a single Google Sheet, creating observations and risks sheets, and configuring views and show columns.
Preparing the columns22:04
Configure appsheet data tables for observations and risks and hazards, using show columns, enums, long text, and date extraction, with today slice and counts for corrected and uncorrected observations.
Creating views and the Home view part 115:38
Create and customize AppSheet views, convert index to a form, use slices to hide fields, build today's observations and participation charts, and link navigation actions to a home menu.
Creating views and the Home view part 214:37
Create and configure app views and a home dashboard in AppSheet, linking actions to navigation, displaying corrected and uncorrected observations, and enabling submission, editing, and sharing.

Setting Up5:00
Learn to build a simple quiz app in Appsheet using a spreadsheet, setting up submissions and Q&A tables with timestamp, name, long text questions, and answers, and enabling score computation.
Quiz View6:59
Convert the quiz to a form view with selectable answer choices. Fetch questions from the q&a table using index and adjust show type for clarity.
Multiple Choice set up8:01
Learn to set up multiple choice questions in AppSheet by using enum types and data validity to define per-question options from a Q&A table.
Scoring6:25
Learn to build a two-sheet quiz app in AppSheet, compute a total score with app formulas, awarding one point per correct answer across five questions, and handle text answers.

Setting up the spreadsheet and columns12:28
Learn to build an expense tracker in AppSheet that logs expenses and income, tracks categories on a budget dashboard, and helps you adjust spending to save more.
Creating the views15:20
Create and customize app views for expenses, budget, entries, income log, and a dashboard using forms, cards, tables, and slices to visualize expense and income data.
Table Slicing5:29
Create and configure slices to display only the month, year, category, and amount; add a current month slice and an expense form slice for chart-ready data.
The Charts and Dashboard5:12
Create a home view in appsheet, select a gallery layout, and wire actions to navigate to log, budget, and dashboard views; configure row selection to trigger navigation.
Bringing All Together: The Home5:56
Create charts in AppSheet, including a histogram of monthly amounts linked to categories and dates. Build a dashboard with a home view and primary navigation.

Requirements

No programming skills required

Description

In this comprehensive course, you'll learn how to build mobile apps using AppSheet. Some apps you will build include:

Quiz App(Education)
Expense Tracker App(Finance)
Observations App(Health & Safety)
Attendance App

You will master the essential elements required to develop functional applications tailored to various industries like HR, finance, auditing, safety and education. It is a hands on app creation course taking you step by step with detailed explanations. Once you grab the concepts you will be able to build quickly without stress. One of the apps you will learn to build is a Safety Observations app which features a centralized home page and dedicated views custom designed for tasks, including gathering observations, documenting unsafe acts or conditions, tracking related actions and overseeing departmental engagement levels.

Your learning journey will involve making use of some fundamental AppSheet functions, empowering you to leverage tools such as LIST(), DATE(), SELECT(), and INDEX() effectively. Also, you'll gain proficiency in table manipulation techniques, honing your ability to extract row-specific data through slicing methods. You will be introduced to how to use formatting in enhancing the views you create after preparing and setting up the columns in Appsheet.

By the course's conclusion, you'll possess a comprehensive understanding of AppSheet's capabilities and be equipped with the skills necessary to construct a safety observations app from scratch. Whether you're a novice or seasoned developer, this course offers invaluable insights and practical knowledge essential for creating impactful applications in the realm of safety management.

Appsheet lends itself to much creativity and throughout the course you will see that you are not bound to do exactly as you see but you can experiment other things to suit your taste. You can preview you app in either mobile, tablet or desktop format.

Who this course is for:

Project Managers
Safety Officers
Teachers
HR professionals
Accountants and finance professionals

Appsheet A to Z with Practice Projects

What you'll learn

Explore related topics

Course content

Safety Observations App5 lectures • 1hr 1min

QuizApp4 lectures • 26min

Expense Tracker App5 lectures • 44min

Requirements

Description

Who this course is for: