The Ultimate Appsheet Course

Plan your database on paper to define essential employee and customer fields, then translate the plan into a spreadsheet and begin building the app.

learn how to build a Google Sheets database for your app with AppSheet, creating employee and customer tables, defining an ID column, and optimizing the sheet for faster app updates.

Explore how to build an Appsheet database, create tables with column names and types, and configure enums and attachments to power enrollment and customer records.

Create apps in Appsheet using the Appsheet database for data integrity over Google Sheets. Add tables like customers and employee, use the editor to build views and validate data types.

Take a quick tour of the new Appsheet editor, explore data and views, use version history, and preview deployment options and security settings.

Explore Appsheet view types and how each displays data, including gallery, deck, dashboard, map, calendar, and table, and how dashboards combine multiple views in one place.

Learn how the table view in AppSheet displays data in rows and columns, supports sorting by fields, grouping, and quick in-place editing to manage customer records like a spreadsheet.

Explore deck view, a card-based interface that displays each record as a card with images, enabling sorting by name, grouping by roles, and actions such as edit.

Explore the gallery view, which displays records as cards with larger images for photo-centric applications, enabling image-based sorting, sizing options, and flexible labeling to showcase people or products.

Use the map view to visualize records on a map from address or lat-long data, enabling geographic insights for customers and supporting multiple views from the same table.

Explore how to create and configure chart views in appsheet, choosing chart types, data columns, and visual features like legends, colors, and zoom for insights.

Learn how the AppSheet calendar view displays date-based events and tasks in month, week, or day layouts for scheduling with start date, end date, start time, and end time considerations.

Explore how the dashboard view in AppSheet combines multiple views into a single customizable screen, including map and gallery panels, with interactive mode and tab options.

Discover how the form view in Appsheet enables entering or editing data with a user-friendly field layout, supporting add and edit operations, with auto save and post-save navigation.

Learn how the detail view automatically displays a row’s information, with header columns, main image, and quick edit columns, and how to turn it into a filtered, navigable information view.

Explore Appsheet card view, its four layouts, and how to customize images, titles, and actions such as edit, delete, and compose email, plus card click behavior.

Build an onboarding view in AppSheet using a presentation deck with image, title, subheader, and text. Create a data table and views to guide users with a finished view.

Explore Appsheet's basic data types, where each column must hold a specific type such as text, long text, number, decimal, percentage, date, time, URL, and yes/no.

Explore enum and enum list in Appsheet. See how enum offers a single predefined choice and how enum list enables multiple selections, with an allow other values option.

Explore how Appsheet stores images and files in Google Drive, saves only the file paths in your data source, and displays media with image, thumbnail, drawing, and signature options.

Explore AppSheet location types—address, lat long, and xy—and learn how each stores locations, supports maps and directions, and uses images or floor plans for precise placement.

Explore the AppSheet show column type, which displays images, text, dates, and YouTube videos without input. Learn to organize content with page sections and tabs, and open forms on desktop.

Learn to use the show column type to create section headers and instructions in forms, and display these in detail view by adjusting the detail view column order.

Explore the show column type in AppSheet to display text and clickable URLs in forms, including using a virtual column to avoid extra database columns.

Learn how the AppSheet show column type displays static images and gifs in your app, using image URLs or hosted assets, and even qr codes.

Show how to display YouTube videos in your AppSheet app using the show column type as video, including embedding the YouTube link and using tutorials or educational content.

Explore the data section in the AppSheet course, learning how data views, tables, and columns relate to Google Sheets and AppSheet database, and how keys, labels, and display settings function.

Learn how references in AppSheet connect tables and pull related data across customers and orders, including creating views, setting initial values, and understanding labels and virtual columns.

Learn how Appsheet uses a key column to uniquely identify each row, using the unique ID formula to generate a static, non-repeating identifier.

Explore how virtual columns in AppSheet are calculated fields that never store inputs. See how formulas in the app editor define them for faster calculations, with totals and last update.

Learn how to use dereference to bring data across AppSheet tables via a reference column, creating virtual columns that pull emails and addresses from related tables.

Discover how to attach multiple items to a single record with Appsheet references, build orders with related items, and calculate totals.

Learn to calculate a list of referenced values by summing the totals to derive the final price. Compare using existing columns with manual saves to virtual columns that auto-calculate.

Create slices in AppSheet to filter data by user, status, or role, and control what each user can see in an app view.

Master formulas and expressions in appsheet to calculate and display values, using initial value, display description, and data validity, while applying formulas in actions and automation.

Explore math expressions in AppSheet by using sum and arithmetic formulas, transforming values into lists, and referencing columns to perform addition, subtraction, multiplication, and division.

Explore text formulas in AppSheet, mastering concatenate, left, right, mid, and len, using virtual columns and the expression assistant to build and test text operations.

Explore essential time expressions and temporal formulas in Appsheet, learning to retrieve current time and date, compute durations, and format dates using text and date time functions.

Explore how Appsheet's if formula uses logical expressions to return true results like open or closed, combine multiple conditions with and/or, and handle value if true or false.

Explore aggregate expressions in Appsheet by pulling data from different tables with lookup and applying any, select, count, and sum to compute prices and quantities.

Explore theme and brand customization in Appsheet: adjust color themes, light/dark modes, logos, header and footer logos, fonts, icons, launch and background images, and GIFs to personalize your app.

Learn AppSheet format rules to customize data appearance with icons, colors, and size. Use context and view type to apply rules in specific views, including gender-based coloring in detail view.

Explore app settings in AppSheet to customize starting views, about descriptions, desktop mode previews, image handling, and localization, empowering you to tailor dashboards, maps, and user experiences.

Learn how AppSheet generates detail, form, and inline views from references, and how reference and system generated views are accessed via actions.

Explore how actions in appsheet enable tasks such as adding, deleting, editing rows, and opening emails or maps, with steps to create and customize actions across tables.

Learn how data actions in Appsheet create and modify rows across tables, set column values, handle references by the ID, and control action display with primary, inline, and confirmation settings.

Learn app type actions in appsheet, including copying and editing rows, exporting and importing CSV data, and setting primary views for customers and products.

Explore the input() formula in Appsheet to open a pop-up window that updates selected columns, including images and files, enabling smartphone-first edits with host and device context.

Explore AppSheet link actions to navigate between app views and external apps. Use link to app, link to view, and link to filtered view with practical examples.

Explore external actions in AppSheet to go to a website, open a file, or start a call, text, or email. Use URL concatenation and file columns for practical emails.

Explore AppSheet automation by building bots and events that trigger predefined actions, such as sending emails or notifications, on data changes like add, update, or delete.

Learn how to create an email automation in AppSheet, selecting the orders table, customizing recipients, and building an HTML email body with test and deployment steps.

Explore building SMS notifications in Appsheet by triggering sends when the amount changes, using row before/after expressions, and choosing between default SMS or Twilio, with country limitations and messaging alternatives.

Configure automations to send push notifications to selected users when product stock updates. Create a customizable notification with a stock-based condition and a deep link to the product detail view.

Create and automate file generation in Appsheet by configuring events, de-referencing related records, and building structured Google Drive folders for each customer and order, with dynamic file naming.