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

Tsuji, Koichi; Gurjar, Suvrutt; Miyai, Takuya

Softcover

ISBN 10: 1803241179 ISBN 13: 9781803241173

Publisher: Packt Publishing, 2023

Synopsis

A hands-on guide to building sophisticated business applications and automation using AppSheet to deliver business results quickly without writing lines of code

Key Features

• 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

Book Description

This book enables citizen developers to create their own simple or complex hybrid apps for business or personal use. It shows you how to combine features together to make your app more efficient and easy to use for the end user.

Many citizen developers regularly use spreadsheets in their business and day-to-day jobs. With AppSheet, they can take their spreadsheets to the next level by enhancing their ease-of-use. The platform significantly allows citizen developers to run their business more efficiently and manage it in the field outside of the office or indoor environment.

This book will show you how the AppSheet Editor works and how it is used to configure, test and deploy the app. You’ll learn widely used features such as how to effectively use data sources, create app views, and actions, and make your app secure through security options and user-friendly UX options. Next, you’ll go on to create, store in the cloud, and send files through emails. You’ll also understand how to integrate third-party services. As you progress through the chapters, you’ll build an app to gain hands-on experience.

By the end of this book, you’ll be able to build medium-complexity AppSheet apps using the AppSheet features discussed in the book.

What you will learn

• Discover how the AppSheet app is presented for app users
• Find out what kind of views you can use and how to format your data with colors and icons
• Understand expressions and formulas such as math expressions, text expressions, and time expressions
• Use data change actions for quick data changes of enum columns, on a set or records, to add or edit records in other tables
• Add or delete and define editing permissions, and learn how to broadcast notifications to inform users of changes
• Upgrade an app version, and view and restore an old app version to the latest current version
• Configure, test, and deploy the Appsheet Editor app

Who This Book Is For

This book is for beginner and intermediate citizen application developers in small or medium size businesses and business users who want to develop their own business apps. Basic knowledge of Google Sheets or Excel and an understanding of different spreadsheet formulas are required. Knowledge of SQL and basic software development is beneficial but not necessary.

Table of Contents

1. Getting started with AppSheet
2. Understanding app editor and data sources
3. Presenting app data with UX/Views
4. Manipulate data with expressions and formulas
5. Manipulate data with behaviors and actions
6. Controlling app users and data security
7. Know and define app environment with Manage tools
8. Automate recurring data change or schedule tasks
9. Use intelligence and advanced features
10. Extend app capabilities with 3rd party services
11. Build more apps with app templates
12. Tips and tricks to achieve more
13. Appendix: Summary - Where to go Next

About this title

About the Authors

Koichi Tsuji works as Representative, CEO at Vendola Solutions LLC. He is a AppSheet pro consultant and developer. Koichi also runs the Appsheet community in Japan.

Suvrutt Gurjar works as a Freelancer (AppSheet Solution Architect Partner since 2016). His professional qualifications includes Certification in Google Data Studio (2019-valid till August 2022), Certification in Microsoft Power BI(2017), Six Sigma Green Belt Certification (2015), Project Management Professional from 2005-2018, and Professional, Academy of Healthcare Management (PAHM) certification from AHIP (2012). His educational background includes Electrical Engineering from VJTI, Mumbai.

Takuya Miyai has been working in the IT industry for years with expertise in the Salesforce. He holds a number of Salesforce certifications. After meeting with AppSheet and being fascinated by the possibilities of AppSheet for the coming future, his direction of life has been completely changed. By joining Vendola Solutions LLC, he is actively working as AppSheet professional consultants to help the AppSheet communities and his clients. He is also acting as an active community member with a decent coding background for no-coding solutions

Edition details

• Publisher: Packt Publishing
• Publication date: 2023
• Language: English
• ISBN 10: 1803241179
• ISBN 13: 9781803241173
• Binding: Paperback
• Number of pages: 396