Learn to build a complete no-code online database and web application in this comprehensive 39-minute tutorial. Starting with the basics of Knack's interface, progress through creating tables, establishing data relationships, and implementing user roles while building a functional invoice management system. Master essential skills including setting up customer databases, creating employee dashboards with customized views and reports, configuring user permissions, and enabling secure payment processing. Explore advanced features like automated email reminders, third-party tool integration through Flows, and AI-powered app building capabilities. Follow practical examples using a cookie company business case to understand how to develop custom solutions like CRM systems, customer portals, and purchase order tracking applications that can be adapted for various business needs.
Building Online Databases and Web Apps with Knack - A Beginner's Tutorial
Overview
Syllabus
- Introduction to Knack
- Get Started
- Navigate the Main Knack Interface
- Create New Blank App
- Add the Customer Table
- Add Fields to Customers Table
- Build the Invoices Table
- Add Fields to Invoices Table
- Connect Tables
- Set Up User Roles
- Create Records
- Send Customized Email Reminders with Tasks
- Review Data Model
- Build Employee Dashboard Page
- Customize Employee Dashboard with Views
- Add Report and Line Chart
- Set Up User Accounts and Set Permissions
- Preview Pages
- Build Customer Portal
- Enable Payments for Customer Invoices
- Rename and Adjust App Settings
- Integrate Knack with Third Party Tools using Flows
- Create App with AI Builder
- Wrap Up
Taught by
Kevin Stratvert
