Creating a data model for an app can be a daunting task, especially if you’re more used to flat data structures like spreadsheets. Traditional methods require a deep understanding of data organization, which can be a steep learning curve for many business users. This challenge becomes even more pronounced when trying to leverage low-code platforms […]
With AppSheet, you can create conditional columns that automatically adjust based on specific criteria. In this video, we’ll explore how you can use these features to enhance your applications. Imagine needing to set an initial value for a column that stays the same unless you decide to update it. You can easily do this in […]
In this post, we’ll explore three methods to create dropdowns in Google AppSheet. First, we’ll look at how to make a simple list of choices from predefined options. This method is straightforward and useful for static lists where options don’t change frequently. Next, we’ll dive into pulling options from another table. This is perfect for […]
AppSheet’s ‘AI Extract Rows’ feature allows you to import entire tables of data from PDFs or scanned documents directly into your apps. In this video, I demonstrate this by building a working example from scratch, using a sample credit card statement to guide the setup process. The example illustrates how to set up tables, link […]
Google’s new experimental tool, Opal, offers an innovative way to create visual workflows. While it doesn’t natively integrate with AppSheet, both Opal and AppSheet support Google Sheets, providing a shared platform for collaboration. This common language enables users to harness the power of both tools without direct integration. In the video, I explore how this […]
Managing data in Google Sheets can become unwieldy as you scale your operations. Many business users face common issues such as inconsistent data entry, overly complex formulas linking multiple sheets, and limited functionality on mobile devices. These challenges can hinder productivity and data integrity, making it necessary to find a more robust solution for managing […]