AppSheet Training in Chandigarh

Curriculum:

Module 1: Introduction to AppSheet

• What is AppSheets
• Key features and benefits
• Use cases in different industries
• AppSheet vs traditional app development
• Navigating the AppSheet interface

Module 2: Connecting Data Sources

• Supported data sources (Google Sheets, Excel, SQL, etc.)
• Structuring data for AppSheet
• Connecting and syncing data
• Data types and schema detection

Module 3: Creating Your First App

• Creating an app from Google Sheets
• Customizing views (table, gallery, form, map, etc.)
• Adding and organizing columns
• Understanding UX and UI options
• Saving and deploying the app

Module 4: Working with Data

• Data validation and constraints
• Virtual columns and computed values
• Adding, editing, and deleting records
• Data grouping, sorting, and filtering
• Using slices to control data access

Module 5: Expressions and Logic

• Introduction to AppSheet expressions
• IF, SWITCH, SELECT, LOOKUP, ANY, etc.
• Building conditions and workflows
• Referencing data across tables
• Using context-aware expressions

Module 6: Actions and Workflows

• Creating custom actions (navigation, set values, etc.)
• Action visibility conditions
• Introduction to AppSheet Bots
• Building workflows for notifications, approvals
• Sending automated emails and SMS

Module 7: App Design and UX Enhancements

• ustomizing app theme and branding
• Controlling visibility and behavior of views
• Grouping and formatting rules
• Using icons, quick edits, and custom menuCs

Module 8: User Roles and Security

• AppSheet authentication options
• Adding users and assigning access rights
• Role-based access control (RBAC)
• Securing data with row-level security
• Auditing and monitoring user activity

Module 9: Integrations and External Services

• AppSheet integration with Google Workspace
• Connecting to external APIs using Webhooks
• Integrating AppSheet with Google Maps, Drive, Docs
• Using AppSheet Automation for multi-step processes

Module 10: App Deployment and Maintenance

• App testing and previewing
• Deploying apps and managing versions
• Performance optimization tips
• Backups and recovery
• Managing app lifecycle and users

Module 11: Real-Time Use Cases and Capstone Project

• Build a complete business app (e.g., Inventory, Task Tracker, Field Service App)
• Incorporate UX rules, roles, automation, and data analysis
• Demo presentation and peer review