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

Azure

How to send Entra diagnostic logs to a Log Analytics workspace src How to send Subscription diagnostic logs to a Log Analytics workspace  src How to turn on application logging to the filesystem in a webapp  src how to collect operating system logs  src you will need to make use of Data Collection Rules how to send Windows event logs to Log Analytics  src how to collection metrics for a virtual machine  src you will need to install a diagnostic extension and provision a storage account overview of azure privileged identity management  src overview of Azure Web Application Firewall (WAF) ( 0:52 ) overview of Azure DDoS Protection ( 2:45 ) Entra by default, Entra roles are only given to users. to assign Entra roles to a group, you have to enable it by enabling 'Microsoft Entra roles can be assigned to the group' src overview of administrative unites and restricted management administrative units src how to create a custom role src Networking why you would wan...
Read more

.NET

 how to install and configure swagger src configure swagger to work with api keys src tools for static code analysis src EF Core effect of enabling nullable on EF Core src IIS demo of installing site on IIS src
Read more

Angular

angular server side rendering with hydration introduced in angular 16 src how to create an angular application with server side rendering src how to add angular server side rendering to existing application src static site generation with angular src Change Detection how change detection works under the hood  src uses zone.js how to debug and find code triggering change detection src uses NgZone Running code outside the Angular zone prevents unnecessary change detection cycles, which can improve application performance using onpush change detection   src with signals src Routing setting up routing src Subjects subject as observer (make a cold observable multicast) ( 28:26 ) Reactive Forms using a FormArray src Debugging ng variable that Angular exposes in the development mode, can be used in dev console in Chrome ( 6:00 )
Read more