In this video, discover how to use Knack to create fully customizable online databases and web applications without any coding! Follow along as we build an invoice system for the Kevin Cookie Company to track customers, invoices, and even allow customer payments through a user portal. This beginner-friendly tutorial covers everything you need to know—from setting up tables and connecting data to building user roles and front-end pages for employees and customers. By the end, you’ll have the skills to create custom apps like CRMs, customer portals, and purchase order systems that meet your business needs.
⌚ TIMESTAMPS 00:00 - Introduction to Knack 00:57 - Get Started 01:17 - Navigate the Main Knack Interface 01:51 - Create New Blank App 03:00 - Add the Customer Table 03:56 - Add Fields to Customers Table 05:39 - Build the Invoices Table 06:10 - Add Fields to Invoices Table 09:00 - Connect Tables 10:24 - Set Up User Roles 11:28 - Create Records 15:29 - Send Customized Email Reminders with Tasks 18:17 - Review Data Model 19:12 - Build Employee Dashboard Page 20:13 - Customize Employee Dashboard with Views 22:39 - Add Report and Line Chart 24:06 - Set Up User Accounts and Set Permissions 26:25 - Preview Pages 27:23 - Build Customer Portal 28:54 - Enable Payments for Customer Invoices 29:43 - Rename and Adjust App Settings 30:51 - Integrate Knack with Third Party Tools using Flows 37:25 - Create App with AI Builder 38:22 - Wrap Up
🙌 SUPPORT THE CHANNEL - Hit the THANKS button in any video! - Amazon affiliate link: https://amzn.to/3kCP2yz
⚖ DISCLOSURE Some links are affiliate links. Purchasing through these links gives me a small commission to support videos on this channel. The price to you is the same.
