How to build a projects database (& Automate Assignments)
Want to build a fully functional internal application without writing a single line of code? Softr has evolved beyond just a front-end builder, now you can create databases, automations, and workflows all in one platform, with AI doing most of the heavy lifting. Whether you're routing projects to team members, automating notifications based on priority, or building custom internal tools, you can launch faster than ever before. This tutorial walks you through building a complete projects application from scratch, including two real-world automation workflows that demonstrate both simple assignment logic and complex priority-based routing. 🗝️ Key Takeaways ✅ Build databases, workflows, and user interfaces all inside Softr, no third-party tools required ✅ Use AI prompts to generate application structure in minutes, then refine the details manually ✅ Set up automatic project assignment workflows that trigger when records meet specific conditions ✅ Create branching workflows that route notifications differently based on project priority levels ✅ Sync authentication to custom database tables to manage internal users and project ownership ⏰ Video Chapters: 00:00 - Building a projects app with Softr, AI, and workflows 00:52 - Introduction and free Softr trial offer 01:33 - The 3 layers of every application 02:13 - Database, workflows, and user interfaces explained 03:02 - Why Softr's AI builder changes the process 03:42 - Designing the database structure with AI 04:25 - Defining tables, fields, and linked relationships 05:05 - Configuring login, access, and app settings 05:54 - Reviewing the AI-generated database 06:37 - Fixing issues in the data model 07:24 - Merging users and people into a single structure 08:06 - Connecting authentication to the database 08:45 - Reviewing the AI-generated application 09:23 - Why workflows are the engine behind your app 10:09 - Building a default project assignment workflow 10:49 - Using AI to create automation logic 11:40 - Configuring conditions and owner assignment 12:30 - Testing the project assignment workflow 13:15 - Building a priority-based routing workflow 14:04 - Routing projects based on priority levels 14:54 - Improving triggers and workflow reliability 15:43 - Using branching logic for different outcomes 16:33 - What AI gets right (and where you still need to help) 17:15 - Final thoughts and how to get more help _________________________________________ Tools & Resources Mentioned: Softr - https://get.softr.io/qjiboj Book a FREE Inquiry Call for expert help with Airtable. 👉 https://gapconsulting.fillout.com/inq... 📩 Stay Updated on No-Code Tutorials! Subscribe for the latest Airtable strategies and automation guides. 👉 / @garethpronovost 💬 Have Questions? Drop a comment below—we reply to every question! #GAPConsulting #GarethPronovost #Airtable #Softr

All about Airtable Forms (updated for 2026)

How to Link Two Tables the Right Way in Airtable

Build and deploy a full-stack app using Lovable (everything you need)

Modernize Your Old Airtable Base with Interfaces

How To Think SO CLEARLY People Assume You're A Genius

I Let Claude Clean Up My Messy Airtable Database

💥DIGITALE ID 2026: So schützt du dich JETZT!

I Built a Client Portal in Zite with Stripe, PDFs & ChatGPT

Turing Award Winner: Disagreeing with Google, Postgres, Future Problems | Mike Stonebraker

CLAUDE CODE ADVANCED FULL COURSE (3 HOURS)

Airtable for Beginners: The 5 Features That Power Every Build

How to build your own CRM (start to finish)

Airtable Linked Records Explained (For Absolute Beginners)

If I Were Starting Over in Sales Today, Here’s the Exact Plan

How Senior Engineers Actually Build With AI in 2026 | Build a Full Stack Systems Architecture App

Most Ridiculous Worker Mistakes Caught on Camera

Everything You Need To Know About AI Agents In Airtable

Andrej Karpathy: From Vibe Coding to Agentic Engineering w/ Stephanie Zhan

Why AI Agents are either the best or worst thing we’ve ever built

