Building No-Code Apps with AppSheet: Foundations

https://www.pluralsight.com/courses/building-no-code-apps-appsheet-foundations-5

by Google Cloud 

Module 1: Introduction

  1. Course Introduction

Module 2: AppSheet Overview

  1. Module Overview
  2. History of apps
    • debut of iPhone in 2007 and its impact on apps
    • requires software and programming skills
  3. Fundamentals of no-code app development
    • definition: "The process of developing apps without writing any code"
    • develop apps faster and cheaper
    • develop apps 10 times faster
    • no code vs low-code: no code requires no code at all, whilst low code require some coding
    • strong foundational security protocols 
    • who uses no code: process owners, decision makers, end users
  4. What is AppSheet?
    • owned by Google
  5. AppSheet use cases
    • Build an asset tracker app to track inventory in real time.
    • Build a variety of front-line and customer experience apps.
    • Build customized apps tailored to your HR needs.
  6. Demo
    • 3 ways to start an app:
      • start with your own data
      • start with an idea
      • start with a sample app
    • you can build an app from a google sheet
  7. Module Review
  8. Reading: AppSheet use cases and sample apps

Getting Started
  1. Module Overview
  2. Signing in to AppSheet
  3. Creating your first app
    • shows how to create an app using "Start with your own data", in this case a google sheet
    • gives overview of the AppSheet Editor
    • you can add additional data sources to your app by click on Data from the AppSheet Editor
    • from Data blade, you can set visibility of columns, set data type
    • from UX blade, you can create custom views
    • with the launch of AppSheet automation, the behavior workflow and reports features are being replaced by automation events and processes.
  4. Testing your app
  5. Sharing your app
    • you can share with app publicly or to a restricted audience
  6. Lab: Creating a Basic App using AppSheet
  7. Getting Started with Google Cloud and Qwiklabs
  8. Lab: Creating a Basic App using AppSheet
  9. Module Review
Leveraging Data
  1. Module Overview
  2. Using data sources
    • spreadsheets: office 365, excel, google sheets
    • databases: mysql, postgresql, sql server, etc..
    • others: Google Drive, Google Calendar, Apigee, Smartsheet, Dropbox etc..
    • shows how to create a table from a data source
    • data sources don't have to be read only; changes in appsheet can propagate back to the data source
  3. Defining the data structure in your app
    • AppSheet automatically infers your table column name and type
      • you can overide the name and type if needed
    • you can add your own columns, in addition to the ones pulled from the data source
    • virtual columns are computed values that are not part of the data source
    • shows how to regenerate a data source when there is a schema change
  4. Using more than one table in your app
    • an appsheet can have multiple tables and you can create references between them
      • to create a reference, you add a column of type 'ref'
      • a reverse reference is created automatically
  5. Demo
  6. Lab: Configuring Data for your App using AppSheet
  7. Lab: Configuring Data for your App using AppSheet
  8. Module Review
Defining the User Experience of Your App
  1. Module Overview
  2. Introduction to AppSheet Views
    • you can create a new View from the UX blade
    • view types available: Calendar, Table, Gallery, Map, Chart, etc...
  3. Using Views in AppSheet
    • A view is attached to a single table or slice in the app
    • types of views: Primary, Ref, and Menu
  4. Customizing the UX of your app
    • you can customize the About page from the Info blade
  5. Demo
  6. Lab: Implementing the User Experience for your App using AppSheet
  7. Lab: Implementing the User Experience for your App using AppSheet
  8. Module Review
Publishing Your App
  1. Module Overview
  2. App deployment process
    • deployment check (found under the Manage blade) is something you should run before deploying our app
      • fix any reported errors and warning before publishing
    • you can switch back and forth between Prototype and Deployed state
  3. Deployment methods
    • two types of deployment: Instant and Traditional
    • Instant Deployment: on mobile, uses have to install the AppSheet Hosting app
    • Traditional Deployment: app is deployed to App Store or Play Store
  4. Testing your app
  5. Sharing your app
  6. Lab: Publishing your App using AppSheet
  7. Lab: Publishing your App using AppSheet
  8. Module Review
Course Review
  1. Course Review
Course Resources
  1. Course Resources

Comments

Post a Comment

Popular posts from this blog

Angular Routing and Navigation Playbook

Image
https://www.pluralsight.com/courses/angular-routing-navigation-playbook by Lara Newsom Course Overview Course Overview Course Introduction and Code Examples Course Introduction and Code Examples Basic Angular Routing Setup Introduction to Angular Routing Discussion: Angular RouterModule Exports Demo: Bootstrap Angular RouterModule Discussion: Declaring Routes angular has tow route path match strategies: prefix based or full match prefix is the default Demo: Declaring Default and Home Routes two options for declaring a default route: {path: ' ', componenet: DefaultComponent} {path: ' ', redirectTo: 'home', pathMatch: 'full'} Discussion: Child Routes and Route Order Demo: Declaring a Wildcard Route wild card routes is: path: '**' to enabled logging all navigation events to the console, enable tracing Demo: Hooking into Router Events Routing in Standalone Component Applications Introduction to Standalone Components and Routing Demo: Bootstrapping Ro...
Read more

Working with Files in C# 10

https://www.pluralsight.com/courses/c-sharp-10-working-files by Jason Roberts Course Overview Course Overview Sandbox Managing Files and Directories Introduction Creating a New Console App Checking if a File Exists you can use to check if file path is an absolute path: Path.IsPathFullyQualified Getting the Parent Directory of a Path Checking if a Directory Exists and Creating New Directories Copying a File Moving a File Getting the File Extension from a File Name Checkpoint 01- Get the Parent Directory for a Path Changing a Filename Extension Checkpoint 02 - Get the Extension Part of a Filename Deleting a Directory Enumerating All the Files in a Directory Summary Exercise 01- Copying and Deleting Files Monitoring the File System for Changes Introduction Introducing the FileSystemWatcher Class The IntemalBufferSize Property Configuring Notification Filters Additional Properties Refactoring to Use a FileSystemWatcher use FileSystemWatcher to watch for file changes in a folder Checkpo...
Read more

Mastering Git

https://app.pluralsight.com/library/courses/master-git/table-of-contents by Paolo Perrotta Module 1: Course Overview Course Overview Module 2: The Four Areas: Introduction Version Check About This Training A Note About the Command Line Introducing the Four Areas The Working Area The Repository The Index Module 3: The Four Areas: Basic Workflow Revisiting the Basics Moving Data to the Right Moving Data to the Left Removing Files Renaming Files A Quick Summary Module 4: The Four Areas: Git Reset Understanding Reset A Reset Example More Reset Examples Module 5: The Four Areas: Advanced Tools Stashing Data Solving Conflicts Working with Paths Committing Parts of a File Introducing Switch and Restore Git Is a Toolbox Module 6: History: Exploring the Past Becoming a History Surgeon Referencing Commits to show changes in a commit: git show HEAD to show changes in a commit parent: git show HEAD^ Tracking Changes in History Browsing the Log Module 7: History: Fixing Mistakes Reviewing the Golde...
Read more