Releases: automatinginnovatingai/plumbers-app
Plumbers App v2.2.1
Security & Maintenance Update
- Applied the latest bug fixes and security patches
- Updated Python runtime and rebuilt application
- Improved stability, compatibility, and overall performance
Plumbers App v2.2.0
CROSS-APP API INTEGRATION UPGRADE
This release introduces a major enhancement that allows the Inventory App and Payroll App to communicate with the rest of the Automating Innovating AI CRM suite through the backend API. This upgrade improves automation, reduces manual work, and ensures consistent data across all connected apps.
WHAT THIS UPGRADE DOES
The Inventory App and Payroll App can now initiate authenticated API calls to the backend. The backend processes these requests and writes the data into SQL Server or SQL Express using the existing database schema. This enables cross-application workflows such as syncing materials, suppliers, work tickets, employees, and payroll batches.
SUPPORTED APP INTEGRATIONS
The Inventory App and Payroll App can now integrate with:
- Electrician App
- Gutter App
- Handyman App
- Plumbers App
- Production Manager App
- Roofers App
All communication flows through the backend API and into SQL Server, ensuring consistent and centralized data handling.
NEW IN-APP CONTROLS
Both the Inventory App and Payroll App now include dedicated controls that allow users to trigger API-powered operations directly from within the application. These controls follow your existing role-based access control and subscription plan rules.
TECHNICAL EXPLANATION:
The UI now exposes API-triggered operations such as material syncing, supplier syncing, inventory transactions, purchase order creation, employee syncing, work ticket syncing, and payroll submission. All actions are routed through the backend API and stored in SQL Server.
FULL COMPATIBILITY WITH SQL EXPRESS AND SQL SERVER
No database changes are required. The API writes to the same SQL Server instance your apps already use. All existing tables and structures remain unchanged.
ROLE AND PLAN ACCESS
Only the correct roles and subscription plans can use the new API-powered features.
Inventory App:
- inventory_manager
- local_admin
- global_admin
Payroll App:
- payroll_manager
- local_admin
- global_admin
Allowed Plans:
- Pro
- Enterprise
Basic plan users cannot access API-powered features.
SUMMARY
Introduces a powerful integration layer that allows the Inventory App and Payroll App to seamlessly interact with all other CRM apps through the backend API. This upgrade improves automation, reduces manual work, and ensures consistent data across the entire platform, while maintaining full compatibility with SQL Express and SQL Server.
Plumbers App v2.1.0
============================================================
AI SUMMARY AGENT – RELEASE NOTES (v1.0)
This update introduces the new AI Summary Agent, available across all
client applications. The feature allows users to quickly summarize
any text they select or paste, using their available AI tokens.
- Feature Overview
The AI Summary Agent provides fast, on-demand text summarization
directly inside the application. It is designed for simplicity:
the user selects text, opens the AI Summary tool, and receives a
condensed summary based on the chosen length.
This feature does NOT automatically scan files, documents, or
database records. Users manually provide the text they want
summarized. Automatic database summarization may be added in a
future upgrade.
- How Users Access the AI Summary Agent
• Highlight or copy/paste any text inside the application.
• Open the AI Summary Agent panel.
• Choose a summary length (Short, Medium, Long).
• The summary is generated instantly if the user has tokens.
If the user does not have enough tokens, the system will open a
Stripe checkout page where additional tokens can be purchased.
- Summary Length Options
Short – approx. 300 characters
Medium – approx. 800 characters
Long – approx. 1500 characters
These limits ensure fast, consistent summaries across all apps.
- Token Authorization Flow
Before generating a summary, the system checks:
• Company ID
• User key
• Token balance
• Permission to use the AI Summary Agent
If authorized, tokens are deducted and the summary is generated.
If not authorized, the user is redirected to purchase more tokens.
- PDF Export Support
After a summary is generated, users can export the result as a PDF
using the new “Export Summary to PDF” button. This uses the existing
PDF generator already built into the application suite.
- Compatibility Across All Apps
The AI Summary Agent works in all applications where users can
select or paste text. No additional configuration is required.
Future versions may include:
• Automatic summarization of notes/logs stored in the database
• App-specific summary sources via a configuration file
- Notes for Administrators
• No schema changes were required for this update.
• No additional permissions need to be configured.
• Token pricing and descriptions remain managed in Stripe.
• The backend handles token authorization; the app handles text flow.
- Additional Bux fixes
• Additional minor updates to the user interface
• Additional security enhancements
End of Release Notes
Plumbers App
Introducing the Automating Innovating AI Plumbers App
Now Powered by SQL Server Express & Full SQL Server
Includes Inventory Management, Supplier Ordering, and Plumbing-Specific Workflows
The smarter way to manage plumbing jobs, payroll, materials, inventory, and field operations—built for plumbing contractors, service teams, and production crews who want real power without unnecessary complexity. A streamlined, small-business-friendly Operational CRM that keeps your workflow tight, your data accurate, and your team moving.
WHAT’S NEW IN THIS RELEASE
Role‑Based Access Control (RBAC)
All AIAI applications now include a unified, secure RBAC system designed for multi‑admin environments and professional data governance.
Global Admin
Full system access. Can configure company‑wide settings, manage other admins, control data sources, and access all modules.
Local Admin
Operational access only. Can manage day‑to‑day tasks such as employees, jobs, materials, time entries, invoices, or inventory (depending on the app). Cannot modify global settings or create new companies.
Admin‑Only Registration
Only administrators can register accounts. No employee or installer self‑registration is allowed.
Dynamic UI Permissions
Each screen automatically adapts to the user’s role. Restricted modules are hidden or blocked with clear access messages.
Centralized Permission Enforcement
All role checks are handled through a unified RBAC engine to ensure consistent security across every module and workflow.
Multi‑Admin Support
Global Admin customers can add additional administrators using the Admin Add‑on. Each admin receives their own secure login and role‑based access.
This RBAC system ensures secure, scalable, and professional‑grade access control across all AIAI applications.
• Supports SQL Server Express (free) and Full SQL Server
• Faster, more reliable data handling
• Upgraded reporting engine
• Enhanced workflow tools for plumbing operations
• Cleaner UI and smoother navigation
• New Inventory Manager
• New Supplier Ordering System (create POs directly inside the app)
• Material usage tracking per job and per employee
• Consolidated into one unified .exe for all license tiers
No SQLite. No split versions.
Just one powerful SQL-driven plumbing management system.
PLUMBING-FOCUSED FEATURES
INVENTORY MANAGER (All Plans)
• Track fittings, pipe, valves, fixtures, consumables, and truck stock
• Real-time quantity updates
• Low-stock alerts
• Supplier SKU mapping
• Multi-location inventory support (shop, warehouse, trucks)
SUPPLIER ORDERING SYSTEM (Pro and Enterprise)
• Build purchase orders directly inside the app
• Auto-fill supplier SKUs and descriptions
• Track order status (Pending, Ordered, Received)
• Export or print POs for vendors
• Log all material receipts for accurate job costing
MATERIAL USAGE TRACKING
• Assign materials to jobs
• Track usage per employee
• Auto-deduct from inventory
• Improve job costing and reduce waste
AI Assistant
The AI Assistant is a built‑in intelligence engine that analyzes your real job data to help you run your business smarter and faster. It learns automatically from your employees’ performance, job history, and weekly output to deliver instant insights — no setup, no training, no cloud services required.
It can recommend the best employee for each job, estimate job difficulty, suggest the ideal crew size, and even generate a full work schedule with a single click. As you complete more jobs, the AI becomes more accurate, giving you a powerful, always‑improving assistant that works directly inside your CRM.
WHY PLUMBING TEAMS LOVE IT
• Secure Login
Salted + hashed credentials keep your data protected.
• Flexible Payroll Input
Pay by hours, piece rate, fixture installs, or materials.
• Automatic Pay Splits
Instantly divide earnings between up to 4 employees.
• Rich Job Logs
Track builder, jobsite, lot/model, plumbing phase, materials, and product details (Pro & Enterprise).
• Hands-Off Pay Cycles
Set your pay week and let the app generate reports automatically (Pro & Enterprise).
• Monthly Excel Reports
Organized by employee, grouped by pay week.
• Clean CSV Exports
Generate lightweight, portable data files with custom filenames.
• Update-Ready
Enjoy improvements and new features with every release.
• User-Centric Design
Simple interface, guided navigation, and helpful tooltips.
DATABASE OPTIONS (User Selects During Setup)
SQL SERVER EXPRESS (Free)
• Perfect for individuals and small plumbing teams
• Easy installation
• Multi-user capable
• No licensing cost
FULL SQL SERVER (Standard/Enterprise)
• Ideal for medium and large plumbing companies
• No size, memory, or CPU limits
• High-performance, enterprise-grade reliability
• Supports many concurrent users
• Advanced features like SQL Server Agent and HA options
SYSTEM REQUIREMENTS
• Windows 10 or newer
• Microsoft Excel (for Excel exports)
• ~900 MB free space
• SQL Server Express or SQL Server Standard/Enterprise
REPORT EXPORTS
All reports save automatically to:
Documents/AIAI_PM_App/Payroll_Excels/YYYY-MM/Payroll_YYYY-MM.xlsx
Each employee gets their own sheet.
Every job gets its own entry.
Everything stays organized.
BUILT FOR
Plumbing contractors
Service plumbers
Rough-in & trim-out crews
Project managers
Field supervisors
Any plumbing team tracking payroll, jobs, materials, and production data with clarity and control.
QUICK SETUP
Launch the app → Enter your license → Choose SQL Express or SQL Server → Start managing your workflow
SUPPORT & FEEDBACK
Email: automatinginnovatingai@outlook.com
PLANS & ADD-ONS (All Included in One App)
BASIC PLAN
Essential plumbing-production tools for individuals or small teams. Includes workflow tools, task tracking, and standard reporting.
PRO PLAN
Everything in Basic plus deeper reporting, enhanced productivity tools, and more automation. Ideal for growing plumbing companies.
ENTERPRISE PLAN
Unlocks the full system: advanced features, integrations, inventory, supplier ordering, and enterprise-grade controls. Required for organizations with multiple administrators.
ADMIN ADD-ON
Adds additional administrator accounts beyond the main admin included with Enterprise. Requires an active Basic, Pro, or Enterprise plan.
INSTALLER ADD-ON
Available only to Enterprise customers. Provides installer-building and deployment tools for internal or client distribution. Cannot function alone.
TAKE CONTROL. BE EFFICIENT.
Click Buy Now and transform your plumbing workflow with the AIAI Plumbers App.