Create Business Applications with AppSheet

Connect data from multiple sources in AppSheet by adding a new data source and syncing changes to the cloud, with a stable data location.

Learn how to structure AppSheet data with four core tables—facilities, inspection points, inspections, and staff—set up permissions, and establish a stable primary key to ensure scalable, reliable app data.

Use date, date-time, and time column types for date- or time-based data, displaying in the device's locale and time zone, with hours, minutes, seconds, am/pm options and durations.

Explore AppSheet column types, including yes/no boolean, enum as dropdown or button list (single or multiple select), and reference, color, and progress columns to track records.

Create deck views to display staff with headshots, sort by fields or related inspections, group by shift, and customize headers, image, and summary with quick text, email, or call actions.

Create a chart view from a slice of the inspections table to visualize failed inspections with a red histogram, supporting multiple chart types and hidden placement for a dashboard.

Explore how AppSheet responds to user events by using built-in and custom actions, workflows, and reports to automate data changes, notifications, and integrations.

Automate internal processes with AppSheet workflows. Email notifications trigger on new inspection records at creation, for failed or passed statuses, to the inspector and their manager.

Learn how app data syncs via the offline in sync tab, moving data between spreadsheets and the app, with sync on start, delayed sync, automatic updates, and delta sync.

Require user sign-in to control who can access your AppSheet app, select authentication sources, and manage a user whitelist with Google Groups or Active Directory to secure data.

Secure data flows by tracking access points, enforcing https-encrypted connections, enabling device-level encryption, and applying sensitive data controls across cloud storage, AppSheet servers, and logs.