Managing data in Google AppSheet 2024
Google AppSheet 2024
| Beginner
- 12 videos | 53m 22s
- Includes Assessment
- Earns a Badge
Data is at the heart of building apps in Google AppSheet. This course guides you through the essential steps to manage data in Google AppSheet 2024. We start by exploring you how to effectively structure and label your data for use in AppSheet. Next, discover how to configure the tables and columns which your app is built on. See how to set up row keys and reference columns for greater data integrity, and create virtual columns directly within your app. Additionally, the course covers how to filter your tables using slices, connect extra data sources, and work with Google AppSheet databases. By the end of this course, you will be acquainted with the fundamental skills you need to manage the data that makes up your app.
WHAT YOU WILL LEARN
-
Discover the key concepts covered in the managing data in google appsheet 2024 course
Structure and label data in google sheets to create an app in appsheet
Add, remove, and manage tables
Configure table settings and update permissions
Configure column properties
Configure row keys and reference columns -
Create and use virtual columns
Create slices to filter tables
Manage slices and use them in a view
Connect additional data sources
Create a google appsheet database
Manage google appsheet databases
IN THIS COURSE
-
1m 5sThis video outlines the key content covered in the Managing data in Google AppSheet 2024 course. FREE ACCESS
-
3m 58sWhen you are building apps in AppSheet, it's crucial to ensure your data is properly structured and labeled. In this video, we will take a look at how to present spreadsheet data for app creation, focusing on organization, labels for columns and rows, as well as reference columns. FREE ACCESS
-
3. Adding & managing tables in Google AppSheet 20245m 5sWhen you create an app from a Google Sheet, AppSheet always starts with only the first table, but you can easily add additional tables. Once you've added a table, you can then manage it and modify its underlying data as needed. FREE ACCESS
-
4. Configuring table settings in Google AppSheet 20245m 44sGoogle AppSheet allows you to personalize your tables' settings to meet the unique needs of your app. In this video, we will walk you through the different table settings and show you how to configure update permissions for your table. FREE ACCESS
-
5. Configuring column properties in Google AppSheet 20246m 2sIn AppSheet, you can fine-tune the properties of your app's data columns for better data management and user experience. In this video, you will learn how to edit column properties, set data validity rules, configure auto-compute options, and manage update behavior and display settings. FREE ACCESS
-
6. Setting up row keys & reference columns in Google AppSheet 20245m 31sRow keys and reference columns are essential for maintaining the integrity of your data in Google AppSheet. This video covers how to assign unique identifiers for records and establish connections between tables using reference columns. FREE ACCESS
-
7. Using virtual columns in Google AppSheet 20245m 8sVirtual columns in AppSheet are columns that do not physically exist in your data source but are created within the app to perform calculations or derive values dynamically. They are computed fields that update automatically based on changes in other data. They're stored temporarily on the user's device, but not the data sheet. Virtual columns are sometimes created automatically, but in this video we'll see how to add them manually. FREE ACCESS
-
8. Creating slices in Google AppSheet 20244m 35sIn Google AppSheet, slices enable you to filter and customize views of a table. You can create slices to filter specific rows, columns, actions, or any combination of the three. In this video, you will see how to create a slice, filter rows and columns, and configure slice actions and update permissions. FREE ACCESS
-
9. Using & managing slices in Google AppSheet 20244m 13sSlices in Google AppSheet are a great way to create customized views of your data. This video covers how to use slices in views, preview slice data, rename, duplicate, and delete slices. You'll also see how to configure columns, actions, and update permissions for the slice. FREE ACCESS
-
10. Connecting data sources in Google AppSheet 20244m 15sIn AppSheet, you can connect your apps to a wide variety of data sources. In this video, you will learn how to add and remove data sources from your account and integrate them when creating new apps. FREE ACCESS
-
11. Creating databases in Google AppSheet 20243m 6sGoogle AppSheet databases provide a structured way to store and manage your data. This video covers how to create a new database, customize columns, add data, and create an app from your database. FREE ACCESS
-
12. Managing databases in Google AppSheet 20244m 42sOnce you've created an AppSheet database, you have complete control over its contents. In this video, you will see how to edit columns and rows and add tables to your database. FREE ACCESS
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.
