A hands-on guide to building sophisticated business applications and automation using AppSheet that can deliver business results in a quick time 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
- Useful tips and tricks to develop custom functionalities in the app to meet unique business needs
Book Description
The book enables citizen developers to create their own simple or complex hybrid apps for business or personal use. The book teaches how to combine features together so the app would be efficient and easy to use for the end user. Many Citizen developers regularly use spreadsheets in their business and day-to-day jobs. They can use the AppSheet platform to take their spreadsheets work to the next level of ease of use. AppSheet platform will allow citizen developers to run their business more efficiently and manage it in the field outside of the office or indoor environment.
As the book progresses, readers will learn how the AppSheet editor works and how is used to configure, test and deploy the app. You will learn widely used features such as how to effectively use data sources, create app views, and actions, and how you can make your app secure through security options and user-friendly through UX options. You will learn to create, store in the cloud, and send files through emails. You will learn to integrate third-party services. You will build an app throughout the book discussion so that you get hands-on experience.
By the end of this book, you will be able to build medium-complexity AppSheet apps using the AppSheet features discussed in the book.
What you will learn
- How the AppSheet app is presented for app users, what kind of views you can use and how to format your data with colors and icons
- Understand various Expressions and Formulas such as Math expressions, Text expressions, Time expressions, and so on
- 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, how to broadcast notifications to inform changes to users
- Upgrade app version, view and restore an old app version to the latest current version
Who This Book Is For
This book is aimed at beginner and intermediate citizen application developers in small or medium size businesses and business users who want to develop their own business apps. The readers are expected to have basic knowledge of Google Sheets or Excel and an understanding of different spreadsheet formulas. An added knowledge of SQL and some basic software development knowledge is beneficial but not necessary.
Table of Contents
- Getting started with AppSheet
- Understanding app editor and data sources
- Presenting app data with UX/Views
- Manipulate data with expressions and formulas
- Manipulate data with behaviors and actions
- Controlling app users and data security
- Know and define app environment with Manage tools
- Automate recurring data change or schedule tasks
- Use intelligence and advanced features
- Extend app capabilities with 3rd party services
- Build more apps with app templates
- Tips and tricks to achieve more
- Appendix: Summary - Where to go Next