Search icon
Subscription
0
Cart icon
Close icon
You have no products in your basket yet
Arrow left icon
All Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletters
Free Learning
Arrow right icon
Democratizing Application Development with AppSheet
Democratizing Application Development with AppSheet

Democratizing Application Development with AppSheet: A citizen developer's guide to building rapid low-code apps with the powerful features of AppSheet

By Koichi Tsuji , Suvrutt Gurjar , Takuya Miyai
$19.99 per month
Book Jan 2023 396 pages 1st Edition
eBook
AU$40.99 AU$27.99
Print
AU$50.99
Subscription
$19.99 Monthly
eBook
AU$40.99 AU$27.99
Print
AU$50.99
Subscription
$19.99 Monthly

What do you get with a Packt Subscription?

Free for first 7 days. $19.99 p/m after that. Cancel any time!
Product feature icon Unlimited ad-free access to the largest independent learning library in tech. Access this title and thousands more!
Product feature icon 50+ new titles added per month, including many first-to-market concepts and exclusive early access to books as they are being written.
Product feature icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Product feature icon Thousands of reference materials covering every tech concept you need to stay up to date.
Subscribe now
View plans & pricing

Product Details


Publication date : Jan 6, 2023
Length 396 pages
Edition : 1st Edition
Language : English
ISBN-13 : 9781803241173
Vendor :
Google
Category :
Table of content icon View table of contents Preview book icon Preview Book

Democratizing Application Development with AppSheet

Getting Started with AppSheet

AppSheet is a leading low-code platform for creating business apps. The platform was originally created to develop apps for mobile devices back in 2014 and has been growing ever since. AppSheet became a reputable Digital Transformation (DX) platform and helps app creators to develop business apps compatible with devices such as mobile phones, tablets, and laptops, most importantly, without writing a single line of code.

AppSheet will offer you a path to develop a robust application that could solve a challenge you face in your business without asking for coding skills and knowledge. AppSheet prepares a set of template apps with which you can start to build your own apps, and you can also create a new app from a scratch using data such as Excel and/or Google Sheets. The beauty of AppSheet is that everyone can get on board easily and start for free.

Google constantly keeps adding new features to enhance the functions of AppSheet. This means AppSheet can be used to create business applications with tons of advanced features to facilitate the daily jobs in your offices and solve your own business problems. However, once we start a journey with AppSheet by building our first app, you may notice that it is not easy to handle this platform to customize app behaviors to meet your own requirements. In the context of the comparison between no-code and full-code development, a no-code approach to building an application is far more efficient and productive than full coding in terms of the required number of man-hours to complete a project. However, to validate this comparison, app creators must be proficient as well as confident in no-coding tools such as AppSheet.

This story applies to AppSheet. An understanding of AppSheet is a key to success for efficient business applications. Hence, Learn AppSheet is an essential first step for all app creators who want to freely develop their own unique apps.

This book is designed for absolute beginners to AppSheet as well as those who have a small amount of experience to assist them in learning the platform in a structured manner. The process of development with AppSheet is generally consistent regardless of the type of app you build. It is vitally important to understand the AppSheet way of development when building your apps by learning the basics.

Throughout this book, you will learn the overall processes to develop apps from the beginning to the end to increase your level of confidence in handling the AppSheet Editor. Furthermore, we will touch upon some advanced skills and techniques for you to develop feature-rich applications with AppSheet.

By the end of this book, you should be able to grasp the full process of building an AppSheet app with basic features.

Your path as an AppSheet app creator is endless. Each time you learn something new, you will have something else to aim for ahead of you. We hope this book will provide you with a gateway to being a successful AppSheet creator.

In this chapter, we will cover the following topics:

  • How AppSheet apps are generally built
  • Prerequisites
  • Converting your ideas into an AppSheet app

How AppSheet apps are generally built

Whenever you create a new app, these basic steps are always followed:

  1. First, you prepare the data source, usually a spreadsheet on a cloud platform such as Google Drive.
  2. Next, you connect the data source to AppSheet. After you connect the data, AppSheet will automatically generate the app for you.
  3. Once the data is connected, the app development process moves to the AppSheet Editor. Through the AppSheet Editor, you define how the connected data will be used and configure various app settings, including creating actions for data manipulation and navigation, designing views and layout, and adding automation bots.
  4. You can invite test users to try the app for further improvement.
  5. When the app is ready, AppSheet provides an easy way to deploy the app to your team and colleagues.

In summary, those five steps are as follows:

  1. Connecting the data source
  2. Editing your app definition
  3. Deploying the app

By reading this book, you will learn the basic sequence of this app development process. All app developments occur in the AppSheet Editor. We will be covering all the important details of these steps to learn how to configure your app through the AppSheet Editor in the upcoming chapters.

Prerequisites

To work with AppSheet, it is helpful if you are familiar with spreadsheets such as Google Sheets and Microsoft Excel; AppSheet uses its own expressions but most of them are identical to Google Sheet formulas. The syntax can sometimes be slightly different, but the idea is mostly the same. Also, having an understanding of the basic concepts of how spreadsheets work will help you to build your app’s foundation. However, don’t worry if you are not familiar with Google Sheets – you will get to know it in the following chapters. In fact, there are a number of AppSheet expressions that are unique to AppSheet and not found in other spreadsheet services. We will cover AppSheet expressions throughout this book, especially in Chapter 4, Manipulate Data with Expressions and Formulas.

In addition to familiarity with spreadsheets and formulae, it is helpful if you know a thing or two about databases. AppSheet is a database-driven platform; the concept of the relational database is one of the basic foundations of AppSheet. However, this is not absolutely required, as you learn what you need to know while learning AppSheet.

Converting your ideas into an AppSheet app

We wish to highlight some important concepts before we begin looking at AppSheet.

Whenever you develop apps with AppSheet, your requirements for the application come first. Building apps means that your ideas are converted to AppSheet apps. You should always have an idea of what you want and expect from your app. For example, you may wish to develop an app with a function to help a company’s internal approval process for applications for holidays. You also may wish to add a function to send notifications to concerned parties once the applications are approved.

Once you have a clear idea of what you want, think about what you need to do with the AppSheet Editor. AppSheet provides a wide range of options to customize the behavior of your app. To achieve your goals using the AppSheet Editor, you need to know where in the AppSheet Editor to go and how you need to define your own logic. Finding the shortest paths through the AppSheet Editor is key to making your app development process efficient. To gain that skill, you need to understand AppSheet’s basic processes.

Summary

We hope that you now have an AppSheet account prepared and are ready to start the journey with us. As stated in this chapter, the app-development process consists of certain routine steps, regardless of the kind of app you are trying to create. By learning these essential steps in detail, you will be able to master AppSheet.

In the following chapter, we will start with data preparation and creating a new app, which is always the first step in AppSheet app development. Let’s start learning now!

Left arrow icon Right arrow icon

Key benefits

  • Learn how the AppSheet Editor works to configure, test, and deploy a business app without writing lines of code
  • Get hands-on experience with AppSheet by building a real-world application throughout the book
  • Explore useful tips and tricks to develop custom functionalities in the app to meet unique business needs

Description

Many citizen developers regularly use spreadsheets in their business and day-to-day jobs. With AppSheet, you can take your spreadsheets to the next level by enhancing their ease of use. The platform allows you to run your business efficiently and manage it in the field outside of an office or indoor environment. This book enables you to create your own simple or medium to complex hybrid apps for business or personal use. As a beginner to AppSheet, this book will show you how the AppSheet Editor works and how it is used to configure, test, and deploy an app and share it with others as users or co-authors. You’ll learn about widely used features such as how to use data sources, create app views and actions, construct expressions with AppSheet functions, and make your app secure through security and UX options. Next, you’ll create email/attachment templates and develop reports/documents based on templates, store in the cloud, and send files through emails. You’ll also understand how to integrate third-party services and monitor various usage statistics of your app. As you progress, you’ll explore various features with the help of sample apps that you create using the book. By the end of this book, you’ll have learned how to make the most of AppSheet to build powerful and efficient applications.

What you will learn

Discover how the AppSheet app is presented for app users Explore the different views you can use and how to format your data with colors and icons Understand AppSheet functions such as yes/no, text, math, list, date and time and build expressions with those functions Explore different actions such as data change, app navigation, external communication, and CSV import/export Add/delete and define editing permissions and learn to broadcast notifications and inform users of changes Build a bot through the AppSheet Automation feature to automate various business workflows

What do you get with a Packt Subscription?

Free for first 7 days. $19.99 p/m after that. Cancel any time!
Product feature icon Unlimited ad-free access to the largest independent learning library in tech. Access this title and thousands more!
Product feature icon 50+ new titles added per month, including many first-to-market concepts and exclusive early access to books as they are being written.
Product feature icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Product feature icon Thousands of reference materials covering every tech concept you need to stay up to date.
Subscribe now
View plans & pricing

Product Details


Publication date : Jan 6, 2023
Length 396 pages
Edition : 1st Edition
Language : English
ISBN-13 : 9781803241173
Vendor :
Google
Category :

Table of Contents

20 Chapters
Preface Chevron down icon Chevron up icon
1. Part 1 – Introduction and Getting Started Chevron down icon Chevron up icon
2. Chapter 1: Getting Started with AppSheet Chevron down icon Chevron up icon
3. Part 2 – App Editor and Main Features Chevron down icon Chevron up icon
4. Chapter 2: Understanding App Editor and Data Sources Chevron down icon Chevron up icon
5. Chapter 3: Presenting App Data with UX/Views Chevron down icon Chevron up icon
6. Chapter 4: Manipulating Data with Functions and Expressions Chevron down icon Chevron up icon
7. Chapter 5: Manipulating Data with Behaviors and Actions Chevron down icon Chevron up icon
8. Chapter 6: Controlling App Users and Data Security Chevron down icon Chevron up icon
9. Chapter 7: Managing the App Environment Chevron down icon Chevron up icon
10. Part 3 – Advanced Features and External Services Chevron down icon Chevron up icon
11. Chapter 8: Automating Recurring Data Changes and Scheduling Tasks Chevron down icon Chevron up icon
12. Chapter 9: Using Intelligence and Advanced Features Chevron down icon Chevron up icon
13. Chapter 10: Extending App Capabilities with Third-Party Services Chevron down icon Chevron up icon
14. Part 4 – App Templates and Tricks for App Building Chevron down icon Chevron up icon
15. Chapter 11: Building More Apps with App Templates Chevron down icon Chevron up icon
16. Chapter 12: Tips and Tricks Chevron down icon Chevron up icon
17. Chapter 13: Appendix Chevron down icon Chevron up icon
18. Index Chevron down icon Chevron up icon
19. Other Books You May Enjoy Chevron down icon Chevron up icon

Customer reviews

Filter icon Filter
Top Reviews
Rating distribution
Empty star icon Empty star icon Empty star icon Empty star icon Empty star icon 0
(0 Ratings)
5 star 0%
4 star 0%
3 star 0%
2 star 0%
1 star 0%

Filter reviews by


No reviews found
Get free access to Packt library with over 7500+ books and video courses for 7 days!
Start Free Trial

FAQs

What is included in a Packt subscription? Chevron down icon Chevron up icon

A subscription provides you with full access to view all Packt and licnesed content online, this includes exclusive access to Early Access titles. Depending on the tier chosen you can also earn credits and discounts to use for owning content

How can I cancel my subscription? Chevron down icon Chevron up icon

To cancel your subscription with us simply go to the account page - found in the top right of the page or at https://subscription.packtpub.com/my-account/subscription - From here you will see the ‘cancel subscription’ button in the grey box with your subscription information in.

What are credits? Chevron down icon Chevron up icon

Credits can be earned from reading 40 section of any title within the payment cycle - a month starting from the day of subscription payment. You also earn a Credit every month if you subscribe to our annual or 18 month plans. Credits can be used to buy books DRM free, the same way that you would pay for a book. Your credits can be found in the subscription homepage - subscription.packtpub.com - clicking on ‘the my’ library dropdown and selecting ‘credits’.

What happens if an Early Access Course is cancelled? Chevron down icon Chevron up icon

Projects are rarely cancelled, but sometimes it's unavoidable. If an Early Access course is cancelled or excessively delayed, you can exchange your purchase for another course. For further details, please contact us here.

Where can I send feedback about an Early Access title? Chevron down icon Chevron up icon

If you have any feedback about the product you're reading, or Early Access in general, then please fill out a contact form here and we'll make sure the feedback gets to the right team. 

Can I download the code files for Early Access titles? Chevron down icon Chevron up icon

We try to ensure that all books in Early Access have code available to use, download, and fork on GitHub. This helps us be more agile in the development of the book, and helps keep the often changing code base of new versions and new technologies as up to date as possible. Unfortunately, however, there will be rare cases when it is not possible for us to have downloadable code samples available until publication.

When we publish the book, the code files will also be available to download from the Packt website.

How accurate is the publication date? Chevron down icon Chevron up icon

The publication date is as accurate as we can be at any point in the project. Unfortunately, delays can happen. Often those delays are out of our control, such as changes to the technology code base or delays in the tech release. We do our best to give you an accurate estimate of the publication date at any given time, and as more chapters are delivered, the more accurate the delivery date will become.

How will I know when new chapters are ready? Chevron down icon Chevron up icon

We'll let you know every time there has been an update to a course that you've bought in Early Access. You'll get an email to let you know there has been a new chapter, or a change to a previous chapter. The new chapters are automatically added to your account, so you can also check back there any time you're ready and download or read them online.

I am a Packt subscriber, do I get Early Access? Chevron down icon Chevron up icon

Yes, all Early Access content is fully available through your subscription. You will need to have a paid for or active trial subscription in order to access all titles.

How is Early Access delivered? Chevron down icon Chevron up icon

Early Access is currently only available as a PDF or through our online reader. As we make changes or add new chapters, the files in your Packt account will be updated so you can download them again or view them online immediately.

How do I buy Early Access content? Chevron down icon Chevron up icon

Early Access is a way of us getting our content to you quicker, but the method of buying the Early Access course is still the same. Just find the course you want to buy, go through the check-out steps, and you’ll get a confirmation email from us with information and a link to the relevant Early Access courses.

What is Early Access? Chevron down icon Chevron up icon

Keeping up to date with the latest technology is difficult; new versions, new frameworks, new techniques. This feature gives you a head-start to our content, as it's being created. With Early Access you'll receive each chapter as it's written, and get regular updates throughout the product's development, as well as the final course as soon as it's ready.We created Early Access as a means of giving you the information you need, as soon as it's available. As we go through the process of developing a course, 99% of it can be ready but we can't publish until that last 1% falls in to place. Early Access helps to unlock the potential of our content early, to help you start your learning when you need it most. You not only get access to every chapter as it's delivered, edited, and updated, but you'll also get the finalized, DRM-free product to download in any format you want when it's published. As a member of Packt, you'll also be eligible for our exclusive offers, including a free course every day, and discounts on new and popular titles.