Appsheet Proficiency

  1. Home
  2. Google-appsheet
  3. Appsheet Proficiency

Tags: Google AppSheet

Level Up your AppSheet Skills - Upgrade your Career

Last updated 2022-01-10 | 4.2

- How to build apps in AppSheet

What you'll learn

How to build apps in AppSheet

* Requirements

* No

Description

The AppSheet Fundamentals Path is meant to guide you through the main concepts to get you comfortable building apps from zero experience to a functional user of AppSheet, while at the same time teaching you standards and structure so that you can avoid pitfalls that we find catch many new AppSheet Developers. Made up of 35 modules and over 3 hours of focused training content. You will be exposed to all the major components of the AppSheet development experience, guided by a platform expert.

Topics covered include:

  • Data Structure and Relational Database Concepts

  • Choosing the best data source for your application

  • Connecting Data

  • Column Typing and Interaction

  • How to employ Expressions

  • Expressions everyone should be familiar with

  • Overview of AppSheet View options

  • App Branding and Format Rules

  • App Actions

  • Reports and Workflow Concepts

  • App Deployment Best Practices

  • Additional Learning Material and Free Resources

This course will equip you to understand the major components of AppSheet and prepare you to build business-grade AppSheet applications.

This course does not cover a full app build, or much development. For those looking for more advanced practicals and tips on building creative applications, please check out our Advanced UX course. In that course we build Several complex Items such as Dynamic Search Dashboards, Graph & Charts, Interactive Dashboards, and much more!

Who this course is for:

  • AppSheet Developers
  • No Code Developers
  • Business Owners

Course content

7 sections • 40 lectures

AppSheet Introduction 2 lectures

Introduction Preview 01:14

Welcome to the AppSheet Proficiency Course, we are excited to have you on board!


Understanding the Core Principles of AppSheet Preview 03:25

"In this video we talk about core principals and key words involved in AppSheet.
These are concepts we think are important to know before you start developing such as:
RAD
No/Low Code
Front End
Back End
and even answering the question, What is AppSheet."


App Architecture & Data Design 12 lectures

Choosing a Data Source Preview 06:03

In this video we will go over the most common back end options for storing data for AppSheet, and their advantages and disadvantages.


Fundamental Data Concepts pt.1 Preview 03:58

In this module we go into the basic keywords you will need for understanding Data


Fundamental Data Concepts pt.2 Preview 03:25

In this module we go into the basics of Keys


Data Normalization Preview 13:35

In this module we will go into the principal of data normalization.

This is one of the most crucial and fundamental principals related to using AppSheet and how to add data to AppSheet

Data Relationships Preview 08:13

In this module we will focus in on what relationships are as well as basic types of relationships.


Creating an App and Connecting it to Your Data Preview 05:21

In this module, we will discuss choosing a data source and connecting them to your app


Adjusting your Data and Regenerating your Columns Preview 03:48

In this module, we will discuss adding tables and reconstructing the schema of existing data

Data Tab Overview Preview 04:35

In this module, we will discuss the Data Tab and dive deeper into the features that are offered from the platform

The Column Editor Preview 06:56

In this module, we will help you understand The Column Editor feature inside of AppSheet

Keys, References and Labels Preview 06:28

In this module we will help you understand how to use data normalization inside of AppSheet.


Data Types Overview Preview 07:14

In this module, we will discuss the key data types to know in AppSheet

App Architecture & Data Design Quiz

This quiz will test your knowledge on App Architecture & Data Design

Logic & Expressions in AppSheet 10 lectures

Standard vs Virtual Columns Preview 06:45

In this module, we will discuss the differences between Standard and Virtual columns

What is an Expression? Preview 03:47

In this module, we will break down the fundamental pieces of an expression

QREW Tools Preview 07:34

An AppSheet plugin to help you get more out of Expressions .

A toolkit for AppSheet users who want to get more out of Expressions.

Key Features include:

- A structured Text Editor Overlay on Expression Assistant fields that color codes expression names, matching parenthesis, static string values and more! (Now with Multiple Color Themes, optional text functions, and Fully Expandable Text Area)

- Turns Expression Library items into links that open the AppSheet Documentation in the sidebar.

- Common Expressions that you use can be "Snipped" and stored* in the sidebar for easy access.

- Shows all Data Tables, Columns, and Views inside your app with Quick actions to insert them into your editor.

Expression Assistant Preview 05:10

In this module, we will help you understand the Expression Assistant feature inside of AppSheet

Exploring the Expression Assistant's Examples Section Preview 08:31

In this module, we will dive into the examples of the Expression Assistant and discuss which expressions are more commonly used.

Dereferences Preview 05:05

In this module, we go into the pulling data out of a referenced table.

Conditionals Preview 08:22

In this module, we will discuss the parameters of an expression called conditions

USEREMAIL() Preview 02:54

In this module we will dive into the expression USEREMAIL() expression and how it can be used to customize your app based on the user.

SELECT() Preview 06:09

In this module we are going to dive into the SELECT() expression, break down it's parameters and some common use cases for the expression.


Logic & Expressions Quiz

This quiz will test your knowledge on Logic & Expressions

UX Design 6 lectures

UX Tab Overview Preview 03:05

In this module we dive deep into UX Options

Navigation and the View Tab Preview 10:14

In this module we dive deeper into the view tab and the basic forms of Navigation within AppSheet. We will talk about the view editor as well as go over the types of views currently possible with AppSheet

Branding Your App Preview 04:05

In this module we dive into how to customize your apps branding

Format Rules Preview 04:34

In this module we will be going over the format rule tab and the format rule editor

UX Options Preview 06:28

In this module we dive deep into UX Options

UX Design Quiz

This quiz will test your knowledge on UX Design

Intro to App Behavior & Workflows 4 lectures

Behaviors Tab Overview Preview 02:49

In this module we do a brief overview of the behavior tab and where to find things.

Actions Preview 07:29

In this module we dive into some of what is possible with actions. We talk about the action tab system actions, and the action editor itself.

Workflows and Reports Preview 06:55

In this module we introduce you to the concepts of workflows and reports. We will dive into their differences, their similarities, and how to get dynamic data into your reports.

App Behavior & Workflow Quiz

This quiz will test your knowledge on App Behavior & Workflow

Sharing your App and Deployment 5 lectures

Offline & Sync Settings Preview 05:09

In this module, we will discuss data synchronization options that are available in AppSheet

Adding Users Preview 02:23

In this module, we will discuss adding users to your apps

Deployment Preview 04:16

In this module we will be going over the important information you will need in order to deploy your app

Where to Find Additional Training Resources Preview 02:21

In this module, we will discuss additional training resources from external websites

Users & Deployment

This quiz will test your knowledge on Users & Deployment

AppSheet Conclusion 1 lectures

AppSheet Proficiency Path Conclusion Preview 02:12

Congratulations! You’ve made it to the end of the AppSheet Proficiency path!