Google Appsheet
What you'll learn
You can start todo freelancing on Appsheet projects after finishing this course and can start earning money :)
You will learn basics of appsheets
You will learn how Appsheet Expressions works, How Automation Bot works, and how to make workflows!
After learning this course you can start creating your own apps!
Requirements
Basic Logical Thinking
SQL Database Queries
Description
In this course, you will learn -> Overview of the AppSheetWhat is AppSheet? and How AppSheet will be helpful in Business Automation. Explaining AppSheet features with a sample app to understand the basics-> Fundamentals - Basic AppSheet expressionsAppsheet expressions are the basic fundamentals to make functioning the app properly with the spreadsheet as a database and you will learn the common AppSheet expressions to create essential apps. It's similar to the SQL database queries so if you have previous knowledge of SQL will be helpful to learn Appsheet expressions quickly.Expressions you can learn:1. Yes/No Expressions using Show IF use case2. Concatenate Expressions3. Conditional Expressions - IF Expressions4. Conditional Expressions - IFS Expressions5. Conditional Expressions - Switch Expressions6. Date and Time Expressions - TODAY(), NOW(), WEEKDAY(), MONTH()7. Math Expression - AVERAGE(), ROUND()8. List Expression - SELECT(), IN()9. Text Expressions10. Other Important Expressions - COTEXT(), USERROLE(), HYPERLINK(), TEXT_ICON()-> Finally real-life apps with advanced featuresYou can create Fully functioning real-life apps like Accounting, Restaurant Management, and Tax Invoice App with a step by step tutorials Features you can learn:1. How to calculate tax using math functions2. How to send automated emails3. How to store files in Gdrive4. How to import CSV files in AppSheetOnce you have completed all these topics, you can start creating your own apps without coding :) and can start your freelancing career also to make money as AppSheet developers are in huge demand worldwide for small to medium business people
Overview
Section 1: Overview of the AppSheet
Lecture 1 What is Appsheet and Basic App Creation
Section 2: Fundamentals - Appsheet Expressions
Lecture 2 Yes/No Expression using Show IF Use case
Lecture 3 Concatenate Expression
Lecture 4 Conditional Expressions - IF Expressions
Lecture 5 Conditional Expressions - IFS Expressions
Lecture 6 Conditional Expressions - Switch Expressions
Lecture 7 Date and Time Expressions - TODAY(), NOW(), WEEKDAY()
Lecture 8 Math Expressions - AVERAGE(), ROUND()
Lecture 9 List Expressions - SELECT(), IN()
Lecture 10 Text Expressions
Lecture 11 Other Important Expressions - COTEXT(), USERROLE(), HYPERLINK(), TEXT_ICON()
Section 3: Real-life apps with advanced features
Lecture 12 Accounting App
Lecture 13 Restaurant Booking App - Using List Subtraction and Addition
Lecture 14 Tax Invoice App - Importing Invoices - Part 1
Lecture 15 Tax Invoice App - Sending Tax Invoice to Customers - Part 2
Lecture 16 Tax Invoice App - Storing Tax Invoices in Google Drive - Part 3
Beginner Appsheet Learners,To develop app without coding
Screenshots