Build A Vehicle Inspection App With Appsheet

A full AppSheet build tutorial designed for beginner and intermediate AppSheet developers

Last updated 2022-01-10 | 4.9

- How to create a vehicle inspection app in AppSheet.
- Table relationships and setting up references between the tables.
- How to set up a bot to email a pdf of a document you set up
- as well as some template expressions.

What you'll learn

How to create a vehicle inspection app in AppSheet.
Table relationships and setting up references between the tables.
How to set up a bot to email a pdf of a document you set up
as well as some template expressions.

* Requirements

* Have access to Google Sheets.
* Have basic understanding of table references and expressions within AppSheet.

Description

Welcome to the AppSheetTraining (dot) com Vehicle Inspection App build!

Here are some of the topics we will be covering:


  • Properly setting up your columns in Google Sheets to use in AppSheet

  • Table relationships and reference columns

  • How to set up, and use, show columns

  • Creating a form view with multiple tabs

  • Creating actions that will link the user to different views within the app

  • Setting up a document and using template expressions to populate the document

  • Creating a bot to save a pdf version of the document

  • Setting up a bot to send the pdf in an email to specific users

  • Setting specific table permissions depending on the user’s role

  • Using expressions, such as “Select()” and “Lookup()”


This course is a full app build that is targeted for AppSheet developers who have a base knowledge of AppSheet. Throughout the build we will cover a variety of features contained within AppSheet. One of these features is table relationships and reference columns. While we won’t be going in depth for most of these features, you should feel confident to build your own app in AppSheet.


As you go through this course you will be able to follow along and build the app yourself, then you can customize the app and make it more personalized by changing or adding features.

Who this course is for:

  • Beginner and intermediate AppSheet developers.
  • AppSheet developers who want to grow in their understanding of table relationships.
  • Site or Resource Inspection App

Course content

4 sections • 27 lectures

Use case for vehicle inspection app Preview 07:20

Data Intro Preview 00:39

Setting up Data in Sheets Preview 07:30

Adding data to AppSheet and setting up columns pt. 1 Preview 07:25

Setting up columns pt. 2 Preview 09:08

Setting up columns pt. 3 Preview 04:24

Setting up virtual columns Preview 06:41

UX Design Intro Preview 01:00

Customizing simple form, standard views, and Brand Preview 06:35

LINKTOFORM Action and complex form view Preview 07:25

Complex form view and "Show_If" expression Preview 07:18

Finish Complex form and set up table view Preview 05:56

Setting up Detail Views Preview 06:07

Setting up first slice and view Preview 06:13

Setting up Slice Detail and creating action Preview 07:28

Setting up second slice and views Preview 06:56

Creating action to replace edit and customizing the inline views Preview 07:14

Format rules pt. 1 Preview 05:19

Format rules pt. 2 Preview 06:37

Table Permissions Preview 11:21

Automation Intro Preview 00:43

Bot that updates the parent table based off the child table Preview 08:01

Update default app folder, and start on document template Preview 06:37

Template expressions using google sheets Preview 08:53

Bot that emails pdf on button press Preview 07:32

Bot that saves pdf on form completion Preview 09:40

Testing the bot out Preview 03:44